Answer Happy

a What are the primary, candidate, and foreign keys in a relational database? Model some attributes in two entities with a relationship and indicate which one is the primary key, the foreign key, and which one can be a candidate key.