There are 4 parts to this courses assignments. In the first half the course there is 1 assignment that is given in 2 parts (one part or phase per week). The overall intent is to design and implement a fictitious car parking lot management system using HTML, CSS, PHP, and MySQL database engine. Apache should be used as the application server. You may use JavaScript and Bootstrap additionally but must point out where you use it and why you feel it was necessary.
Phase 2:
- Website design extended for new use cases
Add a set of additional web pages to perform the following use cases. You may assume the parking lot attendant checks in and checks out customers.
- View parking garage occupancy (5pts)
- number of open spaces available,
- detailed view of how many spaces remain available on each level.
- Record incoming vehicle (5pts)
- Create a page where the attendant registers incoming car, assume a camera records the license plate of the vehicle and time of entry is recorded, and attendant simply clicks a button to issue a Parking Slip
- Update the internal data as to how many spaces are still available in the lot.
- Park the vehicle on a randomly chosen level as long as there is capacity.
- Record leaving vehicle (5pts)
- Create a web page that the lot attendant uses to checkout the vehicle
- Record the leaving time and calculate parking slip fee due (use hourly rate or part thereof at $1/hour).
- Update the internal data as to how many open spaces remain on which levels.
- Create a top-level menu page (5pts)
This should offer the operator all use cases implemented by you from Assignment 1 and 2, once that operator is logged into the system.
- Database design (5pts)
Implement any extensions to your data model you feel may be needed to support these additional use cases in mySQL. You may still use the following link: as an example to help you define these tables, however do not use everything that is in that data-model as it is not pertinent to this assignment. You may use some of the fields from that data model to guide you as to how to design your tables.
Every web-page must have header and footer and a uniform look at feel (for which you may want to use CSS style sheets).
- The header must display the banner which is made of tiles of images. The title must be displayed on the banner. The title must be ACME Parking.
- The footer must contain the name of the developer and the link which allows the web-user to send feedback to the developer.
- There must be a navigation bar on each page. It must be located on the left-hand side of every page. The navigation bar options vary depending on the categories of functionalities where the web-user is currently at.
- Each main page of each category may display an image icon representing the category of functionalities.
- The default web-sites page must be named index.php. On this page, the navigation bar contains only one Login button.
- Once logged on, the web user can navigate around the web-site using the navigation bar, depending on the privilege.
- While logged in each page must display the user-name who is currently logging on the system.
Each page must be secured and protected from being accessed without logging onto the system.

Leave a Reply
You must be logged in to post a comment.