G$.$ What does the term "completeness" refer to in the context of database fragmentation? $(1$ Point$)$

Answer:

H$.$ Given the PARTS relation in the table below. Identify simple predicates and minterm predicates $($minimum $4$ from each predicate$)?(2$ Points$)$

$\backslash$table$[[$PNO$,$PNAME,PRICE$],[201,$PC$,2000],[301,$CAMERA,$3004],[401,$VIDEO,$1400],[501,$HDMI,$1000]]$

Answer:

I. Consider the following $4$ queries for relation ASG $(4$ Points$)$

$\backslash$table$[[q_1$:$,\backslash$table$[[$SELECT$],[$FROM ASG$],[$WHERE$]],$ENO$],[q_2$:$,\backslash$table$[[$SELECT$],[$FROM ASG$]],$PNO,DUR$],[q_3$:$,\backslash$table$[[$SELECT$],[$FROM ASG$],[$WHERE PNO$=$Value$]],$DUR$],[,,]]$

$q_4$ : SELECT SUM$($DUR$)$

FROM ASG

WHERE RESP$=$Value

A$)$ Calculate the Attribute usage values.

Answer: