Library Management System Course Project

 Prepare a page, double-spaced book review as a Microsoft Word document using APA current Edition guidelines. The course project must include a title page, an introduction, the body, summary and conclusion paragraph(s), and a reference page. The template provided for the course project will assist you in ensuring that you are meeting APA paper guidelines. The goal in this course project is to synthesize all your resources learned and demonstrate your knowledge by addressing, discussing, comparing, contrasting, interpreting, and distinguishing the subject matter in your review.

• The course project paper must include a title page, an introduction, business rules, the ER diagrams and the SQL schema, stored procedures, views and triggers and how to run the program and sample screenshots.
• A separate cover page indicating the title of your project, the full name (with e-mail), the course number.
• An introduction section. (same as in proposal).
• Entity Relationship Model diagram using ER notation. Include all the ER diagrams.
• The collection of normalized relations and functional dependencies, and a brief discussion as to the normal form(s) achieved, the methods used to achieve these normal forms.
• The SQL DDL used to create the tables and add primary key and foreign key constraints. (CREATE and INSERT statements).
• All the stored procedures and functions and triggers created in the project.
• Conclusion of what you learned and what can be improved in the project.

Need to include MS file of the Library Management System as well

MISinformation systemInformation Technology

Runninghead: TITLE OF YOUR PAPER

TITLE OF YOUR PAPER (for professional papers) 1

Apartment Rental System

Your Name (First M. Last)

Name of School or Institution

Course Number and Name (for student papers)

Instructor (for student papers)

Date (for student papers)

Introduction

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.

Assumptions

As part of the project, I assume that

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

Each Location exactly only one type of apartment

Business Rules

Some of the business rules are

· 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

Various Entities observed are LOCATION, CUSTOMER, PROPERTY TYPE, RENT and LEASE INFORMATION

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

Implementation

I selected MS Access to implement the database. The tables, form, reports are created using MS Access.

Creating tables

Figure 2: Table created for Location

Forms

Various forms are created to enter the data.

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

References

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.

Lastname, O. (2010). Online journal using DOI (digital object identifier). Main Online Journal Name, Vol#(Issue#), 159-192.

https://doi.org/10.1000/182

Lastname, W. (2009). Title of webpage. Site Name. Retrieved July 3, 2019, from

http://www.example.com

International American University

Week 4 Course Project