Q.1: Tick the correct Option.

1. The problems that occur due the redundancy in relation are called:

(a) inconsistenct

(b) duplication

(c) anomaly✅

 (d) dependency

2. Value of primary key attribute can’t be null. Which constraint defines this rule?

(a) Entity integrity✅

(b) Data integrity

(c) Referential integrity

(d) All

3. A relation that contains minimal redundancy and allows easy use is called

(a) Simple

(b) Well structured

(c) Use friendly

(d) All✅

4. Goal of normalization is to

(a) Get stable Structure

(b) Reduce redundancy

(c) Both a & b✅

(d) None

5. In 3NF, which form of dependency is removed?

(a) functional

(b) Repeating group

(c) Partial

(d) Transitive✅

Q.2: Give answer to any eight short questions of the following.

1. Define referential integrity.

2. How do we attain entity integrity?

3. Define homonym.

4. Define functional dependency.

5. Define partial dependency.

6. What is transitive dependency?

7. What is mutual exclusiveness of data?

8. What is synonym?

9. What is normalization?

Q.3: Give answer to any two questions of the following.

 (a) What are conditions for a relation to be in second normal form? Give example.

(b) What anomalies arise due to transitive dependency? Discuss briefly.