DATABASE DESIGN AND NORMALIZATION

A functional dependency is a relationship between or among

A. Entities
B. Rows
C. Attributes
D. Tables

• A

• B

• C

• D

The database design prevents some data from being stored due to _______.

A. Deletion anomalies
B. Insertion anomalies
C. Update anomalies
D. Selection anomalies

• A

• B

• C

• D

A relation is in 2NF if:

A. All the values of non-key attributes are dependent fully on the candidate key.
B. Any non-key attribute that are dependent on only part of the candidate key should be moved to another relation where the partial key is the actual full key.
C. It must be already in the 1NF.
D. All of the above.

• A

• B

• C

• D

If one attribute is determinant of second, which in turn is determinant of third, then the relation cannot be:

A. Well-structured
B. 1NF
C. 2NF
D. 3NF

• A

• B

• C

• D

Consider the relation Sale(Date, Customer, Product, Vendor, VendorCity, SalesRep)
{Date, Customer, Product} is the composite candidate key and the following functional dependencies are also given:
Vendor -> VendorCity, Product -> Vendor
What is the highest normal form of the sale relation?

A. 0NF
B. 1NF
C. 2NF
D. 3NF

• A

• B

• C

• D

Which of the following statement(s) is/are FALSE about OLAP?

A. OLAP involves long running slow transactions that read lot of data
B. OLAP involves frequent insert, update and delete operations
C. OLAP requires data to be in De-Normalized form for optimal processing
D. Both B and C

• A

• B

• C

• D

Which of the following statement(s) is/are true about OLAP?

A. OLAP involves long running slow transactions that read lot of data
B. OLAP requires complex joins to aggregate data from multiple tables
C. OLAP requires data to be in De-Normalized form for optimal processing
D. Both A and C

• A

• B

• C

• D

Choose the correct processing technique for the given statements.
Identify correlation between salary structure and policies sold made by Insurance agents in an organization.

A. OLTP
B. OLAP
C. OLAM
D. None of the above

• A

• B

• C

• D

Choose the correct processing technique for the given statements.
Update project details of an employee

A. OLTP
B. OLAP
C. OLAM
D. None of the above

• A

• B

• C

• D

Choose the correct processing technique for the given statements.
Identify profit trends for different units of organization over years

A. OLTP
B. OLAP
C. OLAM
D. None of the above

• A

• B

• C

• D