Question: Using the Erwin Software (or draw.io) to construct a logical data model using the IE notation to fit the following circumstances. Place all 5 solutions

Using the Erwin Software (or draw.io) to construct a logical data model using the IE notation to fit the following circumstances. Place all 5 solutions in a single Erwin file for convenience Draw data models for the following situations. In each case show also all constraints, cardinalities and verb phrases. Make reasonable assumptions about prime keys, constraints and cardinalities where necessary. a) A School will employ one or more faculty members, but a faculty member can only belong to one School. For each school retain the unique school id and the school name. For each faculty retain the unique faculty id, the faculty name, rank, current salary and their start date. A faculty member must belong to a School b) RU has many majors. Each major can have many students enrolled but a student can only have 1 major. For each major retain the unique major abbreviation, the full major name and its brief description. For each student retain their student id, their name and birth date. However not all students have a major c) The Bay Crest hospital retains data on its beds and their occupancy. Each bed is identified by a combination of the floor level and room

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!