Make an ER Diagram based on this information below NYU needs a new system to manage reservations of study rooms at the ULibrary (UL) . Data requirements for this system are listed as follow: Study rooms are identified by a unique room number (Ex. UL-231). Also, capacity (number of seats in the room), type ('Lab', 'Quiet', 'General'), and status ('Available', 'Reserved' , 'Unavailable') for each room must be stored in the system. The default status for a study room is 'Available'. Some rooms have a projector and others don't. This information is also required to be stored. Students are identified in this system by their unique Bobcat ID. Also their unique NYU student email, name (composed by first, middle, and last name), major, and academic level ('Freshman', 'Sophomore', 'Junior', 'Senior', 'Grad Masters', 'Grad PhD') must be stored for each student. All NYU students will be added to this system no matter they reserve a room or not. Students will be able to create reservations for available study rooms. A reservation is identified by a unique reservation number generated by the system (auto-increment). A reservation must have a start day/time and end date/time. The length of the reservation in minutes should be calculated and stored in the system as well. A reservation must specify the number of students that will be in the study room, including the student making the reservation. Each reservation will be associated only to the student who made the reservation, the other students are not specified. The student who made the reservation should do a check-in on the reservation once the study room has been occupied and that check-in time should also be stored in the system. Students can also add books available at the library to the reservation, and the library's staff will ensure the books added to the reservation will be placed at the study room at the reserved time. Library's books are identified by a unique ISBN number. Also book's title and author(s) must be stored. A book can have more than one author. The system must keep track of books' status to know if it is available or not. All books must have a status specified. A reservation can have multiple books added or none. A book can be added to multiple reservations or not requested by any reservation.
Make an ER Diagram based on this information below
NYU needs a new system to manage reservations of study rooms at the ULibrary (UL) . Data requirements for this system are listed as follow:
Study rooms are identified by a unique room number (Ex. UL-231). Also, capacity (number of seats in the room), type ('Lab', 'Quiet', 'General'), and status ('Available', 'Reserved' , 'Unavailable') for each room must be stored in the system. The default status for a study room is 'Available'. Some rooms have a projector and others don't. This information is also required to be stored.
Students are identified in this system by their unique Bobcat ID. Also their unique NYU student email, name (composed by first, middle, and last name), major, and academic level ('Freshman', 'Sophomore', 'Junior', 'Senior', 'Grad Masters', 'Grad PhD') must be stored for each student. All NYU students will be added to this system no matter they reserve a room or not.
Students will be able to create reservations for available study rooms. A reservation is identified by a unique reservation number generated by the system (auto-increment). A reservation must have a start day/time and end date/time. The length of the reservation in minutes should be calculated and stored in the system as well. A reservation must specify the number of students that will be in the study room, including the student making the reservation. Each reservation will be associated only to the student who made the reservation, the other students are not specified. The student who made the reservation should do a check-in on the reservation once the study room has been occupied and that check-in time should also be stored in the system.
Students can also add books available at the library to the reservation, and the library's staff will ensure the books added to the reservation will be placed at the study room at the reserved time.
Library's books are identified by a unique ISBN number. Also book's title and author(s) must be stored. A book can have more than one author. The system must keep track of books' status to know if it is available or not. All books must have a status specified.
A reservation can have multiple books added or none. A book can be added to multiple reservations or not requested by any reservation.
Step by step
Solved in 4 steps with 1 images
