1.Redundant data increases the risk of data anomalies when you perform which of

Question

1.Redundant data increases the risk of data anomalies when you perform which of the following actions:

1.Insert data

2.Update data

3.delete data

4.all the above

2.One of the desirable characteristics of a primary key is:

A.It contains useful information about the row

B.It may change and adapt as the database grows.

C.It is minimal.

D.It should allow us to use the same value to identify multiple rows

3.The process of breaking a table into with more than one theme into two or more tables each with only one theme, thus eliminating redundancy, is called:

A.Functional dependency

B.Relating

C.Deconstructing

D.Normalization

4. In a 1:N relationship, the entity on the “one” side of the relationship is referred to as the __ and the entity on the “many” side is referred to as the __

A.Parent…child

B.Child...Parent

C.Preceding…Succeeding

D.Succeeding…Preceding

5. An entity that cannot exist in a database unless another type of entity also exists is called a:

A.Dependent entity

B.Strong entity

C.Special entity

D.Weak entity

6. An attribute of a supertype entity that indicates which of the subtypes is appropriate for a given instance is called a(n):

A.Discriminator

B.Determiner

C.Instance option

D.Association

Explanation / Answer

1. update data. It can update irrelevant rows

2. A.It contains useful information about the row. It has relation to all the columns in the table.

3. Normalisation, e.g. 1NF,2NF, 3NF are used to split tables

4. Parent..child. Parent can be 1 but there can be many children.

5. Dependent entity.

6. Association

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.