ADVANCED DATABASE DESIGN Essay Example

Submitted to:

Prepared By:

ER DIAGRAM

CUSTOMER

CUSTOMER ID

OCCUPATION

VEHICLE DETAILS

VEHICLE
ID

METER READING

VEHICLE TYPE

VEHICLE ID

AVAILABILITY

COST PER MILE

CHAUFFER

DISCOUNT

DISCOUNT
ID

BOOKING DETAILS

BOOKING STATUS

SECURITY DEPOSIT

TELAPHONE

ER- MAPPING

C USTOMER DETAILS

C ustomer Id

Occupation

Telephone

VEHICLE DETAILS

V ehicle Id

Registration number

Meter reading

VEHICLE TYPE

Vehicle id

Cost per mile

Availability

Chauffer

DISCOUNT

Discount Id

Discount Amount

BOOKING DETAILS

Booking Status

Booking Amount

Security Deposit

DATA DICTIONARY

Table Customer Details

	Data Type		Constraint
Customer Id	Auto Number	Long Intager	Primary Key
		Long Intager
Occupation
Telephone		Long Intager

Table Vehicle Details

	Data Type		Constraint
Vehicle Id	Auto Number	Long Intager	Primary key
Registration Number		Long Intager
Meter reading

Table Vehicle Type

	Data Type		Constraint
Vehicle Id	Auto Number	Long Intager	Primary Key
Cost Per Mile	Currency
Availability
Chauffer

Table Discount

	Data Type		Constraint
Discount ID	Auto Number	Long Intager	Primary Key
Discout Amount	Currency

Table Booking Details

	Data Type		Constraint
	Auto Number	Long Intager	Primary Key
Booking Status
Booking Amount	Currency
Security Deposit	Currency

Table Customer Details

Table vehicle Type

Table Vehicle Details

Table Discount

Table Booking Details

FORMS AND REPORTS

Customer details form

Vehicle Details Form

Vehicle Type Form

Discount Form

Booking Details Form

Customer Details Report

Vehicle Details Report

Vehicle Type Report

Discount Report

Booking Details Report