Sunday, December 4, 2011

Data Dictionary

Entity
Attribute
Alias
Desription
Data Type
Customer
Name
refers to the customer's name
it contains the first name, midle initial and surname
string
address
refers to the customer's location
it contains the location where the customer can be track
string
contact no.
refers to the customer's phone number
it contains the  personal or business contact number of the customer
number
date
Date
it  contains the date when the customer has a transaction to the establishment
date/time
P roblems
problems
refers to the problem of the vehicle
it contains all the problems of the vehicle that the customer wants to be solved
string
solved
refers to the solved problem of the vehicle
it contains all the solved problems of the vehicle
string
Books
transaction_no
refers to the number of every customer
it contains the number of how many transaction has a customer has
autonumber
plate_no
 refers to the plate_no of the vehicle
it contains the plate_no of the vehicle of the customer
string
date
refers to the date when the customer has a transaction
it contains the the date when the customer has a transaction
 date/time
Vehicle
plate_no
 refers to the plate_no of the vehicle
it contains the plate_no of the vehicle of the customer
string
Engine
refers to the engine name of the vehicle
it contains  the engine name of the vehicle
string
vehicle Name
refers to the vehicle name of the vehicle of the customer
it contains the vehicle name of the vehicle of the customer
string
color
refers to the color of the vehicle
it contains the the color of the vehicle
string

No comments:

Post a Comment