Customer < Cust_ID, Fname,Mname,Lname, Email, Phone, fax, Street_Adress, ALT_Add

Question

Customer < Cust_ID, Fname,Mname,Lname, Email, Phone, fax, Street_Adress, ALT_Address,City, State, Country>



Room <Room_Number, Floor, DESC, Status, Single-bedded, Double-bedded, Smoking ,non-Smoking, Daily_Price, Discount>


Reservations < Cust_ID, Checking_Date , Emp_id ,Room_Number, Checkout_Date, FeedBack >


Payments <Payment_ID, Cust_ID, Emp_ID, Room_Number, Payment_Date, Amount >


Employee <Emp_ID, fname, Mname, Lname, City, Street_Adress, ALT_Address, state, Country,phone,Email, Fax>

Explanation / Answer

Script given below to create all the given tables and 3 Views Cust_Reservation , Employee_Reservation and Employee_Payments are created. Hope it will help for your project. Run the below script to create the table and views. create table Customer (Cust_ID Number PRIMARY KEY not null, Fname varchar(25), Mname varchar(25), Lname varchar(25), Email varchar(25), Phone varchar(25), fax varchar(25), Street_Adress varchar(25), ALT_Address varchar(25), City varchar(25), State varchar(25), Country varchar(25) ) Create table Room ( Room_Number Number PRIMARY KEY not null, Floor Number, description varchar(25), Status varchar(25), Single_bedded varchar(25), Double_bedded varchar(25), Smoking varchar(25), non_Smoking varchar(25), Daily_Price Number, Discount Number ) Create table Employee ( Emp_ID Number PRIMARY KEY not null, Fname varchar(25), Mname varchar(25), Lname varchar(25), Email varchar(25), Phone varchar(25), fax varchar(25), Street_Adress varchar(25), ALT_Address varchar(25), City varchar(25), State varchar(25), Country varchar(25) ) Create table Reservations ( Cust_ID Number, Checking_Date date, Emp_ID Number, Room_Number Number, Checkout_Date date, FeedBack varchar(25), FOREIGN KEY (Emp_ID) REFERENCES Employee(Emp_ID), FOREIGN KEY (Cust_ID) REFERENCES Customer(Cust_ID)) Create table Payments ( PaymentId Numeric PRIMARY KEY not null, Cust_ID Number, Emp_ID Number, Room_Number Number, Payment_Date Date, Amount Numeric, FOREIGN KEY (Emp_ID) REFERENCES Employee(Emp_ID), FOREIGN KEY (Cust_ID) REFERENCES Customer(Cust_ID), FOREIGN KEY (Room_Number) REFERENCES Room(Room_Number) ) create view Cust_Reservation as select Checking_Date, EMP_ID from Reservations JOIN Customer on Reservations.Cust_ID = Customer.Cust_ID ; Select * from Cust_Reservation create view Employee_Reservation as select Checking_Date, Employee.EMP_ID from Reservations JOIN Employee on Reservations.EMP_ID = Employee.EMP_ID ; Select * from Employee_Reservation create view Employee_Payments as select Amount, Employee.EMP_ID from Payments JOIN Employee on Payments.EMP_ID = Employee.EMP_ID ; Select * from Employee_Payments

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.