Exam 5: Database Design 1: Normalization
Exam 1: Introduction to Database Management50 Questions
Exam 2: The Relational : Introduction, QBE, and Relational Algebra50 Questions
Exam 3: The Relational : SQL75 Questions
Exam 4: The Relational : Advanced Topics50 Questions
Exam 5: Database Design 1: Normalization50 Questions
Exam 6: Database Design 2: Design Method75 Questions
Exam 7: Dbms Functions50 Questions
Exam 8: Database Administration50 Questions
Exam 9: Database Management Approaches75 Questions
Select questions type
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)
From all the ____ keys,one is chosen to be the primary key.
(Multiple Choice)
4.8/5
(32)
Showing 41 - 50 of 50
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)