Question 1

In Microsoft Access,a relationship is created by dragging a foreign key column and dropping it on top of the corresponding primary key.

Accepted Answer

A) True 
 B)False

Question 2

A surrogate key may be appropriate under which of the following circumstances?

Accepted Answer

A)  The available candidate keys would produce a lot of data duplication when representing relationships. 
B)  The primary key is numeric. 
C)  The available candidate keys would be prone to typographical errors. 
D)  The available candidate keys have little meaning to the users. 
E)  Both A and C 
A)  The available candidate keys would produce a lot of data duplication when representing relationships. 
B)  The primary key is numeric. 
C)  The available candidate keys would be prone to typographical errors. 
D)  The available candidate keys have little meaning to the users. 
E)  Both A and C

Question 3

Which of the following is not true about null values?

Accepted Answer

A)  A null value can mean that the value is unknown. 
B)  A null value is ambiguous. 
C)  A null value can mean that the value is known to be blank. 
D)  A null value can mean that no value for the field is appropriate. 
E)  Null values cannot be avoided. 
A)  A null value can mean that the value is unknown. 
B)  A null value is ambiguous. 
C)  A null value can mean that the value is known to be blank. 
D)  A null value can mean that no value for the field is appropriate. 
E)  Null values cannot be avoided.

Question 4

In the relational model,each row of a table contains data that represents an attribute of the entity.

Accepted Answer

A) True 
 B)False

Question 5

A key that contains more than one attribute is called a(n):

Accepted Answer

A)  composite key. 
B)  complex key. 
C)  multi-key. 
D)  n-key. 
E)  candidate key. 
A)  composite key. 
B)  complex key. 
C)  multi-key. 
D)  n-key. 
E)  candidate key.

Question 6

In the normalization process,if you find a candidate key that is not a primary key,then you have determined that the relation needs to be broken into two or more other relations.

Accepted Answer

A) True 
 B)False

Question 7

Given the relations: STUDENT (SID,StudentName,Major,AdvisorID)
ADVISOR (AdvisorID,AdvisorName,Office,Phone)
Such that each student is assigned to one advisor,which of the following is true?

Accepted Answer

A)  SID is both a primary key and a foreign key. 
B)  AdvisorName is a determinant. 
C)  AdvisorID is a foreign key. 
D)  Phone is a candidate key. 
E)  Major is a candidate key. 
A)  SID is both a primary key and a foreign key. 
B)  AdvisorName is a determinant. 
C)  AdvisorID is a foreign key. 
D)  Phone is a candidate key. 
E)  Major is a candidate key.

Question 8

To create a well-formed relation through normalization,every determinant must be a candidate key.

Accepted Answer

A) True 
 B)False

Question 9

If the condition exists such that knowing the value of attribute X determines the value of attribute Y,then attribute Y is functionally dependent on attribute X.

Accepted Answer

A) True 
 B)False

Question 10

The first step of the normalization process is to identify all the candidate keys of a relation.

Accepted Answer

A) True 
 B)False

Question 11

The key that has been designated the ________ key of a relation functionally determines all the other attributes in the relation.

Accepted Answer

The answer of The key that has been designated the...

Question 12

In the normalization process,it is not necessary to identify all the functional dependencies in a relation.

Accepted Answer

A) True 
 B)False

Question 13

Given the below functional dependency, MedicineCode → (MedicineName,ShelfLife,Manufacturer,Dosage)
Which of the following statements is not known to be true?

Accepted Answer

A)  MedicineCode is a determinant. 
B)  MedicineName is a determinant. 
C)  Manufacturer is functionally dependent on MedicineCode. 
D)  ShelfLife is functionally dependent on MedicineCode. 
E)  MedicineCode is a candidate key of the relation MEDICINE (MedicineName, ShelfLife, Manufacturer, Dosage, MedicineCode). 
A)  MedicineCode is a determinant. 
B)  MedicineName is a determinant. 
C)  Manufacturer is functionally dependent on MedicineCode. 
D)  ShelfLife is functionally dependent on MedicineCode. 
E)  MedicineCode is a candidate key of the relation MEDICINE (MedicineName, ShelfLife, Manufacturer, Dosage, MedicineCode).

Question 14

In Microsoft Access,relationships between tables are created in the Relationships window.

Accepted Answer

A) True 
 B)False

Question 15

Any table that meets the definition of a relation is said to be in second normal form.

Accepted Answer

A) True 
 B)False

Question 16

To create a relationship in Microsoft Access,we drag and drop the ________ of a table.

Accepted Answer

The answer of To create a relationship in Microsoft Access,we...

Question 17

Which of the following is true about a key?

Accepted Answer

A)  It may be unique. 
B)  It may be non-unique. 
C)  In may identify more than one row. 
D)  Both A and B 
E)  All of the above 
A)  It may be unique. 
B)  It may be non-unique. 
C)  In may identify more than one row. 
D)  Both A and B 
E)  All of the above

Question 18

In SQL Server,the starting value of a surrogate key is called the:

Accepted Answer

A)  Identity. 
B)  Identity Increment. 
C)  Identity Start. 
D)  Identity Seed. 
E)  Identity Property. 
A)  Identity. 
B)  Identity Increment. 
C)  Identity Start. 
D)  Identity Seed. 
E)  Identity Property.

Question 19

In practice,why would tables that have duplicate rows be allowed?

Accepted Answer

It is not uncommon for a table that is r

Question 20

To be considered a composite key,a key must contain at least two attributes.

Accepted Answer

A) True 
 B)False

In Microsoft Access,a relationship is created by dragging a foreign key column and dropping it on top of the corresponding primary key.

A surrogate key may be appropriate under which of the following circumstances?

Which of the following is not true about null values?

In the relational model,each row of a table contains data that represents an attribute of the entity.

A key that contains more than one attribute is called a(n):

In the normalization process,if you find a candidate key that is not a primary key,then you have determined that the relation needs to be broken into two or more other relations.

Given the relations: STUDENT (SID,StudentName,Major,AdvisorID) ADVISOR (AdvisorID,AdvisorName,Office,Phone) Such that each student is assigned to one advisor,which of the following is true?

To create a well-formed relation through normalization,every determinant must be a candidate key.

If the condition exists such that knowing the value of attribute X determines the value of attribute Y,then attribute Y is functionally dependent on attribute X.

The first step of the normalization process is to identify all the candidate keys of a relation.

The key that has been designated the ________ key of a relation functionally determines all the other attributes in the relation.

In the normalization process,it is not necessary to identify all the functional dependencies in a relation.

Given the below functional dependency, MedicineCode → (MedicineName,ShelfLife,Manufacturer,Dosage) Which of the following statements is not known to be true?

In Microsoft Access,relationships between tables are created in the Relationships window.

Any table that meets the definition of a relation is said to be in second normal form.

To create a relationship in Microsoft Access,we drag and drop the ________ of a table.

Which of the following is true about a key?

In SQL Server,the starting value of a surrogate key is called the:

In practice,why would tables that have duplicate rows be allowed?

To be considered a composite key,a key must contain at least two attributes.

Getting Started

Structured Query Language

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters

Exam 2: The Relational Model

In Microsoft Access,a relationship is created by dragging a foreign key column and dropping it on top of the corresponding primary key.

A surrogate key may be appropriate under which of the following circumstances?

Which of the following is not true about null values?

In the relational model,each row of a table contains data that represents an attribute of the entity.

A key that contains more than one attribute is called a(n):

In the normalization process,if you find a candidate key that is not a primary key,then you have determined that the relation needs to be broken into two or more other relations.

Given the relations: STUDENT (SID,StudentName,Major,AdvisorID) ADVISOR (AdvisorID,AdvisorName,Office,Phone) Such that each student is assigned to one advisor,which of the following is true?

To create a well-formed relation through normalization,every determinant must be a candidate key.

If the condition exists such that knowing the value of attribute X determines the value of attribute Y,then attribute Y is functionally dependent on attribute X.

The first step of the normalization process is to identify all the candidate keys of a relation.

The key that has been designated the ________ key of a relation functionally determines all the other attributes in the relation.

In the normalization process,it is not necessary to identify all the functional dependencies in a relation.

Given the below functional dependency, MedicineCode → (MedicineName,ShelfLife,Manufacturer,Dosage) Which of the following statements is not known to be true?

In Microsoft Access,relationships between tables are created in the Relationships window.

Any table that meets the definition of a relation is said to be in second normal form.

To create a relationship in Microsoft Access,we drag and drop the ________ of a table.

Which of the following is true about a key?

In SQL Server,the starting value of a surrogate key is called the:

In practice,why would tables that have duplicate rows be allowed?

To be considered a composite key,a key must contain at least two attributes.

Getting Started

Structured Query Language

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters