E-Parking Administration

Project Overview:

Develop a database and an application that allows the parking administration to analyze trends in usage with respect to users, locations, and time.

Requirements:

1. Design a database to handle multiple users and user-types, multiple clients with multiple lots and spaces within the lots.

2. Construct a GUI interface to the database that allows the administrator to answer various questions. Examples: 

   • What and/or how many spaces are available now?​

   • Who are the users of Lot 31 and how often have they been there in a particular time frame?

   • What are the busiest times in a given Lot #?  

3. A knowledgeable administrator should be able to enter an appropriate query.