i need database pro exoerts only, look at the pic below. In the WORKS$\_$ON table, is the attribute Hours functionally dependent on Pno? Explain

why whether you answer is yes$/$no$.(2$ points$)$

Consider the following Second Normal Form $(1$NF$)$ dependency diagram and

answer the questions that follow:

$6\mathrm{.}1$ Identify all partial and transitive dependencies by labeling each the $3$ empty boxes in

the diagram above with either PARTIAL or TRANSITIVE. $(1$ point$)$

$6\mathrm{.}2$ Convert the relation to Second Normal Form $(2$NF$)$ and draw the dependency

diagrams. $(2$ points$)$can you right me a query that check commandlog table and sends an alert for database integrity$($ola halengren$)??$ #sqlserver #database