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 optional and is not mandated in all scenarios. In this activity, you need to narrate three database environments (book store, tax office, movie database, etc.) 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. See attached file my examples scenarios. Report your scenarios in a one-page PDF file and submit to D2L.