Question: Make an ER model on these tables and include all the relations. Set up a desk for the staff: 1 CREATE TABLE staff ( 2

Make an ER model on these tables and include all the relations.

Make an ER model on these tables and include all the relations.

Set up a desk for the staff: 1 CREATE TABLE staff (2 staff_id NUMBER PRIMARY KEY, 3 name VARCHAR2 (50) NOT NULL, 4

Set up a desk for the staff: 1 CREATE TABLE staff ( 2 staff_id NUMBER PRIMARY KEY, 3 name VARCHAR2 (50) NOT NULL, 4 role VARCHAR2(50) NOT NULL 5 ) ; 6 Create a table for the rooms: CREATE TABLE rooms ( room_number NUMBER PRIMARY KEY, status VARCHAR2(50) NOT NULL ); Create a table for the guests: CREATE TABLE guests ( guest_id NUMBER PRIMARY KEY, name VARCHAR2 (50) NOT NULL, email VARCHAR2 (50) NOT NULL ) j Create a table for the bookings: Create a table for the invoices: \( \begin{array}{ll}1 & \text { CREATE TABLE invoices ( } \\ 2 & \text { invoice_id NUMBER PRIMARY KEY, } \\ 3 & \text { booking_id NUMBER REFERENCES bookings(booking_id), } \\ 4 & \text { amount NUMBER NOT NULL, } \\ 5 & \text { paid_date DATE } \\ 6 & \text { ); } \\ 7\end{array} \) Create a form for adding staff members: Create a form for adding rooms: Create a form for creating invoices: \( \begin{array}{ll}1 & \text { CREATE FORM create_invoice } \\ 2 & \text { ITEMS ( } \\ 3 & \text { BOOKING_ID NUMBER, } \\ 4 & \text { AMOUNT NUMBER, } \\ 5 & \text { PAID_DATE DATE } \\ 6 & \text { ) } \\ 7 & \text { PROCEDURE ( } \\ 8 & \text { INSERT INTO invoices (invoice_id, booking_id, amount, paid_date) } \\ 9 & \text { VALUES (invoices_seq_nextval, :BOOKING_ID, :AMOUNT, :PAID_DATE) } \\ 10 & \text { ) ; } \\ 11 & \end{array} \)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!