Subject code: DBI202
Duration: 90 minutes
Requirements:
+ Download the file PE_DBI202.sql and execute it to create the database and the tables that are already in the file.
+ Students should complete their exams in the file named PE_DBI202.sql and submit this file.
+ Submit the exam consisting of 2 files: PE_DBI202.sql and file containing the ERD for question 1.
1. (2 points) There are two entities extracted from the ERD diagram of the Library management system as shown in the diagram. Add the following business requirements to the diagram:
The library system allows borrowers to borrow books and manage the loan process in an efficient way. This system needs to manage more information of the author. A book belongs to only one author, and each author can write one or more books. Each author needs to store information such as: author id, first name, last name,birthdate, nationality.
LoanDate
ReturnDate
due date
title
LoanID
BookID
loans
LoanSlip
genre
Close
+ 134%
Zoom
