Problems are based on the ER model shown in Figure P11.7 and on the query shown after the figure. SELECT                  P_CODE, P_PRICE FROM                    PRODUCT WHERE                 P_PRICE >= (SELECT AVG(P_PRICE) FROM PRODUCT); What type of database I/O operations will likely be used by the query? (See Table 11.3.)

Why may using a normalized version of the Index metadata relation lead to lower performance, and what causes this?

Explain the role of candidate keys and primary keys in the context of database normalization.

The following is the relation notation of a database table in 1NF ORDER(CustNum, CustFN, CustLN, OrderNum, OrderDate, ProdNum, ProdDesc, Qty, UnitPrice) The functional dependencies are given below: CustNum → CustFN, CustLN OrderNum - OrderDate, CustNum, CustFN, CustLN ProdNum → ProdDesc OrderNum, ProdNum -> UnitPrice, Qty Use the functional dependencies above to answer the following questions. Don't not make additional assumptions and functional dependencies. A. List all partial dependencies in the relation only (if any) using the dependency numbers. Don't write the dependencies in X->Y format, just indicate their numbers (which are listed on the left side, i.e., 1, 2, 3, 4). Indicate only the dependencies that you think are partial. B. Identify and show the 2NF. Show primary keys and foreign keys references. Use relational notation (show references). Write down all relations and their references below. C. List all transitive dependency in your answer to question b (if any)…