Further explanation of query: show tables;
The database, university, currently has two tables, namely faculties and student.
4) To create a new table in the database currently in use
create table tablename(columnname1 datatype1 constraint1, columnname2 datatype2 constraint2);