DATABASE EXERCISE 10
You are employed by BMG Motors whose main showroom in situated in Newtown. The organization also operates a small showroom in neighbouring Anytown. You are required to key-in two database files for each of the showrooms and keep an up-to-date record of cars purchased and sold to, private individuals.
1. Power your computer on and log-on to DATABASE.
2. Key-in the records as shown below. Give each of your files a separate name. Add your name as the last record in each file.
|1981||X||Vauxhall Chevette Est||Green||43000||24395|
|1980||W||Opel Berlina 2,OS||White||29000||2795|
|1982||Y||Toyota Corolla 1.3||Red||32000||3495|
|1984||A||Ford Orion 1,3||Brown||31000||3950|
|1983||A||Mini Metro City 1.0||White||29000||2995|
|1984||A||Vauxhall Nova 1200L 3-dr||Blue||28000||3050|
|1984||A||Vauxhall Cav 1.6L 5-dr hatch||Red||26000||3000|
|1984||A||Vauxhall Nova 1.2L hatch||Green||30000||3250|
|1981||X||Volvo 244DL Auto||Blue||52000||3495|
|1978||J||Rover 1.6 Auto||White||32000||1995|
|1984||A||Ford Orion 1.3 GL||Blue||30000||4050|
|1981||X||Datsun 1.8G:L Est||Silver||44000||2995|
|1984||A||Vauxhall Nova 1.2L, hatch||Blue||25000||3300|
|1983||A||Vauxhall Astra 1.6GL||Bronze||19000||3995|
|1982||Y||Triumph Acclaim HLS||Green||21000||3595|
3. Print a copy of each file.
4. Print a list all cars whose price is less than 3000.00 and whose mileage is less than 30,000 miles. On top of your list write your name and the set of commands you used to get the listing.
5. On 4th September 3 cars are sold. Showroom 1 sells the Opel Berlina and Showroom 2 sells the Maestro and the Triumph Acclaim. Up-date your file accordingly.
6. Produce a printed listing of all green cars which have done 30000 miles or more. On top of your list write your name and the set of commands you used to get the listing.
7. On 5th September 4 cars are bought. Showroom 1 purchases a 1983 'A' reg white Sierra 1.6L, 5-dr which has done 14,000 miles whose selling price will be 4395 and also buys a 1982 'Y' registration red Cavalier 1.6GLS 5-door hatch, which has done 35,000 miles, whose selling price will be 4295. Showroom 2 purchases a 1979 'V' reg Datsun Cherry Coupe in white which has done 44,000 miles whose selling price will be £1995 and also a 1979 'V' reg blue Volvo Sunbeam 1.6GL hatch which has done 34,000 and is expected to sell at £2995.
8. Update your databases accordingly and produce printed lists for the revised database files. On top of your list write your name and the set of commands you used to get the listing.