$1.$ Create a new database called lab$01$

$2.$ In database lab$01,$ create $4$ tables: course, advisor, student, and department

course $($course$\_$id varchar$(8),$ title varchar$(50),$ dept$\_$name varchar$(20),$ credits numeric$(2,0),$ primary key $($course$\_$id$),$

foreign key $($dept$\_$name$)$ references department $($dept$\_$name$))$

advisor $($s$\_$ID varchar$(5),$ i$\_$ID varchar$(5),$ primary key $($s$\_$ID$),$ foreign key $($s$\_$ID$)$ references student $($ID$))$

student $($ID varchar$(5),$ name varchar$(20)$ not null, dept$\_$name varchar$(20),$ tot$\_$cred numeric$(3,0),$ primary key $($ID$),$

foreign key $($dept$\_$name$)$ references department $($dept$\_$name$))$

department $($dept$\_$name varchar$(20),$ building varchar$(15),$ budget numeric$(12,2),$ primary key $($dept$\_$name$))$

$3.$ Populate tables

Populate the table "student" with the data below:

$(\text{'}23121\text{'},$ 'Chavez', 'Finance', $\text{'}110\text{'})$;

$(\text{'}44553\text{'},$ 'Peltier', 'Physics', $\text{'}56\text{'})$;

$(\text{'}45678\text{'},$ 'Levy', 'Physics', $\text{'}46\text{'})$;

Populate the table "course" with the data below:

$(\text{'}$FIN$-201\text{'},$ 'Investment Banking', 'Finance', $\text{'}3\text{'})$;

$(\text{'}$HIS$-351\text{'},$ 'World History', 'History', $\text{'}3\text{'})$;

$(\text{'}$MU$-199\text{'},$ 'Music Video Production', 'Music', $\text{'}3\text{'})$;

Populate the table "department" with the data below:

$(\text{'}$Finance$\text{'},$ 'Painter', $\text{'}120000\text{'})$;

$(\text{'}$History$\text{'},$ 'Painter', $\text{'}50000\text{'})$;

$(\text{'}$Music$\text{'},$ 'Packard', $\text{'}80000\text{'})$;

$(\text{'}$Physics$\text{'},$ 'Watson', $\text{'}70000\text{'})$;

$4.$ Please run the sql statements below:

select $*$ from student where dept$\_$name $=$ 'physics'

select $*$ from course where dept$\_$name $=$ 'Finance'

Note: Please submit your sql statement returning results. A word document with screenshots on the sql returning results will be good to submit.