ADVANCED DATABASE DESIGN Essay Example

  • Category:
    Other
  • Document type:
    Article
  • Level:
    High School
  • Page:
    1
  • Words:
    219

Submitted to:

Prepared By:

ER DIAGRAM

CUSTOMER

ADVANCED DATABASE DESIGNADVANCED DATABASE DESIGN 1ADVANCED DATABASE DESIGN 2ADVANCED DATABASE DESIGN 3

CUSTOMER ID

OCCUPATION

ADVANCED DATABASE DESIGN 4ADVANCED DATABASE DESIGN 5

VEHICLE DETAILS

VEHICLE
ID

METER READING

ADVANCED DATABASE DESIGN 6ADVANCED DATABASE DESIGN 7ADVANCED DATABASE DESIGN 8ADVANCED DATABASE DESIGN 9

VEHICLE TYPE

ADVANCED DATABASE DESIGN 10ADVANCED DATABASE DESIGN 11ADVANCED DATABASE DESIGN 12ADVANCED DATABASE DESIGN 13

VEHICLE ID

AVAILABILITY

COST PER MILE

ADVANCED DATABASE DESIGN 14

CHAUFFER

ADVANCED DATABASE DESIGN 15

DISCOUNT

ADVANCED DATABASE DESIGN 16ADVANCED DATABASE DESIGN 17

DISCOUNT
ID

ADVANCED DATABASE DESIGN 18ADVANCED DATABASE DESIGN 19

BOOKING DETAILS

ADVANCED DATABASE DESIGN 20ADVANCED DATABASE DESIGN 21ADVANCED DATABASE DESIGN 22ADVANCED DATABASE DESIGN 23

BOOKING STATUS

SECURITY DEPOSIT

TELAPHONE

ADVANCED DATABASE DESIGN 24

ER- MAPPING

CADVANCED DATABASE DESIGN 25ADVANCED DATABASE DESIGN 26 USTOMER DETAILS

CADVANCED DATABASE DESIGN 27 ustomer Id

Occupation

Telephone

VEHICLE DETAILS

VADVANCED DATABASE DESIGN 28 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

ADVANCED DATABASE DESIGN 29

Table vehicle TypeADVANCED DATABASE DESIGN 30

Table Vehicle Details

ADVANCED DATABASE DESIGN 31

Table Discount

ADVANCED DATABASE DESIGN 32

Table Booking Details

ADVANCED DATABASE DESIGN 33

FORMS AND REPORTS

Customer details form

ADVANCED DATABASE DESIGN 34

Vehicle Details FormADVANCED DATABASE DESIGN 35

Vehicle Type Form

ADVANCED DATABASE DESIGN 36

Discount Form

ADVANCED DATABASE DESIGN 37

Booking Details Form

ADVANCED DATABASE DESIGN 38

Customer Details Report

ADVANCED DATABASE DESIGN 39

Vehicle Details Report

ADVANCED DATABASE DESIGN 40

Vehicle Type Report

ADVANCED DATABASE DESIGN 41

Discount Report

ADVANCED DATABASE DESIGN 42

Booking Details Report

ADVANCED DATABASE DESIGN 43