Question

1. Which of the following is NOT a type of data anomaly?

a. Insertion

b. Transformation

c. Deletion

d. Modification

2. Functional dependency has the following characteristics EXCEPT

a. Attribute Y is functionally dependent upon attribute X, if the value of X uniquely determines the value of Y

b. It's a constraint between two tables

c. It's a constraint between two attributes (columns)

d. Represented as Determinant(s) -> Dependent(s)

3. The definition of a partial dependency is

a.One or more non-key attributes are dependent upon another NON-KEY attribute

b. An intersection of a row and column contains more than one data value

c. A non-key attribute is dependent upon PART, BUT NOT ALL of the currently defined primary key attributes

d. Repeating group duplicate attribute values

4. The conversion of a second normal form table to a third normal form table does NOT include

a. Create a new column in the original table

b. Move all attributes that are dependent upon the new relation’s primary key to that relation

c. For each non-key attribute that is a determinant, create a new relation with the determinant as the primary key

d. Leave the new relation’s primary key as a foreign key

5. Employee ID would determine all these attributes EXCEPT

a. Company Name

b. Gender

c. First Name

d. Birth Date

Answer 1

1) correct option is b) Transformation

Deletion Anomaly: For example if a patient was last patient of a particular doctor , deleting patients's information will delete doctor's also. This phenomenon comes under delete anomaly.

Insertion Anomaly: For example we can't add a doctor's detail until he has atleast one patient registered under him. This problem comes under insertion anomaly.

Modification Anomaly: It exists when one or more instances of duplicated data is updated, but not all. For example if a patient's email id got changed we need to change it everywhere in the table .