A store has a database of customers and their orders. Each customerhas a name an

Question

A store has a database of customers and their orders. Each customerhas a name and an address. Each order has the same name of theproduct, the cost and the delivery date.

After using the database for a while it is found that any customerwho does not place an order is omitted from the database. Explainhow this problem can be overcome in a suitable relational databasegiving a small relational database for recording information aboutthe customer and their orders. The databe must overcome the problemencountered.

Explanation / Answer

Separate the customer database from the order database Customer database has (Customer_name,Customer_address) Order database has (Customer_name, Product_name, Cost,Delivery_date) Now even if the customers who does not make any orders were deletedfrom the Order database. The information of the customer is alwaysstored in the Customer database which overcomes the problem ofloosing information of the customers who did not make anyorders.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.