Q3) Design a database and write schemas for "online shopping store" using relational model. This

order. The table shows the relationship between the cost of the items on the website and the tot

Hello student, here three tables are given. I have taken their name, table 1, table 2, table 3.

Hello students, we are given a question. Company A manufactures and sells extreme sportier. Its

In this question, there is a case given of IT auditing ABC company and we have to determine what

option A that is connect a variety of different types of information the reason is this is the m

Question

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.

          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.

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(orderdate,
finaldiscount) relation. The orderitems(quantity, itemprice) relation stores the items details of
the orders.

Added by Sheila M.

Question

Please give Ace some feedback