Question: Problem 3 . ( 5 0 points ) Consider the following relational database: customer ( customer _ ID , name, address ) product ( product

Problem 3.(50 points) Consider the following relational database:
customer(customer_ID, name, address)
product (product_ID, price)
purchase(purchase_ID, customer_ID, product_ID, quantity, date)
Assume that (i) each customer is assigned a unique ID,(ii) each product is assigned a unique
ID, and (iii) each purchase is assigned a unique ID.
(a)(10 points) Provide an example (a relation instance) which shows that {customer_ID, name}
is a superkey but name
 Problem 3.(50 points) Consider the following relational database: customer(customer_ID, name, address)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!