Tenant TenantID Tenant Integer Y N N None

  Tenant (TenantID, TenantName, Home, maritalstatus, tenancyType, age,Gender, race, disability, incomerange)Property (PropertyID , PropertyType, Size, estate)User (userID,userType)Repairs (RepairID,PropertyID, Location, cost, progress)Rent(RentID,TenantID, PropertyID, Arrears)AntisocialBehaviour (BehaviourID,Description, TenantID)  Data Dictionary is as shown below Field Table Type Primary Key Null Foreign Key Referencing Table TenantID Tenant Integer Y N N None TenantName Tenant text N Y N None Home Tenant text N Y N None maritalstatus Tenant text N Y N None tenancyType Tenant text N Y N None age Tenant Integer N Y N None Gender Tenant text N Y N None race Tenant text N Y N None disability Tenant text N Y N None incomerange Tenant Integer N Y N None userID Tenant Integer N N Y User PropertyID Property integer Y N Y Rent and Repairs PropertyType Property text N Y N None Size Property int N Y N None estate Property text N Y N None userID User integer Y N Y Tenant userType User text N Y N None RepairID Repairs integer Y N N none PropertyID Repairs integer N Y Y Property Location Repairs text N Y N None cost Repairs integer N Y N None progress Repairs text N Y N None RentID Rent integer Y N N   TenantID Rent Integer N Y Y Tenant PropertyID Rent Integer N Y Y Property Arrears Rent integer N Y N none BehaviourID AntisocialBehaviour integer Y N N none Description AntisocialBehaviour text N Y N none TenantID AntisocialBehaviour integer N Y Y Tenant   Tenant (TenantID, TenantName, Home, maritalstatus, tenancyType, age,Gender, race, disability, incomerange)Property (PropertyID , PropertyType, Size, estate)User (userID,userType)Repairs (RepairID,PropertyID, Location, cost, progress)Rent(RentID,TenantID, PropertyID, Arrears)AntisocialBehaviour (BehaviourID,Description, TenantID)  Data Dictionary is as shown below Field Table Type Primary Key Null Foreign Key Referencing Table TenantID Tenant Integer Y N N None TenantName Tenant text N Y N None Home Tenant text N Y N None maritalstatus Tenant text N Y N None tenancyType Tenant text N Y N None age Tenant Integer N Y N None Gender Tenant text N Y N None race Tenant text N Y N None disability Tenant text N Y N None incomerange Tenant Integer N Y N None userID Tenant Integer N N Y User PropertyID Property integer Y N Y Rent and Repairs PropertyType Property text N Y N None Size Property int N Y N None estate Property text N Y N None userID User integer Y N Y Tenant userType User text N Y N None RepairID Repairs integer Y N N none PropertyID Repairs integer N Y Y Property Location Repairs text N Y N None cost Repairs integer N Y N None progress Repairs text N Y N None RentID Rent integer Y N N   TenantID Rent Integer N Y Y Tenant PropertyID Rent Integer N Y Y Property Arrears Rent integer N Y N none BehaviourID AntisocialBehaviour integer Y N N none Description AntisocialBehaviour text N Y N none TenantID AntisocialBehaviour integer N Y Y Tenant

x

Hi!
I'm Mary!

Would you like to get a custom essay? How about receiving a customized one?

Check it out