Name:

Consider the following two tables and answer the questions below.

STUDENT

$\backslash$table$[[$STUDENT$\_$ID$,$L$\_$NAME,F$\_$NAME,MAJR$\_$CODE$],[001,$Smith,John,CS$],[002,$Allgood,AI$,$CS$],[003,$Major,Nancy,CHEM$],[004,$Davis,Karen,MATH$]]$

$\backslash$table$[[$MAJOR$],[\backslash$table$[[$DEPARTMENT$,$MAJR$\_$CODE$],[$Computer Science,CS$],[$Physics$,$PHYS$],[$Chemistry$,$CHEM$],[$Mathematics$,$MATH$]]]]$

The primary key.

a$)$ For the STUDENT table, the Entity Integrity rule means $..................................$ has to be unigue and cannot be noll

b$)$ For the STUDENT table, the Referential Integrity rule means $....q,$ has to be a valid. primary. Keg in ane ther table $q,$

$q,$

c$)$ Write the SQL statement that displays the following report as it is shown below.

$\backslash$table$[[$STUDENT$\_$ID$,$LAST$\_$NAME,FIRST$\_$NAME,MAJOR,DEPARTMENT$],[,,,,],[,,,,]]$

Select STUDENT$\_$ID$,$ LAST$\_$NAME, FIRST$\_$NAME, MAJOR, DEPARTMENT From STUDENT