The use of foreign keys indicates that you are

This preview shows page 2 - 5 out of 7 pages.

, the use of foreign keysindicates that you are looking at a logical model where a choice has been made touse a relational database, rather than a conceptual model.Replicate the above diagram in your preferred diagramming software package. Onceyou have done that, add all the non-primary key attributes listed in the scenarioabove.Page 2of 7
In this case, if you were to add the foreign keys to the respective entities, can you seeany problems moving from a conceptual model to a logical/relational model? Whatwould you need to do to fix the problem?Page 3of 7
4.Using the above diagram and the business rules below, create an Entity Relationship Diagram using Crow’s Foot notations.oInclude:all appropriate connectivities,all cardinalities andat least the minimum number of attributes required to implement themodeloBusiness Rules:

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture