E-R Diagram to Relational schema.

For this assignment, you are to develop a relational schema based on the conceptual data model (ER diagram) from E-R diagram below. Your relations should be normalized to the third Normal form.

Use arrows from foreign keys to their corresponding primary keys to show the referential integrity constraints.

IDS410 Fa2018: HWK1 Solution: Realty Property Manager Grp Member PK Staff No PK GroupNo PK Car Allowance City PK Typing Speed Fax Zip Related to PK ClientNo PK PK row 3 PK OwnerNo PK RentalNo Rent Max Rent Pref tvpe PK PropertyNo PK sPaid State Street OwnerType-B RentAmntPK PK is For rent N BusinessType