TAMUC Automotive Group
The Company
TAMUC Automotive Group is a car dealership that sells used carssuch as Honda, GM, Ford. Recently, the company want to builddatabase system to keep track with its inventory and salesperformance
. Business Requirements
The new database system consists of three separate systems -inventory, customer management, and sales.
Inventory
TAMUC Automotive Group wants to check the current inventorylevel of each used car. Each vehicle has a VIN number that storedin the system to keep track with the vehicle. Each vehicletypically will be shipped from other manufacturers when the numberof vehicle in inventory drops to a certain number. Generalinformation of each car such
OR
OR