Computer sciences and Information technology Physical Design
Project description
Need to take design and translate it into an actual database. Once you have done that you know that you will need to enter data to test the database, to make sure it does, in fact, store all the required data.
1. Review your diagram for the database making sure that the design is complete and normalized.
2. Create the database in SQL Server
3. Create the tables in the new database, selecting appropriate data types for the columns, setting a primary key for each table, and setting allow nulls as appropriate.
4. Create a database diagram and create the relationships among tables
5. Add some sample data to each table.
Manager
Building
Apartment
Lease Agreement
Tenant
Rent
Maintenance and Repair
Expenses
ExpensesType
ManagerKey
PK
ManagerLastName
ManagerFirstName
BuildingKey
FK
1
BuildingKey
PK
BuildingName
BuildingAddress
ApartmentKey
PK
ApartmentNumber
ApartmentStatus
BuildingKey
FK
2
ApartmentBuilding
LeaseKey
PK
LeaseStartDate
LeaseEndDate
RentAmount
LateFees
ApartmentKey
FK
1
TenantKey
FK
2
TenantKey
PK
TenantLastName
TenantFirstName
TenantEmailAddress
RentKey
PK
RentAmount
RentDueDate
LeaseKey
FK
1
MaintenanceRequestKey
PK
Date
Description
Cost
Resolution
Tenant Key
FK
1
ExpensesKey
PK
Cost
ExpensesTypeKey
FK
1
attribute name
PK
attribute name
PK
ExpensesTypeKey
PK
Repairs
Maintenance
Utilities
ApartmentCleaning
Insurance
Resolution Date
Deposit
ScholarMatic: Explanation & Answer
Your ready answer from a verified tutor is just a click away for as little as $14.99
Click Order Now to get 100% Original Answer Customized to your instructions!
