Answered step by step
Verified Expert Solution
Link Copied!

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.
image text in transcribed

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

Step: 3

blur-text-image

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

Mysql Examples Explanations Explain Examples

Authors: Harry Baker ,Ray Yao

1st Edition

B0CQK9RN2J, 979-8872176237

More Books

Students also viewed these Databases questions

Question

c. What were you expected to do when you grew up?

Answered: 1 week ago