B9IS100 Advance Database
Scope and Requirements for Car Dealership Database
Scope
Sales processing (including basic financing options)
Appointment scheduling for servicing and repairs
Detailed service/repair recording functionality
Service plan management and notifications
The system must store vehicle details, including make, model, year, new/used status, and financing information (if applicable).
The system must allow recording of vehicle sales, including the customer and financing details.
Business Rules and Implementation
Customer Age Verification: A customer must be 18 or older to purchase a car alone. Customers aged 16-17 require a co-signer over 21.
Implementation: Add a CHECK constraint to the Customers table on the Age field:
Parts Stock Control: Parts stock cannot go negative.
Implementation: Use a trigger to prevent updates that would reduce stock below zero:
