I-1 (3 points) Write an SQL statement that creates a new table raceLap that stores the race Laps name, location, streetName, streetNumber and the length. The primary key being the combination of name and location. The length must be positive and not left blank.

I -2 (4 points) Write an SQL statement to add an attribute difficultyLevel to the relation raceLap. Add an attribute name to the relation race and set name, location to be a foreign key in the relation race references the relation raceLap. In case of lap record is removed from the raceLap, this will reflect on the race table and gets remove. Note values of difficultyLevel are 1,2,3

Car Racer A_id Name 1 Sam 2 Suzan 3 Alice c_id C1 gender Birth_year M 1984 F 1982 F 1980 Manufacturer Hourse_power Mercedes 1000 Ferrari 5000 Mercedes 700 C3 Result result id c_id r_id A_id Time R1_1 C1 R11 400 R1_2 c2R12 600 R1_3 C3 R13 375 Race Rid Type Location R1 F1 UK Rally Cross Portugal R3F1 USA Sponsor R_id C_ID R1C1 R1 03 R2 S ponsor Motorola Pepsi Michelin C4 Schema: Racer: (A id, Name, gender, birth_year) Race (r id, type, location) Result (result id, c_id, A_id,R_id, time) c_id is a foreign key for car and A_id is foreign key for Racer and R_id is a foreign key for Race Sponsor (R id, C iD, Sponsor) Car (c id, make, horsepower)