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.


  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.