1. Engineering
  2. Computer Science
  3. 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.

ciot ddress lo l 23.10 z o /8 1299. o 103able f 799.9 Phrthase Porture.id date lo z019-01-I 201-01-1525.00 343 110y 4 209-1-113017

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution