Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Marist Library plans to develop a ?Collaboration room reservation system?. Based on the following requirements, design ER diagram. Marist Library currently has 7 group collaboration
Marist Library plans to develop a ?Collaboration room reservation system?. Based on the following requirements, design ER diagram.
Marist Library currently has 7 group collaboration rooms available for reservation for students and faculty. Each room has specific seating capabilities as well as technology support as shown in the following table.
Collaborative Room Policies:
- Rooms are intended for groups and a group is defined as two or more patrons.
- Collaborative rooms could be reserved in advance by calling the Circulation Desk or in person.
- Two patrons must report to the circulation desk and each must present a Marist ID in order to check out a key.
- The minimum reservation time is an hour and the maximum reservation time is three consecutive hours per day.
- The main goal of the system is to better optimize the resources and improve the efficiency by focusing on the size and specific technological needs of the group.
- Library administration would like to receive reports on the usage for each room.
Room No. 101 102 103 104 105 106 107 Seating capability 3 5 3 7 4 5 Im 3 No. of computers Printers 1 2 0 2 0 1 0 0 1 0 1 0 1 0 Whiteboard 0 1 1 1 1 0 0
Step by Step Solution
★★★★★
3.49 Rating (162 Votes )
There are 3 Steps involved in it
Step: 1
The primary keys are underlined that is Patron id Employment id ...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