Question 1

In the normalization process,if you find that every determinant in a relation is a candidate key then you have determined that:

Accepted Answer

A)  the relation is well formed. 
B)  the relation needs to be broken into two or more new relations. 
C)  surrogate keys in the relation may not be correctly linked to other relations. 
D)  the relation needs to have foreign keys added in order to be correctly linked to other relations. 
E)  referential integrity constraints concerning the relation need to be established. 
A)  the relation is well formed. 
B)  the relation needs to be broken into two or more new relations. 
C)  surrogate keys in the relation may not be correctly linked to other relations. 
D)  the relation needs to have foreign keys added in order to be correctly linked to other relations. 
E)  referential integrity constraints concerning the relation need to be established.

Question 2

A primary key is:

Accepted Answer

A)  required to be unique. 
B)  used to represent rows in relationships. 
C)  a candidate key. 
D)  used to identify unique rows. 
E)  All of the above 
A)  required to be unique. 
B)  used to represent rows in relationships. 
C)  a candidate key. 
D)  used to identify unique rows. 
E)  All of the above

Question 3

Briefly describe the various tasks of the primary key.

Accepted Answer

The primary key is used for four primary

Question 4

A(n)________ is one or more columns of a relation that is used to identify a row.

Accepted Answer

The answer of A(n)________ is one or more columns of...

Question 5

Every cell in a relation can hold only a single value.

Accepted Answer

A) True 
 B)False

Question 6

Explain the terms relation,tuple,and attribute.

Accepted Answer

The terms relation,tuple,and attribute a

Question 7

While the relational model for databases appears to hold much promise,few commercial databases have implemented it.

Accepted Answer

A) True 
 B)False

In the normalization process,if you find that every determinant in a relation is a candidate key then you have determined that:

A primary key is:

Briefly describe the various tasks of the primary key.

A(n)________ is one or more columns of a relation that is used to identify a row.

Every cell in a relation can hold only a single value.

Explain the terms relation,tuple,and attribute.

While the relational model for databases appears to hold much promise,few commercial databases have implemented it.

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 the normalization process,if you find that every determinant in a relation is a candidate key then you have determined that:

A primary key is:

Briefly describe the various tasks of the primary key.

A(n)________ is one or more columns of a relation that is used to identify a row.

Every cell in a relation can hold only a single value.

Explain the terms relation,tuple,and attribute.

While the relational model for databases appears to hold much promise,few commercial databases have implemented it.

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