write clearly use SQL . PLEASE EXPLAIN ALL THE STEPS CLEARLY.

Lab Assignment-3 (DBMS) 25/01/2018 Create the following tables tarting primary key, foreign key, not null, unique, check Owner (driverold name, address, Lloanse year) car (License model) accident report-member date, location) participatet (driver-it model, Esport-number damage-amount) (a) Add a column "contact_no" and "age" in table Owner with conditions that all phone numbers must be unique and age-18. (b) Create a view to show the names, address, driver-id having Mercedes brought on 2019. Find the names, driver-id, car model, location and damage amount of those involved in accidents. (d) Find the number of people who owned cars that were involved in accidents in 2018. (e) Find the number of accidents in which the cars belonging to "John Smith" were involved. (Delete the records of Lamborghini belonging to "John Smith" (8) Update the damage amount for the car with license number "H10-9492" in the accident with report number "AR2197" to 30,000/- (h) Delete the column contact_no from Owner. Syntax for commands: Not mull: create table tablet_Htme (attribute_htme attribute_type not null) Count: select count distinct attribute_name) from tablel_jume 1, table2_name 12 where tattribute-t2.attribute2 select count(distinct") from table_meme Alten alter table table_nam add attribute_name attribute type Check create table tablet_name (attute_mame attribute_type check(condition) Unique create table tablet_jennie (attribute_name attribute_type unique)