Home
Flashcards
Preview
Database Application Unit 2
Home
Get App
Take Quiz
Create
Which of the following statements is true?
A. A relational database is a collection of related attributes
B. A relational database is a collection of rows
C. A relational database is a collection of entities
D. All of the above
E. None of the above
C. A relational database is a collection of entities
Which of the following statements about functional dependencies is true?
A. Column B is functionally dependent on another column when a value for B is part of A.
B. Column B is functionally dependent on another column when a value for A determines a single value for B at any one time.
C. Column B is functionally dependent on another column when a value for B determines a single value for A at any one time.
D. Column B is functionally dependent on another column when a value for B depends a single value for A at any one time.
B. Column B is functionally dependent on another column when a value for A determines a single value for B at any one time.
A primary key is ________.
A. a unique identifier of a table
B. a unique identifier of a column
C. an identifier of columns in a relational table
D. a column that identifies other columns in a table
A. a unique identifier of a table
When is a table is in first normal form (1NF)?
A. When a table contains a unique identifier
B. When a column is not part of unique identifier
C. When a column is not part of a repeating group
D. When a table does not contain repeating group
D. When a table does not contain repeating group
Which of the following is not an entity?
A. A thing
B. An idea
C. A person
D. An event
B. An idea
When is a relation in second normal form (2NF)?
A. It is in first normal form and nonkey column is dependent on only a portion of the primary key.
B. It is in first normal form and key column is dependent on only a portion of the primary key.
C. It is in first normal form and no nonkey column is dependent on only a portion of the primary key.
D. It is in first normal form and no key column is dependent on only a portion of the primary key.
C. It is in first normal form and no nonkey column is dependent on only a portion of the primary key.
Which of the following is not a step of database design?
A. Identify the entities involved
B. Identify the unique identifiers for the entities
C. Identify the attributes for all the entities
D. Identify the functional dependencies that exist among the attributes
E. All of the above
F. None of the above
F. None of the above
Data anomalies are classified into which of the following four categories?
A. Updates, additions, deletions, and unnormalized data
B. Updates, additions, deletions, and concurrent data
C. Updates, additions, deletions, and consistent data
D. Updates, additions, deletions, and inconsistent data
D. Updates, additions, deletions, and inconsistent data
What is an attribute?
A. An attribute is a property of a relationship
B. An attribute is another name for entity.
C. An attribute is another name for relationship.
D. An attribute is a property of an entity.
D. An attribute is a property of an entity.
What is a relationship?
A. A relationship is an association between two attributes.
B. A relationship is an association between entity and attribute.
C. A relationship is an association between two entities.
D. A relationship is an association between two relations.
C. A relationship is an association between two entities.
Author
jdavis123
ID
358726
Card Set
Database Application Unit 2
Description
Updated
2022-06-20T15:39:36Z
Show Answers
Home
Flashcards
Preview