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 3 rows of appropriate data into each newly created table. (Other tables are available)
3. (2 points) Create a stored procedure Sp_1, used to add new records to the Bill table when customers start playing billiards at a table. Update the table status from 'A'(Available) to 'O' (Occupied).
Zoom
+ 100%
Close
