Customer and Loan Table Having One To Many Relationship. Consider the Following Entities and Their Relationship. Customer(cno,cname,city) Loan(lno,loan_amt,no_of_years) Constraints: Primary Key loan_amt should be>0 Reviewed by on November 17, 2013 Rating: 5

Employee and Project Table have Many To Many Relationship. Consider the Following Entities and Their Relationship. Employee(eno,ename,city,deptname) Project(pno,pname,status) Relationship Between Employee and Project is Many to Many with descriptive attribute no_of_days employee worked on that project. Constraints: Primary Key Status to be C-Complete, P-Progressive, I-Incomplete Reviewed by on November 17, 2013 Rating: 5

Student and Teacher Table Having Many to Many Relationship. Consider the Following Entities and Their Relationship. Student(rollno,name,class,totalmarks) Teacher(tno,tname) The Relationship between Student and Teacher is Many to Many with Subject as Descriptive Attricbute. Constraints: Primary Key, Class has to be FY,SY or TY. Reviewed by on November 17, 2013 Rating: 5

Doctor and Hospital Table Have Many To Many Relationship. Consider the Following Entities and Their Relationship. Doctor(dno,dname,dcity) Hospital(hno,hname,hcity) Constraints: Primary Key dcity and hcity should not be Null. Reviewed by on November 17, 2013 Rating: 5

Customer and Account Table Having one To Many Relationship. Consider the Following Entities and Their Relationship. Customer(cno,cname,city) Account(ano,acc_type,balance) Constraints: Primary Key, acc_type not be Null Reviewed by on November 17, 2013 Rating: 5

Employee and Project Table have Many To Many Relationship. Consider the Following Entities and Their Relationship. Employee(eno,ename,city,deptname) Project(pno,pname,status) Relationship Between Employee and Project is Many to Many with descriptive attribute no_of_days employee worked on that project. Constraints: Primary Key Status to be C-Complete, P-Progressive, I-Incomplete Reviewed by on November 17, 2013 Rating: 5