What are the three different degrees of relationship? Describe the business rule

Question

What are the three different degrees of relationship? Describe the business rules that the following picture depicts Describe the business rules that the following picture depicts Explain many to many relationships and how to deal with them in design. Describe referential integrity. Describe in detail the three delete rules. Consider relations A and B. Relation A represents the entity on the "one side" of a Relation B represents the entity on the "many side" of the one-to-many relationship, relations A and B is cascade.

Explanation / Answer

Ans 8 ) The three different degress of relartionship are as below :

one to many , many to one and many to many.

Ans 9) The businees rules that the picture depicts.

There is a one to many relationship for the department entity as one department can have many professors.

But there is a one to one relationship for the professor department as one professor can work only in one department.

Ans 10) The business rule is : Person ----- married to ------ another person . Here only one entity person is there and it is being repeated as the person is a male which is married to another person that is a female.

Ans 11) Many to many relationships mean that one entity can have many relations with the other entity.

For example, consider the books entity and the authors entity. One book can be written by multiple authors. Also, one author can write multiple books. So, many books can be written or published by many authors.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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