Slip7
Guest (gno, gname, no_of_days)
The relationship between Room and Guest is One to One.
Slip 9
Property (pno, desc, area, rate)
Owner (owner_name, addr, phno)
The relationship between owner and Property is One to Many.
Emp(eno ,ename ,designation ,salary,
Date_Of_Joining)
The relationship between Dept & Emp is
one-to-many.
Slip6
Project (pno, pname,
start_date, budget, status)
Department (dno,
dname, HOD, loc)
The relationship
between Project and Department is Many to One.
Customer (cust_no, cust_name, address, city)
The relationship between Customer and Loan is Many to Many
Constraint: Primary key, loan_amt should be > 0.
Slip2
Client
(clientNo, ClientName, addr)
The
relationship between Client & Sales_order is one-to-many.
Constraints:
- Primary Key, ordDate should not be NULL.
Slip3
Hospital (hno ,hname , city, Est_year, addr)
Doctor (dno , dname , addr, Speciality)
The relationship between Hospital and Doctor is one - to – Many
Constraints: - Primary Key, Est_year should be greater than 1990.
Slip4
Patient (PCode, Name, Addr, Disease)
Relationship: - There is one-one relationship between patient and bed.
Constraints: - Primary key, RoomNo must be greater than Bed_No, Addr should not be null.
Slip 8
Book (Book_no, title, author, price, year_published)
Relation between Book and Customer is Many to Many with
quantity as descriptive attribute.
Constraint: Primary key, price should be >0.
Slip10
Employee
(emp_no, name, skill, payrate)
The relationship between Employee and Position is Many to Many with day and shift as descriptive attribute. Constraint: Primary key, payrate should be > 0
Bill (billno, day, tableno, total)
Menu (dish_no, dish_desc, price)
