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).
end time
start time
date
total_amount
status bill
bill id
1
customer id
Customer
has
Bill
has
Billard Table
name
email
hourly_rate
table_type
membership
table id
phone
status
Entities Description
Entity Customer: Contains personal information of the customer
Entity BillardTable: Contains information of the billiard table.
Entity Bill: Contains Bill information including the total cost that customers must pay when using billiard table.
2. (2 points) From the diagram in question 1 write an SQL statement to create table Bills.
Statements must include the maximum possible data constraints on the table fields.The status_bill field can only receive three statuses: C (current), P (paid), and U (unpaid), with the default status being C.
Insert & rows of appropriate data into each newly created table (Other tables are
Close
+ 100%
Zoom
