Given the following ERD: Branch PK BranchNo Client Staff PK,FK1 StaffNo PK PK St

Question

Given the following ERD: Branch PK BranchNo Client Staff PK,FK1 StaffNo PK PK StaffNo Position Name Address Salary Name Type -H MaxRent DateJoined FK1 BranchNo Gender PhoneNo Manager PK,FK1 StaffNo StartDate Bonus Lease PK,FK1,FK2 StaffNo PK PK,FK1 LeaseNo ClientNo PK,FK2 StaffNo PK PropertyNo FK2 PropertyNo PK OwnerNo MonthlyRent PaymentMethod DepositPaid? Duration StartDate FinishDate Address Type Address PhoneNo MonthlyRent OwnerNo FK1 Identify the following: A strong entity; A weak entity; .A one-to-one relationship; .A one-to-many relationship; A relationship with optional cardinality in at least one direction.

Explanation / Answer

1. Property is the strong entity because without owner also it will be same.

2. PropertyOwner is a weak entity because , without property propertyowner doent exists.

3. Manager and staff is one to one relationship. Because there is a single manager for one specific staff.

4. Propery and PropertyOwner , Staff and Client are One to many relationships. Because one property owner may have multiple properties.

5. Property and Lease are the optional cardinality relationship.

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

---

---

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