Answered step by step
Verified Expert Solution
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
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 stayedStep 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