Normalization Q$.1$: Given the relationBook$\_$Pub$\_$Author$($Title$,$ PubId, AuId, Price, AuAddress$)$The functional dependencies are given below$\mathrm{.}1.$ Key $\{$Title$,$ PubId, AuId$\}2.\{$Title$,$ PubId, AuID$\}\{$Price$\}3.\{$AuID$\}\{$AuAddress$\}$ Which normal form is the relation? Normalize it up to $3$NF$.$ Q$.2$: Given the relation City$\_$Population$($City$,$ Street, HouseNumber, HouseColor, CityPopulation$)1.$ key $\{$City$,$ Street, HouseNumber$\}2.\{$City$,$ Street, HouseNumber$\}\{$HouseColor$\}3.\{$City$\}\{$CityPopulation$\}$ Which normal form is the relation? Normalize it up to $3$NF$.$ Q$\mathrm{.}3.$ Given the relation R$($A$,$ B$,$ C$,$ D$,$ E$,$ F$,$ G$,$ H$)$ The functional dependencies are given as follows: ABC $$ DEFGHSo ABC is the primary key. The other functional dependencies are given as follows:BC $$DABC $$ EE $$ FE $$ G Q$.$ Which normal form R is$?$ Q$.$ Is the relation is $2$NF$?$ Why? Q$.$ Transform it into $2$NF$.$ Q$.$ Is R$1$ and R$2$ are in $3$NF$?$ Why?Q$.$ Transform R$2$ into $3$NF$.$ Q$4$: The relation schema and the functional dependencies are given as follows: R$($A$,$ B$,$ C$,$ D$,$ E$,$ F$,$ G$,$ H$,$ I$)$ABC $$ DEFGHIB $$ G$,$ B $$ H$,$ D $$ E$,$ D $$ I Normalize up to $3$NF$.$ User Management Q$5$: There three students users S$1,$ S$2$ and S$3,$ two teacher users T$1$ and T$2$ and one departmental head $($Dr$.$ Sajjad$)$ user. The relational schema has been given as follows: Student $($Sid$,$ name, street, city. Mobile, email, CGPA, age, tot$-$cred$)$Enroll $($course$-$id$,$ Sid, semester, year, grade$)$Course $($course$-$id$,$ title, credit$-$hour$)$Teacher $($Tid$,$ name, designation, street, city, Mobile, email, salary, date$-$of$-$birth$)$Offer $($course$-$id$,$ Tid, semester, year, remuneration$)$ S$1,$ S$2$ and S$3$ can insert and update on student and enroll table, T$1$ and T$2$ can insert and update on teacher and offer table and head can insert, delete and update to all tables. Manage these users byi. Granting individual privilegesii. Creating and granting role $($st for student, tch for teacher and hd for head$).$iii. Give a comparison of these two methods. Q$6$: New head is Dr$.$ Rashed. How can you authorize Dr$.$ rashed byi. Revoking and Granting individual privilegesii. Revoking and granting role. Integrity Constraint Q$7$:Given the schemaStudent $($Sid$,$ name, street, city. Mobile, email, CGPA, age, tot$-$cred$)$Enroll $($course$-$id$,$ Sid, semester, year, grade$)$ Define DDL to have the following integrity constraints:i$.$ The composite primary key will be $($course$-$id$,$ Sid, semester, year$).$ii$.$ Semester can be only Spring, Summer or Fall.iii. Year must be higher than $2017.$iv$.$ Grade must be $0$ to $4$v$.$ Sid not present in student is not allowed in the enroll table. View Q$8$: create a view st$-$grade$-22$ with Sid, name, course$-$id$,$ grade for year $2022$Q$9$: create a view st$-$list$-22$ with Sid, name for year $2022$ using the view st$-$grade$-22.$ Student $($Sid$,$ name, street, city. Mobile, email, CGPA, age, tot$-$cred$)$Enroll $($course$-$id$,$ Sid, semester, year, grade$)$Course $($course$-$id$,$ title, credit$-$hour$)$Teacher $($Tid$,$ name, designation, street, city, Mobile, email, salary, date$-$of$-$birth$)$Offer $($course$-$id$,$ Tid, semester, year, remuneration$)$