Exam 5: Database Design 1: Normalization

arrow
  • Select Tags
search iconSearch Question
  • Select Tags

A table that is in first normal form may contain problems that will require you to restructure it.​

(True/False)
4.9/5
(30)

In a table with columns A,B,and C,there is a(n)____________________ dependence of column B on column A if each value for A is associated with a specific collection of values for B and,further,this collection is independent of any values for C.​

(Short Answer)
4.9/5
(37)

To correct update anomalies in a database,tables must be converted into various types of normal forms.​

(True/False)
4.8/5
(33)

Describe the procedure for converting a table to the third normal form.​

(Essay)
4.7/5
(35)

A column B is ____________________ on another column A if each value for A in the database is associated with exactly one value of B.​

(Short Answer)
4.8/5
(37)

Discuss what normal forms are and list the most common normal forms.​

(Essay)
4.8/5
(39)

If B is functionally dependent on A,you can also say that B functionally determines A.​

(True/False)
4.8/5
(37)

If the primary key of a table contains only a single column,the table is automatically in first normal form.​

(True/False)
4.8/5
(41)

A→→ B signifies that B is ____________________ on A.

(Short Answer)
4.9/5
(34)

From all the ____ keys,one is chosen to be the primary key.​

(Multiple Choice)
4.8/5
(32)
Showing 41 - 50 of 50
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)