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...

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

Extracted text: Order Fom Order number: 1234 Date: 11/04/98 Customer number: 9876 Customer name: Billy Customer address: 456 HighTower Street City-Country: Hong Kong, China ProductNo Desscription Quantity Unit Price A123 Pencil 100 $3.00 B234 Eraser 200 $1.50 C345 Sharpener $8.00