Databases Reference
In-Depth Information
Figure 5-13
MANUFACTURER
Manufacturer
Name
Manufacturer
Country
Sales Rep
Name
Sales Rep
Telephone
CAR
Car Serial
Number
Manufacturer
Name
Model
Year
Class
MAINTENANCE
Repair
Number
Car Serial
Number
Repair
Time
Date Procedure
Mileage
CUSTOMER
Customer
Number
Customer
Name
Customer
Address
Customer
Telephone
RENTAL
Car Serial
Number
Customer
Number
Rental
Date
Return
Date
Total
Cost
Lucky Rent-a-Car database tables.
3.
You are preparing to deploy the database tables shown in Figure 5-13.
This is the logical design for the Lucky Rent-a-Car company's database.
How can you ensure that a legal value is used for the Manufacturer
Name in the CAR table? How can you have Customer Number gener-
ated automatically as a one-up count of customers in the CUSTOMER
table with minimal resource requirements? In the MANUFACTURER
table, how can you ensure that Sales Rep Telephone is formatted
properly?
