A local credit union offers car loansto customers on a regular basis. Unfortunately, the credit unionends up repossessing an average of 20 cars per month. Once the carsare repossessed, the credit union sells them to individual buyersto recoup some of their losses.
The cars are placed in a secureparking lot; where potential buyers are invited to inspect thecars. To find out which cars are available each month, potentialbuyers subscribe to a mailing list. If the car looks good, thebuyer puts in a bid to the credit union via email. The highest bidwins the car.
The credit union has been doing thepaperwork for these transactions by hand, but now want acomputerized system. Because you have knowledge in databasedevelopment and Microsoft Access, you have been hired to create adatabase for the monthly auction.
Using the database designrules covered in class, list each rule. Then provide specificdetails when appropriate as you develop the auction database. Whenyou are finished, I should be able to see the tables, fields,datatypes, primary keys, foreign keys, andrelationships.
Consider the following.
- When the bank repossesses a car, anemployee records the year, make and model of the car, the mileage,color and VIN number
- Potentialcustomer information is also recorded; name, address, gender, phonenumber and email address.
- Finally, the bank needs to havesome way of recording the bids that come in. Customers send intheir bids on specific cars. The bids are recorded and the date isnoted.
