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:
Customerschema custid firstname, lastname, salespersonid email, storeid
Where:
custid is the customers id
firstname is the customers first name
lastname is the customers last name
salespersonid is the unique id of the salesperson assigned to the customer
email is the customers email address
storeid is the id of the of the store closest to the customer
List all of the possible candidate keys for the customerschema 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 storeid
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
