The physical database can be created using DDL (Data Definition Language) and ma

The physical database can be created using DDL (Data Definition Language) and manipulated
using DML (Data Manipulation Language), which enable users to access or manipulate data
as organized by the appropriate model.
i) Using the CREATE TABLE in any dialect of SQL, show the corresponding SQL
tables. Indicate the primary key, foreign keys, column names, constraints etc.
ii) Insert (at least) 10 sample rows for each identified table.
Student must test their database using at least the following:
– Restriction and Projection
– Aliases
– NULL value handling
– Concatenation
– Comparison Operator
– Logical Operator
– Sorting
– Function ()Group function & Single Row Function
– Joins
– Subqueries