Consider an entity set Person, with attributes social security number (ssn), name, nickname, address, and date of birth(dob). As

Question

2 years ago

7

Consider an entity set Person, with attributes social security number (ssn), name, nickname, address, and date of birth(dob). As

sume that the following business rules hold: (1) no two persons have the same ssn; (2) no two persons have he same combination of name, address and dob. Further, assume that all persons have an ssn, a name and a dob, but that some persons might not have a nickname nor an address.
A) List all candidate keys and all their corresponding superkeys for this relation.
B) Write an appropriate create table statement that defines this entity set.

Computers and Technology

1 answer:

lisov135 [29] · Answer 1 · 2022-10-15T18:40:51+03:00

lisov135 [29]2 years ago

4 0

Answer:

$\pi$

Explanation: