Final project

Topics: Renting, Apartment, Data modeling Pages: 6 (2132 words) Published: January 29, 2014
Database Management Project
MIS 6326
Dr. Radha Mookerjee

                                                                                                                                         GROUP  8 Sheng Liang
Xing Jin
Chung­Jen Chen
Min Yen
Ya­Chen 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

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 multi­family 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, two­stall carwash, business center with high­speed Internet and two of each of the following: resort­style pool, indoor basketball and racquetball courts, lighted tennis and sand volleyball, fitness center with HDTV and indoor Jacuzzi and sauna. Rancho Palisades offer Flex­lease© 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 the employees.

The former process is filled with inefficiency and is time consuming. The while process involves signing a contract and getting resident information down on paper. If there were accidental human error in recording or storing the data of new residents applying, the apartment complex would face a severe problem. Therefore the database is definitely necessary to the apartment complex to prevent such cases of negligence from happening.

The database set up by the apartment complex will help to improve majority of the problems. One of the biggest advantages of having a database is easily removal, updating and accessing resident data for the employees. Also the database provides the function to check errors in contracts and records. Additionally, the apartment complex would gain enormous benefit from this database when the large number of changes in resident records, contracts and rent that happen month in month out. Therefore database management is not only useful in collecting data and recording, but also effective to manage the apartments.

3. Database Scope and Table Design

      The Apartment Table contains details about the apartments in the database. Each apartment has a unique ApartmentNo, which is the primary key in the Apartment Table. The BuildingNo is the foreign key in the Apartment Table, and it references the ApartmentBuilding Table. The Apartment Table consists of the following attributes: AptPrice, SquareFeet, AptGarage, AptNumberOfBeds and AptNumberOfBaths. The AptPrice attribute is the price of the each apartment. SquareFeet attribute is the size of the indicated Apartment. The AptGarage attribute indicates whether the Apartment has a garage, or not. The AptNumberBeds and AptNumberBaths attributes in the Apartment Table indicate the number of bedrooms and bathrooms in each apartment.

ApartmentBuilding Table

The ApartmentBuilding Table includes information about the apartment...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • INT 610 Final Project Document Essay
  • Essay on MBA 610 Final Project 1
  • Final Assignment Essay
  • Art Final Reflection Essay
  • Advance Final Speech Rubric Essay
  • BUS 600 Week 6 Final Paper
  • Exam Topics and Questions (the Final Diagnosis) Essay
  • BUS 680 TRAINING AND DEVELOPMENT Complete Class Includes All DQs Assignments Cases and Final Paper Ashford Latest

Become a StudyMode Member

Sign Up - It's Free