Q3) Design a database and write schemas for "online shopping store" using relational model. This
website allows users to manage companies, products catalogues, customers details and to place
orders.
The database consists of: the company(cname, caddress) relation that is used to store companies
information. each company produces many products(pname, pprice, pdesc).
All customer information is stored in customers(cname, caddress, cemail). Customers can place
orders and the details (excluding items details) will be stored in the orders(order_date,
final_discount) relation. The order_items(quantity, item_price) relation stores the items details of
the orders.