IDS410- Business Database Technology Assignment #3 Uploaded on: Due On: TBA Instructor: Michael politis Problem Statement For this assignment, you need to implement the logical database design for Realty Property Management Company from the second assignment 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. Submission Instructions After constructing the MS/Access Database and the tables, place the ~.accdb file in a zipped document with a filename composed of your lastname and the last 4 digits of your UIN and upload it using the link provided under assignments HWK3. Thank You Michael Politis STAFF MANAGER Mgr_Staff_No Start_Date Car_ Allowance Monthly_ Bonus BRANCH Branch_No Tel_No Fax_No SECRETARY Sec_Staff_No Typing_Speed VIEWING Property_No Renter_No View_Date Comments PROPERTY_FOR_RENT Property_No Type Rooms Rent Branch_No Responsible_ Staff INTERVIEW Interview_Date Renter_No Staff_No Comments RENTER Renter_No Name Tel_No Pref_Type Max_Rent Branch_No Lease_No Payment_Method LEASE_AGREEMENT Rent Deposit_Amount Is_Paid Rent_Start Rent_Finish Renter_No Staff_No Property_No INSPECTION InspectionDate Comments Staff_No Property_No OWNER Owner_No Name Tel_No Owner_No B_Owner_No OwnerType Contact_Name Advert_No Ad_Date Newspaper_Name Cost ADVERTISEMENT Newspaper_Name Street Tel_No NEWSPAPER Fax_No Contact_Name Ad_Detail Property_No BUSINESS_OWNER NEXT-OF-KIN Kin_Staff_No Name Relationship Tel_No One possible relational schema for Assignment #2 City Zip_Code Street City Zip_Code Street Area City Zip_Code Street City Zip_Code Street City Zip_Code Street City Zip_Code Area ForRent PROPERTY_NOT_FOR_RENT Property_No WithdrawalDate BusinessType Mgr_No GRP_MEMBER Group_No Staff_No ADMIN_GRP Group_No Group_Name Sup_Staff_No Sec_Staff_No Staff_No Name Tel_No Gender DOB SSN Job_Title Salary Joined_ Company_Date Street City Zip_Code Branch_No