Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me drawing this Draw an EER diagram that shows the entity types, attributes, relationship types, and constraints for a database to capture as

image text in transcribed

Please help me drawing this

Draw an EER diagram that shows the entity types, attributes, relationship types, and constraints for a database to capture as many of these requirements as you can.

A member of the university has a first name, last name, and id. Every member of the university is either a student or an employee, possibly both. Every university employee has a job title and a salary amount. We need to know whether each student is on-campus or online, but either way, we collect the same kind of information and the student enjoys exactly the same privileges. A university building has a name (for example, "Swenson Hall" or "Yellowjacket Union") and address. Buildings can be identified based on their name. A space is a part of a university building. Every space has a label such as "room 3011" or "first floor atrium". Every space also has a maximum capacity (the highest number of people who are allowed to be in the space at the same time). A space can be identified based on the combination of its label and the building it is in, but not by its label alone. An event has a start datetime, end datetime, name, expected number of attendees, and description. An event can be identified based on the combination of its name and start datetime. (Note: a datetime includes both a date and a time; for example, 'February 14, 20227:30PM. Any member of the university can make a reservation of a specific space for a given event; and every event must have a unique space reserved for it. The space reserved for an event must have enough capacity for the expected attendance. A space cannot be reserved for two different events which overlap in time. The university requires a record of every university member who attended the event, including how long they stayed

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

Moving Objects Databases

Authors: Ralf Hartmut Güting, Markus Schneider

1st Edition

0120887991, 978-0120887996

More Books

Students also viewed these Databases questions

Question

model pitch deck on optical 3 D industrial scanner

Answered: 1 week ago

Question

b. Will new members be welcomed?

Answered: 1 week ago

Question

c. Will leaders rotate periodically?

Answered: 1 week ago

Question

b. Will there be one assigned leader?

Answered: 1 week ago