Oracle9i™ Development by Example

Relational Schema Design and Database Construction

The Auto Sales Tracking application is based on a hypothetical car dealership that repairs used cars and then resells these cars to the public. The sale price of the completed car is based on the original cost of the car plus all the time and repairs. This application tracks all the information necessary: where the car came from, where the parts came from, who the car was sold to, plus all the costs associated with each individual car.

I have used a naming convention here so that the relational objects associated with this application can be easily identified when looking at any data-dictionary view, such as DBA_Tables, or even TAB. Because this is a Sales Tracking application, I chose ST to ...