Database Management Project
Dr. Radha Mookerjee
GROUP 8 Sheng Liang
Table of Contents
3.Database Scope and Table Design
4.Entity Relationship Diagram
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 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 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.
The ApartmentBuilding Table includes information about the apartment...
Please join StudyMode to read the full document