- Engineering
- Computer Science
- please hand write this dont do it in sql design...
Question: please hand write this dont do it in sql design...
Question details
(Please hand write this; don't do it in SQL)
Design logical schemas for a Customer-Product relational database that consists of 3 tables. Table “customer” keeps the information about each customer such as gender, age, and address. Table “product” keeps the information about each product such as category, size, weight, and unit price. For a given customer-product pair, table “purchase” keeps the date and amounts for each purchase. Describe table schemas with attribute names, domain constraints, the primary key, and foreign keys (if any).
Below is a picture of my work in progress.
Solution by an expert tutor
