3.

1 DATA FLOW DIAGRAM:

Level 1:

Select Service
User List of Services Service selection Make Appointment
center

Login/Registration

Level 2:
New Reg
Login/Registration Registration

Login

Select Brach Payment Initial Amount Submit Order Detail

 Level 3:

Add Service Engineer Service engineer Details

Add Service Centers Service Center Details

Admin Offers Combo Offer Submit

Add Services Service Center Add Details

 3.2 Entity Relationship Diagram (E-R Diagram):

Email Password

Name
Email
Id
Admin
Mobile

User

Address

Status
Password

Status Engineer

Service Emp Id

Branch Comments

Name
Mobile Employee
Year Status

Make Email
Email
Designation
Mileage Name
Password Address

Date Services

Time
DATABASE TABLE DESIGN:

REGISTRATION TABLE-
S.No. Column Type Data Type constraints Description

1 Id Int(11) Primary key User Id

2 NAME Varchar(50) null User Name

3 EMAIL Varchar(50) null User Email

4 MOBILE Bigint(15) null User Mobile Number

5 ADDRESS Text null User Address

6 PASSWORD Varchar(50) null User Password

7 STATUS Enum(Active,Deactive) null Account status

8 CREATED AT Timestamp null Created date and time

Login Table-

S.No. Column Name Data type constraints Description

1 ID Int(11) Primary key Login id

2 EMAIL VARCHAR(50) null Email of the login person

3 PASSWORD Text null Password of the login

person

4 ROLE Enum (admin, null Role of who login to the

user) account
REVIEWS TABLE-

S.No Column Name Data type constraints Description

1 ID Int(11) Primary key Review ID

2 NAME VARCHAR(50) null Reviewer Name

3 EMAIL VARCHAR(50) null Reviewer Email

4 BRANCH VARCHAR(50) null Which branch review posted

5 COMMENT TEXT null Message Posted

6 STATUS Enum(Enable, null Status of the review

Disable)

7 POSTED AT Timestamp null Status Posted Date

EMPLOYEE TABLE-

S.No. Column Type Data Type constraints Description

1 ID Int(11) Primary key ID

2 EMPLOYEE ID Varchar(50) null Employee Id to identify the

employee easily
2 NAME Varchar(50) null Employee Name

3 DESIGNATION Text null Which position employee

in the company.
5 ADDRESS Text null Employee address

6 EMAIL Varchar(50) null Employee email for send

any notifications
7 MOBILE Bigint(15) null Mobile number for any
emergency
8 STATUS Enum(Available, null If the employee busy or
Not Available) free
9 CREATED_AT Timestamp null Created Date and time
SERVICE TABLE-

S.No. Column Type Data Type constraints Description

1 ID Int(11) Primary key Service Id

2 BRANCH Text null Service Branch Name

3 YEAR Text null Car Manufacture Year

4 MAKE Text null Car make

5 MILEAGE Text null Car Mileage Per ltr

6 DATE Text null Car Pickup Date

7 TIME Text null Pick Time

8 SERVICE 1 Text null Type of service 1

9 SERVICE 2 Text null Type of service 2

10 SERVICE 3 Text null Type of service 3

SERVICE 4 Text null Type of service 4

NAME Varchar(50) null Service requester name

EMAIL Varchar(50) null User email

MOBILE Bigint(15) null User mobile

COMMENTS Text null Any Queries and

comments
ENGINEER Text null Allocated Service
Engineer Name
STATUS Enum(Pending, null Service Status
Serviced)
CREATE Timestamp null Created Date and time
3.3 GUI DESIGN:

HOME PAGE

HOME ABOUT REGISTRATION LOGIN CONTACT

WELCOME
WELCOME

ABOUT

HOME ABOUT REGISTRATION LOGIN CONTACT

ABOUT US
WELCOME
LOGIN

HOME ABOUT REGISTRATION LOGIN CONTACT

ROLE

HOTEL
EMAIL1 WELCOME
HOTEL 1
PASSWORD

HOTEL 1 LOGIN

HOTEL 1

REGISTRATION

HOME ABOUT REGISTRATION LOGIN CONTACT

NAME

HOTEL
EMAIL1 WELCOME

HOTEL
MOBILE1

HOTEL 1
PASSWORD

HOTEL 1

ADDRESS

SIGN UP

HOTEL 1
3. SYSTEM DESIGN