Housing Department system
Problem Description/Scenario
We have been asked to analyze the data requirements and develop an information system for the University Housing Office. After studying the working of the office, it is found that the University Housing office manages five housing compounds. Each compound has about 50 apartments. Each apartment falls into one of the categories given in the table below.
Category Central AC/ Window Unit/ No AC (C/W/N) Single Double (S/D) Furnished (Y/N)
1 C S Y
2 C S N
3 C D Y
4 C D N
5 W S Y
6 W S N
7 W D Y
8 W D N
10 N S Y
11 N S N
12 N D Y
13 N D N
The housing office receives many applications from staff and students requesting an apartment on campus. The university. To be eligible to apply, students must be graduate students and staff member must be a full time employee of the university.
Each applicant can mark three preferences for the compound and apartment type desired. Based on availability, they will be offered an apartment. Applicants can reject the offer. After three rejections, they will have to apply again. A non-refundable fee is required for each application. Notification for vacating premises is required one month prior to the move-out date. Once an apartment is allocated to a student or staff, they keep information about the residents of each apartment. For each resident, we keep his CPR number, name, gender, marital status, college, telephone number, and department of the family head. Note that in each apartment more than family members of a staff or student may live. We also want to keep the information about when a staff/student starts living and when he leaves the apartment. For each applicant (i.e. a student or a staff who has applied for housing but has not yet been
assigned an apartment), we store CPR number, name, gender, address, telephone number, marital status, college, department, preference about the village (the name of the village they want to stay in), preference about the apartment (single bedroom, double bedroom, furnished, unfurnished, etc.), etc.
For each compound, we need to store compound number, block number, road number and area. The information about apartment include apartment number (note you can have the same apartment number in different compounds), number of bedrooms, air-conditioning status (central AC, window unit AC, or no AC), and furniture status (furnished or unfurnished).
Tasks to be done
You are required to do the following tasks:
1. Define the problem of the above system assuming it is a manual system.
2. Write all the functional and functional requirements of the above system.
3. Draw the DFD, ERD, or UML of the above system.
4. Design and implement the main menu to mange the above system.
5. Design and implement all the screens for data entry and reports, according to the descriptions of all entities of the system.
6. Examples of reports:
a. Prepares a list of all the apartments that will be available form a given date. The list provides details about the address, air conditioning status, furniture status, etc. of all the apartments available.
b. List the residents of each apartment.
c. Provides a list of sort the information about the applicants based on their priority level.
d. List all those applicants who have applied for a specific apartment type in a specific compound.
e. List all the apartments in different compounds sorted by their type.
f. List the number of apartment that are allocated and that are not allocated to any one.
g. Display details of all the residents living in all the compounds sorted by compound number and apartment number.
You can enhance the above requirements by adding any new reports or screens.