1 / 1

Add a model to the car type-table: mark “Peugeot”, model “607” and year 2005

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

robert-burns
Download Presentation

Add a model to the car type-table: mark “Peugeot”, model “607” and year 2005

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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 • Add a rent to the rent-table: cust_id 2, reg_no “ACC-223”, rent_date the 12th March, 2005 • Update the new rate 38 of the car with reg_no “BAA-442” • Add the return day the 15th March, 2005 to the rent with reg_no “ACC-223” and cust_id 2 • Show the rows of the car type-table (check that there is the model added in exercise 1) • Show the rows of the rent-table (check that there are the chances made above) • Delete the model in the car type-table with model “607” • Delete the rent with cust_id 2 and reg_no “ACC-223”

More Related