BIAM 410 Week 2 Quiz questions with answers shown correctly keller graduate school of management

Document Content and Description Below

BIAM 410 Week 2 Quiz questions with answers shown correctly Question 1 2 / 2 pts (TCO 3) A relational _____ is composed of intersecting rows and columns. key attribute Correct! ... table record Chapter 3, page 66 Question 2 2 / 2 pts (TCO 3) A composite key by definition is one that _____. Correct! is composed of more than one attribute can uniquely identify any row in a table is a minimal superkey is a primary key placed into a related table to form a common attribute Chapter 3, page 69 Question 3 2 / 2 pts (TCO 3) For a table to have entity integrity, no key attribute in its primary key can contain _____. zero text Correct! null a Boolean value Chapter 3, page 69 Question 4 2 / 2 pts (TCO 3) Foreign keys are used to ensure _____. attribute integrity table integrity Correct! referential integrity entity integrity Chapter 3, page 71 Question 5 2 / 2 pts (TCO 3) The ideal type of relationship that should be the norm in a relational database design is _____. one to one (1:1) many to many (M:N) many to none (M:0) Correct! one to many (1:M) Chapter 3, page 81 Question 6 2 / 2 pts (TCO 3) _____ are characteristics of entities. Relationships Tables Rows Correct! Attributes Chapter 4, page 107 Question 7 2 / 2 pts (TCO 3) Cardinalities are established by concise statements known as _____. identifying relationships multivalued attributes Correct! business rules recursive relationships Chapter 4, page 113 Question 8 2 / 2 pts (TCO 3) The process of database design can best be described as _____. linear Correct! iterative sequential one-time Chapter 4, page 129 Question 9 2 / 2 pts (TCO 3) _____ is a process for evaluating and correcting table structures to minimize redundancy. Correct! Normalization Denormalization Optimization Refactoring Chapter 5, page 181 Question 10 2 / 2 pts (TCO 3) If a table is in 2NF and it contains no transitive dependencies, it is in _____ normal form. first Boyce-Codd Correct! third fourth Chapter 5, page 191 Quiz Score: 20 out of 20 [Show More]

Last updated: 1 year ago

Preview 1 out of 5 pages