Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you please review the ERD I drew for the scenario attached? I think my cardinalities and possibly some tables are wrong. Please advice on
Can you please review the ERD I drew for the scenario attached? I think my cardinalities and possibly some tables are wrong. Please advice on any corrections needed and feel free to draw a new ERD that shows the corrections. Thanks!
Sketch the ERD for the following scenario: JMU has many buildings on campus. Each building has a unique
Building Id Buildings also have a Building Name and Address. Buildings are classified to determine their
use. Some buildings are classified as Classroom buildings. These buildings have characteristics of Number
of Classrooms, and Total seating capacity. Other buildings may be classified as Office buildings. These
buildings have characteristics of Communication line type, Style, and Staffing Type. A third classification of
buildings is Utility. Utility buildings have a Usage type storage garage, etc and a building Manager.
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