Problem Statement: you are to develop a relational schema based on the conceptual data model (ER diagram) from below. Your relations should be normalized to the third Normal form. For your convenience, please use the solution below as the starting point to do this.

The printout of a relational schema for Realty Property Management Company. Use arrows from foreign keys to their corresponding primary keys to show the referential integrity constraints. Use a computer-based graphic tool to draw your relational schema such as www.draw.io or VISIO.

Manager Grp Member PK LocalOfficeNo PK GroupNo PK StartDate Car Allowance Job Titie Typing Speed Relationship Interview PK ClientNo PK InterviewDate InspectDate PK RentalNo Max Rent Pref type Property EndDate StartDate PK PropertyNo PK NewsName Street State Phone ViewDate Comments Duration] Rooms OwnerType B PK AdNo RentAmnt IsForRent Contact WithdrawDate Is For rent-N. Cost BusinessType