In Chapter 5, 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.
In this activity, you need to present and narrate three database environments with two entities. You also need to show the entities of DB with the PK and FK. Out of three scenarios
– At least one scenario should involve 2-attribute PK,
– At least one scenario should have only 1-attribute PK,
– At least one scenario should have PK-FK relationships.
Each attributes should have at least three attributes. See attached file for my examples scenarios. Report your scenarios in a one-page PDF file and submit to D2L. .
-sample report file is attached
The solution has to like that of sample file.
0 comments