Question: 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.

Room No. 101 102 103 104 105 106 107 Seating capability 3

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

1 Expert Approved Answer
Step: 1 Unlock

To design an ER diagram for the Marist Librarys Collaboration Room Reservation System we need to ide... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!