128 131

(e_ssn NUMBER(2) PRIMARY KEY,
e_name varchar2(20),
e_add varchar2(50),
e_dob DATE,
e_salary NUMBER(9),
d_id NUMBER(2) REFERENCES departments(d_id));
----------------------------
CREATE TABLE rooms
(r_no INT PRIMARY KEY,
costs NUMBER(9),
availability NUMBER(1),
h_id NUMBER(5) REFERENCES branches(h_id));
----------------------------
CREATE TABLE customers
(c_id NUMBER(2) PRIMARY KEY,
c_name varchar2(20),
c_add varchar2(50),
c_dob DATE,
c_phone NUMBER(10));
----------------------------
CREATE TABLE dependents
(d_Age NUMBER(3),
ph_no NUMBER(10),
de_name varchar2(20),
e_ssn NUMBER(2) REFERENCES employees(e_ssn));
----------------------------
CREATE TABLE books
(ci_date DATE,
co_date DATE,
bill_amount NUMBER(10),
no_of_people INT,
c_id NUMBER(2) REFERENCES customers(c_id),
r_no INT REFERENCES rooms(r_no));
----------------------------