Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started