Online Parking Booking System Test Phase 2 Solutions & Discussion Due Date Mon 20 Jun, 2016

Problem Statement for project: Online Parking Booking System [Test Phase 2]

Develop a web base parking management system backed up by a relational database (preferred MySQL).

1)      Create first table with the name vehicle and second table with the name parking and establish one to many relationship between them.

Table No 1: Vehicle:       

Column Name	Data Type
vehicleNo[primary Key]	Varchar(12)
model	Integer
made	Varchar(30)
color	Varchar(25)

Column Name	Data Type
parkingID[primary Key]	Integer
dateIn	DateTime
dateOut	DateTime
Amount	Float
parkingSpace	Varchar(10)
vehicleNo [foreign Key from Vehicle table ]	Varchar(12)

      Table No 2: Parking:

 2)     

Create a graphical user interface for allowing the user to add, update, delete and search vehicle record.
Following is a sample screen showing add, update, delete, search, Add parking record options and detail of parking record in the form of table.

3)      The user should be able to search a vehicle record by entering a vehicle No in a textbox after clicking a search button. By clicking a Done button, record of that specific vehicle will be displayed in the textboxes and parking detail of that vehicle will also be displayed in the table.
If record not found then message should be displayed “Record Not Found”.

4)      The user should be able to add parking detail to the vehicle.
For this purpose user will first search a vehicle or add a new vehicle and then after clicking “Add parking Detail” user will be able to add parking detail to a vehicle.

5)      User should be able to add multiple parking details to a specific vehicle.

6)      User should be able to update or delete parking details.

NOTE:

 You can create your own user interface but the main functionality should not be changed.

Remember you have to apply following concepts for the test phase 2:

Syntax and Logical errors
Exception Handling
Class and Object
OOP concepts [Inheritance, Association, Aggregation, Composition, Polymorphism]
Collections
Multi-Dimensional Arrays
Forms/GUIs
Database Operations [Create, Read, Update, Delete etc.]

Preparation Phase 2 pdf file click here download