Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started