Question $5(10$ points$)$

For the database schema below, write SQL DDL corresponding to the schema. Make any reasonable assumptions about data types, and be sure to declare primary and foreign keys.

person $($driver id$,$ name, address$)$

car $($license$,$ model, year$)$

accident $($report number, date, location$)$

owns $($driver id$,$ license$)$

participated $($report number, license, driver id$,$ damage amount$)$

Question $6(4$ points$)$

Using the university schema in our textbook, write the following queries in SQ:

a$)$ Create a new course $"$CS$-001",$ titled "Weekly Seminar", with $0$ credits.

b$)$ Create a section of this course in Autumn $2009,$ with section id of $1.$