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.

“Library management System” project is going to be developed in Java using MySQL which focuses on to manage library, book information such as selecting and updating books, maintain the record of the students and book rentals, books that are available in library and the location of the book, and deadline of the books.

Business Rules

· There should be no maximum number of books that can be borrowed

· Books must be returned within 4 weeks period

· Borrowers can borrow a maximum of 5 videos

· Videos must be returned within two weeks

· Borrowers can borrow a maximum of four CDs

· Borrowed CDs must be returned within 2 weeks period

· Borrowers are unable to borrow books, CDs or videos if there is time overdue on the borrower’s account

· Borrowers should be invoiced for items that have not been returned (Respack, R. (2019))

When person borrows item following information has to be recorded:

· Member ID#

· Item ID#

· Date borrowed

· Return due date

· Item should be flagged as borrowed

When Item returned:

· Item should be flagged as returned

Borrower’s account Ruling:

· Name (first and last name)

· Address

· Phone

· Email

· Age

· Each borrower has a unique ID# (Member ID)

Borrowing item rules:

· Item ID#

· Title

· Author

· Subject category

· Media type (book, videos, CD etc…) (Respack, R. (2019))

ER Diagram

Media type

Item ID#

Publisher ID

Title