T3: Data Model

Analysis of Data Needs for Prospective Tenant screening and move-in

The data for the business process is organized in three tables:

• Building info: building name and number (primary key), move in date, move out date, rent deposit, rent amount, and property manager.
• Tenant info: tenant name (primary key), building name and number, phone number, email, pet fee and pet deposit.
• Property Manager: property manager ID (primary key), property manager name, and property manager email.  

Relational Model for Prospective Tenant Screening and move-in:

The tables indicate the specific database needs and relationships among data.  They help keep track of the data and help management make decisions. The columns contain attributes of the tenant system.  Each table contains 4-5 fictitious records. Since there are relationships between the tables a relational database is necessary. The relational database allows the company to easily pull information regarding any tenant, building or manager in questions and understand the connection between all three of them.  The company can create reports, queries and forms using this database to gather business intelligence and make decisions.

Building Information is important for tracking and managing rent increases and for tenant move outs and prospective tenant move in. The primary key is the building name and number. The table identifies the rent amount and ensures a deposit is recorded. The property management assigned to manage that building is also recognized in that table.

Tenant information ensures the company keeps contact info of tenants for any reason they need to contact them. In addition, it tracks the pet fee and deposit, if applicable. The primary key is tenant name.

The Property manager information table contains manager name and contact information. This allows the company to have a record of all the property manager they have and have personal info on file. The primary key is the manager ID.

EXCEL TABLES:

BUILDING INFORMATION

Building name & number	Move-in date	Move-out date	Rent deposit	Rent amount	Property Manager
A-15	9/15/2016	9/15/2017	1,200	1,200	1111
B-10	7/1/2016	7/1/2017	1,200	1,200	1111
F-4	5/23/2016	5/23/2017	1,000	1,000	2222
C-12	3/12/2016	3/12/2017	1,200	1,200	1111
H-7	10/1/2016	10/1/2017	1,000	1,000	2222

TENANT INFORMATION

Tenant name	Building name & number	Phone number	Email	Pet fee	Pet deposit
John Smith	A-15	412-718-6599	John.Smith@gmail.com	45	350
Philip Shoup	B-10	724-668-7878	PShoup123@hotmail.com	45	350
Katie Conner	F-4	724-899-1122	KatieCbobo@gmail.com	90	350
Ruth Jackson	C-12	412-300-9063	Ruth.Jackson@gmail.com	0	0
Anjali Raman	H-7	412-752-2212	Anjalira@yahoo.com	45	350

PROPERTY MANAGER INFORMATION

property Manager ID	property Manager name	property Manager email
1111	Ahmad Ghaznavi	Ahmad.Ghaznavi@rentdelta.com
2222	Pearl Walker	pearl.walker@rentdelta.com
3333	Frank Covelli	frank.covelli@rentdelta.com

ACCESS RELATIONSHIP MAP

Nature of relationship analysis

Each building can house many tenants

Each tenant lives in one building

This is a one -to -many relationship.

Each building is managed by one property manager

Each property manager  manages many buildings.

This is a one-to-many relationship.

Kroenke, David. MIS Essentials. Pearson Education Inc., 2015.