Question

table User PK User ID Login ID Password Level First Name Middle Name Last Name table Tenant table Employee PK Tenant ID PK Employee ID FK1 User ID Tenant Unit No Building ID Tenant Address Tenant City Tenant State Tenant Zip Tenant Phone FK1 User ID Employee Title Employee Address Employee Age Employee Salary table Work Order PK Work Order ID List Status table Report PK Status ID PK Report ID Status Name FK3 Report ID FK1 nployee ID Assigned Date Finished Date FK2 Status ID Description Cost Feedback FK5 Status ID Service Request Date Service Wanted Date FK1 Tenant ID Description FK2 Location ID FK3 Fixture ID FK4 Problem ID List of Problem List Fixture List Location PK Problem ID PK Fixture ID PK Location ID Type of Problem Fixture Name Problem of Location Joint Fixture & Problem Joint Location & Fixture FK2 Fixture ID FK1 Problem ID FK1 Location ID FK2 Fixture ID

please complete this ERD diagram with proper signs and lines and write all tables in a text format highlighting all PK's and FK's

Answer 1

Tenant TenantID UserID TenantUnitNo BuildingID TenantAddress TenantCity TenantState TenantZip TenantPhone User UserID LoginID Password Level FirstName MiddleName LastName Employee Employeeld UserID Employee Title EmployeeAddress Employee Age EmployeeSalary List_status StatusID Status_Name Report ReportID StatusID ServicrRequestDate ServiceWantedDate Tenanti Description LocationID FixturelD Problemi WorkOrder WorkOrderID ReportID Employeeld AssignedDate FinishedDate Statusid Description Cost Feedback ListOfProblem ProblemID TypeOfProblem ListFixtures FixturelD FixtureName ListLocation LocationID Problem OfLocation JointFixtures And Problem FixturelD ProlemID JointLocation And Fixtures LocationID FixturelD