Database Design and Development
Unit 3 IP 1
Unit 3 IP 2
Entity-Relationship Diagram (ERD)
Item_id
Item_description
Item_qty
Item_price
Item_total_price
Order_table
Order_id Order_date
Order_total_price
Item_id
Customer_table
Customer_id
Customer_name
customer_address
customer_city
customer_state
Order_id
One to one item_table and order_table relation
One to one order_table and customer_table relation