Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Applied Regression Analysis And Other Multivariable Methods

Authors: David G. Kleinbaum, Lawrence L. Kupper, Azhar Nizam, Eli S. Rosenberg

5th Edition

1285051084, 978-1285963754, 128596375X, 978-1285051086

More Books

Students also viewed these Databases questions

Question

Who is usually kept in the dark in double-blinded studies?

Answered: 1 week ago