Heaven retirement community

Assignment Help Basic Computer Science

Reference no: EM133940743

Question

The Almost Heaven Retirement Community is a low cost assisted living community for retirees who want some independence but also have options for assistance with things like meal preparation, physical therapy, etc. Currently the complex is made up of five buildings although more will probably be added in the future. The current buildings are named after stars and are: Vega, Rigel, Mimosa, Sirius, and Agena. In each building there are series of apartments identified by letters such as A, B, C, etc. The letters are only unique within a building. For example, there is a Vega A and also a Rigel A. For each apartment, management needs to know the number of bedrooms, whether or not it has a study, whether or not it has a fireplace, and the total square footage which tends to range from 800 to 1400. Each apartment also has a status which is either OCCUPIED, EMPTY, OR COMINGOPEN. Occupied means that there are one or more residents living there with no intention of leaving. EMPTY means the unit is empty and available for someone to lease. COMINGOPEN means that the current occupant or occupants have advised management that they are planning to leave the community. In this case, an available date is known and should be in the records. Information on all leases past and current must be maintained. Each lease for an apartment needs a unique identifier and should be related to a single apartment but one or more residents. The lease will have a start date which is known when the lease is created and an end date which is filled in once the end of the lease is determined, either by someone informing management that they are leaving the facility or because of a death. You are to design a database schema to hold all the information discussed above. Your deliverables are:

A. Data Model Diagram done in Visio, DrawIO, or ERDplus. Please include at least one verb phrase for each relationship. You may include both forward and reverse verb phrases if you wish.

B. A Microsoft Excel spreadsheet with a little bit of sample data for each table. Make sure that your sample data tables agree with your design and that you have enough data to illustrate the nature of each relationship.

Reference no: EM133940743

Questions Cloud

Compute and return the average of three numbers : Write a procedure that will compute and return the average of three numbers.

Car rental business to manage its operations and activities : Enter sample data for a database system that can be used by a Car Rental business to manage its operations and activities.

Many organizations plan for disasters by arranging : Many organizations plan for disasters by arranging for an alternative site where the organization can continue operations if the main location is unable to func

Explain how the technique is applied to data : Summary of your assigned transformation technique. Define the technique, explain how the technique is applied to data

Heaven retirement community : The Almost Heaven Retirement Community is a low cost assisted living community for retirees who want some independence

Our listinterface defines two constructors : Even though our lists will be generic, our ListInterface is not generic. Our ListInterface defines two constructors.

Considering how quickly technology changes : Considering how quickly technology changes, do you think this talk is still applicable to life and technology today? Why or why not?

Database contains information about more than one entity : Two disadvantages to database processing are its complexity and its size. Typically, a database contains information about more than one entity.

What components capabilities and features can include ranks : What component's capabilities and features can include ranks? Which of the following is not commonly implemented as a good security practice?

User Account

All Pages