For this assignment, you need to implement the logical database design for Realty Property Management Company from the diagram below by creating an ACCESS database file that contains 18 tables. Each table corresponds to a relation in the relational schema for the Realty Property Management case, which is included on the last page. Please use this relational schema as your reference to create the ACCESS database file. Once you have created those 18 tables in your database, click the Database Tools Ribbon Tab and then click the Relationships button to create a relational schema based on those 18 tables. Please make sure to construct the Realty Property Management database with all the tables, all their attributes and their Primary and Secondary keys as constraints, necessary to maintain referential integrity of the database.

NEWSPAPER BUSINESS OWNER Newspaper Name Street City Zip_Code Tel_No Fax_No Contact Name B Owner No Contact Name BusinessType One possible relational schema for Assignment #2 ADVERTISEMENT OWNER Advert No Ad_Date Newspaper Name Cost Ad_Detail Property No Owner NQ Name Tel_No StreetCity Zip Code OwnerType PROPERTY PROPERTY NOT FOR RENT Property NQ Street AreaCity Zip Code Type Rooms Rent ForRent Branch No Owner No INSPECTION VIEWI LEASE AGREEMENT Lease No Rent Payment Method Deposit Amounts Paid Rent Start Rent Finish Renter No Staff_No Property No RENTER Renter,No Name Street City | Zip Code | Tel No | Pref. Type | Max Rent Branch No BRANCH INTERVIEW Branch No Street City Zip Code Area Tel_No Fax No Mgr_No Interview Datel RenterN | Staff, No Comments STAFF Staff No Name Street City Zip Code Tel No GenderDOB SSN Job_Title Salary NEXT-OF-KIN ADMIN GRP Kin Statt Nel Name Relationship | Street City Zip-Code Tel-No Group Na Group Name Sup Staff No Sec StaffNo GRP MEMBER Group No Staff No SECRETARY Sec Staff NQ Typing_Speed MANAGER Mor Staff No Start Date