Entity relationship diagram of Car Parking management System.
ERD Car Parking management System Entity relationship diagram
Data Dictionary of Car Parking management System
As this project involves management of database at server side so a database design is also crucial in the design model so that it can easily be deployed in the implementation phase.
Person_tbl
FIELD NAME
DATA TYPE
SIZE
CONSTRAINTS
PID
Varchar
60
PK
Name
Varchar
100
Not Null
Vehicle
Varchar
25
Not Null
Vehicle2
Varchar
25
Not Null
Phone
bigint
13
Not Null
Gender
Varchar
7
Not Null
Person_tbl
Parking_tbl
FIELD NAME
DATA TYPE
SIZE
CONSTRAINTS
ID
Int
255
PK
PID
Varchar
60
Not Null
Name
Varchar
20
Not Null
Vehicle
Varchar
15
Not Null
Date
Varchar
15
Not Null
Timein
Varchar
15
Not Null
Timeout
Varchar
15
Not Null
Parking_tbl
Admin_tbl
FIELD NAME
DATA TYPE
SIZE
CONSTRAINTS
ID
Int
20
PK
Password
Varchar
20
Not Null
Admin_tbl
Operator_tbl
FIELD NAME
DATA TYPE
SIZE
CONSTRAINTS
ID
Int
20
PK
Password
Varchar
20
Not Null
Table 4.4 Operator_tbl
More Helping material for project of Car Parking System
