PROFESSIONAL ACADEMIC STUDY RESOURCES WEBSITE 
+1 813 434 1028 
proexpertwritings@hotmail.com
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
Running head: 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 entitycontains
ID
CustomerID
LocationID
ApartmentTypeId
ER Diagram
Figure 1ER diagram
Implementation
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
Overview
In Modules One through Seven of this course, you will watch a series of videos from leaders within the SNHU community. The objective of these videos is to share with you some reflections and insights as they pertain to the participants’ identity, advocacy, leadership, and motivation. Watching the videos and reflecting on the content will contribute to the creation of your own social change identity.
Note: As you progress through the video series and the subsequent module reflections, you will synthesize information provided from various concepts discussed within the context of the videos. Pay particular attention to specific conceptual themes that emerge from the videos. You will use the knowledge acquired in all the videos that you’ve viewed so far to complete each module reflection assignment.