1. Creation of objects Entities and Attributes

2. Creation of Relationship Types

3. Identify and include constraints (Such as not null, unique, Supertype, Subtype.

4. Identify and include Primary Keys, Foreign keys, and unique keys.

From following tables

Table Name: Product

ProductCode	Product_name	Unit_Price
P1	Noodles	30
P2	Rice	900
P3	Coffee	400
P4	Oil	200
P5	Biscuits	60
P6	Dishwasher	90

Table Name: Order Details

Order _id	Product _id	Custom er_id	Customer_nam e	Customer _address	Order_date	Quantity
Ord1	P3	C1	Saroj Karki	Add1	2020-01-20	3
Ord1	P4	C1	Saroj Karki	Add1	2020-01-20	4
Ord2	P5	C2	Rohit Pandey	Add2	2020-04-05	2
Ord3	P3	C1	Saroj Karki	Add2	2020-04-05	1
Ord4	P2	C3	Santos Katuwal	Add3	2020-06-25	5
Ord4	P4	C3	Santos Katuwal	Add4	2020-06-25	4
Ord4	P1	C3	Santos Katuwal	Add2	2020-06-25	4
Ord5	P6	C4	Bidur Khanal	Add1	2020-07-21	2
Ord6	P6	C5	Kusum Tamang	Add5	2020-07-08	1
Ord7	P3	C3	Santos Katuwal	Add5	2020-04-03	6

TableName: Address

Address_i d	Country	Zone	City
Add1	Nepal	Koshi	Itahari
Add2	Nepal	Mechi	Jhapa
Add3	Nepal	Bagmati	Kathmandu
Add4	Nepal	Bagmati	Lalitpur
Add5	Nepal	Koshi	Dharan