Relational Database Design
A) Given the following business rules, identify entity types, attributes (at least two attributes for each entity, including the primary key) and relationships, and then draw an Entity-Relationship Diagram with 1) Entity types, 2) relationship types, 3) keys, 4) cardinality and 5) participation.
The following business rules are given:
Each tenant can submit any number of complaints and each complaint is sent by one or more tenants.
Each management company handles one or more buildings; and each building is managed by one and only one management company.
Each tenant resides in one building; and each building may be the resident of one or more tenants.
B) Optimize the relationships using Associative Entity.
C) Transform the ERD into Relations and apply referential integrity constraints.