Database diagrams 3

Branch Staff Property PrivateOwner BusinessOwner Client Lease Newspaper Manager Supervisor BranchNumber int FK PK Street Text (20) FK PK City Text (15) FK PK Postalcode Text (15) FK PK Telephone Text (12) FK PK StaffNumber int FK PK StaffName Text (20) FK PK Address Text (20) FK PK Position Text (20) FK PK Salary int FK PK PropertyNumber int FK PK Street Text (20) FK PK City Text (20) FK PK Postalcode Text (15) FK PK PropertyType Text (15) FK PK BranchNumber int FK PK NumberofRooms int FK PK MonthlyRent int FK PK StaffNumber int FK PK PrivOwnerNumber int FK PK OwnerName Text (20) FK PK City Text (20) FK PK Postalcode Text (15) FK PK Telephone Text (12) FK PK email Text (25) FK PK Password Text (25) FK PK BusinessOwnerNumber int FK PK BusinessName Text (20) FK PK City Text (15) FK PK Postalcode Text (15) FK PK Telephone Text (12) FK PK email Text (25) FK PK Password Text (25) FK PK ContactName Text (25) FK PK ClientNumber int FK PK ClientName Text (25) FK PK email Text (20) FK PK accomodationType Text (15) FK PK MaximumRent int FK PK Staffnumber int FK PK DateJoined Date/Time FK PK BranchNumber int FK PK LeaseNumber int FK PK ClientNumber int FK PK PropertyNumber int FK PK MonthRent int FK PK MethodofPayment Text (25) FK PK DepositPaid int FK PK DurationofLease int FK PK StartDate Date/Time FK PK EndDate Date/Time FK PK NewspaperNumber int FK PK NewspaperName Text (20) FK PK City Text (20) FK PK Postalcode Text (15) FK PK Telephone Text (12) FK PK ContactName Text (25) FK PK PropertyNumber int FK PK ManagerNumber int FK PK StaffNumber int FK PK BranchNumber int FK PK DateAssumed Date/Time FK PK MonthlyBonus int FK PK M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 SupervisorNumber int FK PK SupervisorName Text (25) FK PK SupervisorNumber int FK PK M1 M2 M3 M4 PropertyNumber int FK PK PropertyNumber int FK PK M1 M2 M3 M4 M1 M2 M3 M4