Question 1

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 
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 2

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 
A)  unnormalized 
B)  first normal form 
C)  second normal form 
D)  third normal form

Question 3

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. 
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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 
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 6

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. 
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 7

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 
A)  rectangles 
B)  equals signs between shapes 
C)  lines between shapes 
D)  circles

Question 8

The duplication of data is formally called _____.

Accepted Answer

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

Question 9

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 
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 10

What is the precise definition of a primary key?

Accepted Answer

Column A (or a collection of columns) is

Question 11

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 
A)  like a noun 
B)  an attribute 
C)  a table row 
D)  its association with other entities

Question 12

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

Question 13

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. 
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.

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

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

Which statement describing relations is false?

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

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 _____.

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

The duplication of data is formally called _____.

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

What is the precise definition of a primary key?

A property of an entity is _____.

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

Which statement regarding primary keys is true?

Introduction to Kimtay Pet Supplies and Staywell Student Accommodation Databases

Creating Tables

Single Table Queries

Multiple Table Queries

Updating Data

Database Administration

Functions Procedures and Triggers

Filters

Exam 2: Database Design Fundamentals

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

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

Which statement describing relations is false?

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

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 _____.

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

The duplication of data is formally called _____.

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

What is the precise definition of a primary key?

A property of an entity is _____.

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

Which statement regarding primary keys is true?

Introduction to Kimtay Pet Supplies and Staywell Student Accommodation Databases

Creating Tables

Single Table Queries

Multiple Table Queries

Updating Data

Database Administration

Functions Procedures and Triggers

Filters