Follow the Instructions to create this website with database

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 Bootsrap additionally but must point out where you use it and why you feel it was necessary.

Phase 1:

1. Database design (10pts)

Design and implement in mySQL a potential data model (of your own design) for the parking lot based on the following requirements:

Implement tables

1. ParkingLot
2. Floor
3. ParkingSlot
4. Customer (who has a vehicle associated with them)
5. ParkingSlip

You may 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.

1. Website initial design (15pts)

Design and implement a set of baseline web pages to perform the following use cases for users that are employees of the parking company and manage the lot. This website is not for customers who are using the parking lot.

1. Home page with an administrator login, and logout
2. Create a new user/operator.
3. Update the details of a user/operator.
4. Delete a user/operator.

Every web-page must have header and footer and a uniform look at feel (for which you may want to use CSS style sheets).

1. 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.
2. The footer must contain the name of the developer and the link which allows the web-user to send feedback to the developer.
3. 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.
4. Each main page of each category may display an image icon representing the category of functionalities.
5. The default web-sites page must be named index.php. On this page, the navigation bar contains only one Login button.
6. Once logged on, the web user can navigate around the web-site using the navigation bar, depending on the privilege.
7. 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.

NOTES:

• Zip up your project folder recursively and attach to this assignment on Black Board.