Final project
Database Management Project
MIS 6326
Dr. Radha Mookerjee
GROUP 8
Sheng Liang
Xing Jin
ChungJen Chen
Min Yen
YaChen Chen
Table of Contents
1.Company Background
2.Problem Statement
3.Database Scope and Table Design
4.Entity Relationship Diagram
5.Database Schema
6.Data Input Screens Forms
7.Contributions
1. Company Background
Rancho Palisades is a privately owned apartment leasing company based in Dallas,
Texas. The leasing company, Management Support, owns and manages approximately 11,000 multifamily apartments with extraordinary amenities in Texas and Arizona. For the past 45 years, Management Support properties have been home to more than 400,000 residents. The company provides an outstanding living experience including the highest level of maintenance and service to its residents.
Located on Frankford Road, Rancho Palisades apartment homes offer unique interiors including plank flooring, vaulted ceilings, ceiling fans with lights and decorative fireplaces. Extraordinary amenities include arcade game room, twostall carwash, business center with highspeed Internet and two of each of the following: resortstyle pool, indoor basketball and racquetball courts, lighted tennis and sand volleyball, fitness center with HDTV and indoor Jacuzzi and sauna. Rancho
Palisades offer Flexlease© terms for any duration up to 14 months including fully furnished guest suites.
2. Problem Statement
With the increase of the population, the apartment complex has enormous growth over the past few years. The huge data that needs to be stored, managed and effectively drawn in request. Given the current information system of recording and storing, our groups directly believe that the execution of a database by the apartment complex would be tremendously helpful and remarkable increase the efficiency of
MIS 6326
Dr. Radha Mookerjee
GROUP 8
Sheng Liang
Xing Jin
ChungJen Chen
Min Yen
YaChen Chen
Table of Contents
1.Company Background
2.Problem Statement
3.Database Scope and Table Design
4.Entity Relationship Diagram
5.Database Schema
6.Data Input Screens Forms
7.Contributions
1. Company Background
Rancho Palisades is a privately owned apartment leasing company based in Dallas,
Texas. The leasing company, Management Support, owns and manages approximately 11,000 multifamily apartments with extraordinary amenities in Texas and Arizona. For the past 45 years, Management Support properties have been home to more than 400,000 residents. The company provides an outstanding living experience including the highest level of maintenance and service to its residents.
Located on Frankford Road, Rancho Palisades apartment homes offer unique interiors including plank flooring, vaulted ceilings, ceiling fans with lights and decorative fireplaces. Extraordinary amenities include arcade game room, twostall carwash, business center with highspeed Internet and two of each of the following: resortstyle pool, indoor basketball and racquetball courts, lighted tennis and sand volleyball, fitness center with HDTV and indoor Jacuzzi and sauna. Rancho
Palisades offer Flexlease© terms for any duration up to 14 months including fully furnished guest suites.
2. Problem Statement
With the increase of the population, the apartment complex has enormous growth over the past few years. The huge data that needs to be stored, managed and effectively drawn in request. Given the current information system of recording and storing, our groups directly believe that the execution of a database by the apartment complex would be tremendously helpful and remarkable increase the efficiency of