Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw a ER Diagram: School needs to keep track of buildings, classrooms within the buildings, the teacher who teaches in the classrooms and the students

Draw a ER Diagram:

School needs to keep track of buildings, classrooms within the buildings, the teacher who teaches in the classrooms and the students that are being taught.

The building will have a unique name. Classroom will have a number. Room size must be at least 800 feet.

Each teacher will have a unique number and a phone number (cell and home)

Each student will have a unique number and an age.

Each building has at least one but can have many classrooms. Each classroom is located in one building.

Teacher can teach in many classrooms, or none. A classroom can be used for teaching by many teacher, or none. A teacher can teach many students (not more than 15), or none. Student is taught by one teacher.

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

Refactoring Databases Evolutionary Database Design

Authors: Scott Ambler, Pramod Sadalage

1st Edition

0321774515, 978-0321774514

Students also viewed these Databases questions

Question

Comment should this MNE have a global LGBT policy? Why/ why not?

Answered: 1 week ago