Question: we cover primary and foreign key for entities. Each entity in a DB environment should a primary key (PK). A PK attribute cannot be null.
we cover primary and foreign key for entities. Each entity in a DB environment should a primary key (PK). A PK attribute cannot be null. However, a foreign key (FK) is not mandated by all scenarios.
In this activity, you need to narrate each of three database environments with two entities and show the entities of DB with the PK and FK. Out of three scenarios
- At least one should involve 2-attribute PK,
- At least one should have only 1-attribute PK
- At least one should have PK-FK relationships.
Each attributes should have at least three attributes. Report your scenarios in a one-page PDF file.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
