Durations: 85 minutes
☑Kizspy.me
Requirements:
+ Download the file PE_DBI202.sql and execute it to create the database and the
tables that are already in the file.
+ Students must complete their exams in 2 files: file named PE_DBI202.sql for sql
code and word file PE_DBI202.docx containing the ERD for question 1.
1. (2 points) There are 4 entities extracted from the ERD diagram of the Library Book
Management System, as shown below. Add the following business requirements to
the diagram:
An Employee can handle multiple borrow records (1: N). The Employee should have
EmployeeID, Name, Phone, Position.
(Add to the existing diagram in the exam).
Use the diagram below to complete question 1 (you can draw it in MS Word).
Zoom
+100%
Close
