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