Question 1

Which statement describing relations is false?

Accepted Answer

A)   A relation is a two-dimensional table.
B)   The entries in a relation may be single- or double-valued.
C)   Each column in a relation has a distinct name.
D)   The order of the columns in a relation is immaterial.

Question 2

Which statement regarding primary keys is true?

Accepted Answer

A)   By definition, a primary key always consists of a single column.
B)   You can identify primary keys for tables by examining sample data.
C)   Some tables include more than one column that can be used as a primary key.
D)   All primary keys are values generated by database software.

Question 3

The duplication of data is formally called _____.

Accepted Answer

A)   a repeating group
B)   redundancy
C)   replication
D)   an anomaly

Question 4

When the commonly accepted shorthand representation is used to describe a database, _____.

Accepted Answer

A)   each column name appears on its own line
B)   the first attributes from each row are listed in parentheses
C)   tables cannot contain columns with duplicate names
D)   it is always acceptable to qualify column names

Question 5

What is the precise definition of a primary key?

Accepted Answer

Column A (or a collection of columns) is...

Question 6

A property of an entity is _____.

Accepted Answer

A)   like a noun
B)   an attribute
C)   a table row
D)   its association with other entities

Question 7

In this text, Boyce-Codd normal form is the same as _____.

Accepted Answer

A)   unnormalized
B)   first normal form
C)   second normal form
D)   third normal form

Question 8

In an entity-relationship (E-R)  diagram, one-to-many relationships between entities are drawn as _____.

Accepted Answer

A)   rectangles
B)   equals signs between shapes
C)   lines between shapes
D)   circles

Question 9

James converts a table with this notation: INVOICES (INVOICE_NUM, INVOICE_DATE, (ITEM_ID, QUANTITY) ) 
Into a table with this notation:
INVOICES (INVOICE_NUM, INVOICE_DATE, ITEM_ID, QUANTITY) 
James has _____.

Accepted Answer

A)   made the table design worse
B)   converted a table in first normal form into a table in second normal form
C)   converted an unnormalized relation into a table in first normal form
D)   added a repeating group to a table

Question 10

Diamonds are sometimes used in E-R diagrams to _____.

Accepted Answer

A)   identify the names of entities in a database
B)   indicate which entity is on the "many" side of a one-to-many relationship
C)   represent individual tables
D)   describe the relationship between two tables

Question 11

One can successfully design a database system without fully understanding the concept of functional dependence.

Accepted Answer

A) True 
 B)False

Question 12

You receive the following requirements for a caterer's database: For a customer, store a customer ID, last name, first name, billing address, and phone number
For an order, store an order number, order date, event date, customer ID, description of services, and total price for services
When designing this database, which step do you take first?

Accepted Answer

A)   Identify the customer ID and order number as unique identifiers.
B)   Identify and name the entities CUSTOMER and ORDER.
C)   Identify customer ID, last name, first name, billing address, and phone number as attributes.
D)   Create a CUSTOMER table that includes all the customers' attributes as columns.

Question 13

How does a database management system that follows the relational model handle entities, attributes of entities, and relationships between entities?

Accepted Answer

Entities and attributes are fairly simpl...

Exam 2: Database Design Fundamentals

The duplication of data is formally called _____.

Correct Answer
verified

In an entity-relationship (E-R) diagram, one-to-many relationships between entities are drawn as _____.

Correct Answer
verified

One can successfully design a database system without fully understanding the concept of functional dependence.

Correct Answer
verified

Diamonds are sometimes used in E-R diagrams to _____.

Correct Answer
verified

How does a database management system that follows the relational model handle entities, attributes of entities, and relationships between entities?

Correct Answer
verified
Entities and attributes are fairly simpl...
View Answer

In this text, Boyce-Codd normal form is the same as _____.

Correct Answer
verified

What is the precise definition of a primary key?

Correct Answer
verified
Column A (or a collection of columns) is...
View Answer

Which statement regarding primary keys is true?

Correct Answer
verified

Which statement describing relations is false?

Correct Answer
verified

James converts a table with this notation: INVOICES (INVOICE_NUM, INVOICE_DATE, (ITEM_ID, QUANTITY) ) Into a table with this notation: INVOICES (INVOICE_NUM, INVOICE_DATE, ITEM_ID, QUANTITY) James has _____.

Correct Answer
verified

Correct Answer
verified

A property of an entity is _____.

Correct Answer
verified

When the commonly accepted shorthand representation is used to describe a database, _____.

Correct Answer
verified

Exam 2: Database Design Fundamentals

The duplication of data is formally called _____.

Correct AnswerverifiedShow Answer

In an entity-relationship (E-R) diagram, one-to-many relationships between entities are drawn as _____.

Correct AnswerverifiedShow Answer

One can successfully design a database system without fully understanding the concept of functional dependence.

Correct AnswerverifiedShow Answer

Diamonds are sometimes used in E-R diagrams to _____.

Correct AnswerverifiedShow Answer

How does a database management system that follows the relational model handle entities, attributes of entities, and relationships between entities?

Correct AnswerverifiedEntities and attributes are fairly simpl...View AnswerShow Answer

In this text, Boyce-Codd normal form is the same as _____.

Correct AnswerverifiedShow Answer

What is the precise definition of a primary key?

Correct AnswerverifiedColumn A (or a collection of columns) is...View AnswerShow Answer

Which statement regarding primary keys is true?

Correct AnswerverifiedShow Answer

Which statement describing relations is false?

Correct AnswerverifiedShow Answer

James converts a table with this notation: INVOICES (INVOICE_NUM, INVOICE_DATE, (ITEM_ID, QUANTITY) ) Into a table with this notation: INVOICES (INVOICE_NUM, INVOICE_DATE, ITEM_ID, QUANTITY) James has _____.

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

A property of an entity is _____.

Correct AnswerverifiedShow Answer

When the commonly accepted shorthand representation is used to describe a database, _____.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Entities and attributes are fairly simpl...
View Answer

Correct Answer
verified

Correct Answer
verified
Column A (or a collection of columns) is...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified