Library Management System Course Project

Renting apartments is common in the cities. Various agencies are available for apartment rental. The apartment pricing changes from location to location and on the type of apartment. On average most of the apartment rates are fixed. In this project we create an apartment rental system where users can look for apartments based on the location.

Each location has only one Property, not more than one.

Each Location exactly only one type of apartment

Business Rules

· User can rent only one apartment.

· Electricity bill must be separate from rent.

· One month rent must be deposited.

· One month advance notice must be given by the customers.

· If the lease is not renewed it automatically turns into monthly.

· Rent must be paid by 5th of each month.

· Users can rent for monthly or yearly.

Tables and Columns

LOCATION entity contains the following attributes

· LocationID

· Address

· City

· State

· Zipcode

· Property name.

CUSTOMER entity contains the Following attributes

· CustomerID

· first name

· last name

· phone number

APARTMENT TYPE entity contains the following attributes

· ApartmentTypeID

· Apartment type,

· Rent

LEASE INFORMATION entity contains

· ID

· CustomerID

· LocationID

· ApartmentTypeId

ER Diagram

Figure 1ER diagram

Creating tables

Figure 2: Table created for Location

Forms

Customer Form is used to enter customer data. Figure [2] shows the screenshot of customer form.

Figure 3: Form to enter Location details

Reports

Various reports created. They are report to find customers at each locations. Figure[] shows the screenshot of the reports.

Figure 4: report that shows users at each location

Conclusion

Future Work

Lastname, C. (2008). Title of the source without caps except Proper Nouns or: First word after colon. The Journal or Publication Italicized and Capped, Vol#(Issue#), Page numbers.