Question: Draw an ERD ( table style ) for a library s study room booking database. In brief, library patrons can book study rooms for non

Draw an ERD (table style) for a librarys study room booking database. In brief, library patrons can book study rooms for non-commercial use. The library holds records of patrons by their pid, first name, last name, and email address. Study rooms are managed by their room number, number of seats, and multimedia devices. A typical study room would have a 32-inch flatscreen, while some rooms are equipped with a projector. Study room book record includes record id, pid, room number, date, and time. You do not need to reflect cardinalities in your ERD. Please clearly mark each entity's attributes, primary key (PK), and foreign key (FK).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 Programming Questions!