Answer $($a$),($b$),$ and $($c$)$

The below dependency diagram represents a Prescription Schedule. There are several dependencies outlined.

$($a$)$ Identify and discuss each of the indicated dependencies in the diagram, explain the types of dependency that are present. Is this relation in $1$NF explain your answer?

$($b$)$ Based on this dependency diagram, create a dependency diagram that shows transitive dependencies where they exist.

$($c$)$ Now create a new complete set of tables that represent all this information in $3NF.$ Please be sure to indicate the dependencies

QUESTION $4$

Consider the following relational schema:

Student $($snum$,$ frame sname major, level, age$)$

Class $($cid cname meets, at$,$ room, fid$)$

Enrolled $($snum sid$)$

Faculty $($fid$,$ fname, sname, deptname$)$

Primary keys are underlined, and foreign keys are highlighted in red. Write SQL queries to answer the following:

$($a$)$ Write SQL to create Student, Class, Faculty, and Enrolled tables from the relational schema provided above. Select appropriate data types for each attribute. Also remember to set primary and foreign keys.

$($b$)$ Find fname sname and major of all students who are seniors level $=3).$

$($c$)$ List the detail of faculty members who taught only in room W$202.$

$($d$)$ For each level, print the level and total number of students belong to that level.