Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David Kroenke

4th Edition

0136086535, 9780136086536

More Books

Students also viewed these Databases questions

Question

6. What is process reengineering? Why is it relevant to training?

Answered: 1 week ago