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 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 3 entities extracted from the ERD diagram of the billiard club management system as shown in the diagram.
Add the following business requirements to the diagram: A bill can include multiple services and each service used by customers is linked to the corresponding bill during their billiards session. The system also specifies the quantity of each service consumed in association with that bill. Each service will include information such as service ID, service name, unit of measurement, and price. (Add to the existing diagram in the exam).
Use the diagram below to complete question 1 (you can draw it in MS Word).
start time
end time
date
customer id
Customer
has
Bill
n
has
BillardTable
name
email
hourly_rate
table type
membership
table id
phone
status
100%
Zoom
total_amount
status bill
bill id
1
Close
