add a model to the car type-table: mark “peugeot”, model “607” and year 2005
DESCRIPTION
Exercises. Add a model to the car type-table: mark “Peugeot”, model “607” and year 2005 Add a car to the car-table: reg_no “CCC-999” and model_id 5 Add the rate 40 to the car with reg_no “CCC-999” and model_id 5 - PowerPoint PPT PresentationTRANSCRIPT
1 / 1
1. Add a model to the car type-table: mark “Peugeot”, model “607” and year 2005
2. Add a car to the car-table: reg_no “CCC-999” and model_id 5
3. Add the rate 40 to the car with reg_no “CCC-999” and model_id 5
4. Add a rent to the rent-table: cust_id 2, reg_no “ACC-223”, rent_date the 12th March, 2005
5. Update the new rate 38 of the car with reg_no “BAA-442”
6. Add the return day the 15th March, 2005 to the rent with reg_no “ACC-223” and cust_id 2
7. Show the rows of the car type-table (check that there is the model added in exercise 1)
8. Show the rows of the rent-table (check that there are the chances made above)
9. Delete the model in the car type-table with model “607”
10. Delete the rent with cust_id 2 and reg_no “ACC-223”
Exercises