Question: Given the following schema for a customer relation: Customer - schema = ( cust _ id , first _ name, last _ name, salesperson _

Given the following schema for a customer relation:
Customer-schema =(cust_id, first_name, last_name, salesperson_id, email, store_id)
Where:
cust_id is the customers id
first_name is the customers first name
last_name is the customers last name
salesperson_id is the unique id of the salesperson assigned to the customer
email is the customers email address
store_id is the id of the of the store closest to the customer
List all of the possible candidate keys for the customer-schema when ALL OF the following constraints are
imposed. Note that since all of the constraints must hold, you should produce only one list.
a. Each customer will be represented by exactly one tuple
b. Each customer has a unique id
c. No two customers will have the same email address
d. A salesperson will not be assigned two customers with the same name
e. A salesperson will be based out of a store and all of the salespersons customers will have the
same store_id
f. A store can have any number of cutomers

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!