Question 1

Surrogate key values have no meaning to the users.

Accepted Answer

A) True 
 B)False

Question 2

In Microsoft Access,foreign keys are designated by using the Foreign Key button in the toolbar.

Accepted Answer

A) True 
 B)False

Question 3

A double arrow notation,A →→ B,is used to indicate a multivalued dependency.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following terms is synonymous with "relation"?

Accepted Answer

A)  Attribute 
B)  Table 
C)  Record 
D)  Row 
E)  Tuple 
A)  Attribute 
B)  Table 
C)  Record 
D)  Row 
E)  Tuple

Question 5

Which of the following is true about a key?

Accepted Answer

A)  It may be unique. 
B)  It may be non-unique. 
C)  It can only identify one row. 
D)  Both A and B 
E)  None of the above 
A)  It may be unique. 
B)  It may be non-unique. 
C)  It can only identify one row. 
D)  Both A and B 
E)  None of the above

Question 6

When used to represent a relationship,the primary key must have the same name as the corresponding foreign key.

Accepted Answer

A) True 
 B)False

Question 7

What requirements must a two-dimensional table satisfy in order to be a relation?

Accepted Answer

For a table to be considered a relation,

Question 8

Which of the following is true about a relation?

Accepted Answer

A)  The order of the columns in a relation must go from largest to smallest. 
B)  All entries in any column must be of the same kind. 
C)  A relation may have duplicate column names. 
D)  A relation may have duplicate rows. 
E)  A relation may have multiple names. 
A)  The order of the columns in a relation must go from largest to smallest. 
B)  All entries in any column must be of the same kind. 
C)  A relation may have duplicate column names. 
D)  A relation may have duplicate rows. 
E)  A relation may have multiple names.

Question 9

Normalization is the process of removing all functional dependencies from a relation.

Accepted Answer

A) True 
 B)False

Question 10

Every relation is a table,but not every table is a relation.

Accepted Answer

A) True 
 B)False

Surrogate key values have no meaning to the users.

In Microsoft Access,foreign keys are designated by using the Foreign Key button in the toolbar.

A double arrow notation,A →→ B,is used to indicate a multivalued dependency.

Which of the following terms is synonymous with "relation"?

Which of the following is true about a key?

When used to represent a relationship,the primary key must have the same name as the corresponding foreign key.

What requirements must a two-dimensional table satisfy in order to be a relation?

Which of the following is true about a relation?

Normalization is the process of removing all functional dependencies from a relation.

Every relation is a table,but not every table is a relation.

Getting Started

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters

Exam 2: The Relational Model

Surrogate key values have no meaning to the users.

In Microsoft Access,foreign keys are designated by using the Foreign Key button in the toolbar.

A double arrow notation,A →→ B,is used to indicate a multivalued dependency.

Which of the following terms is synonymous with "relation"?

Which of the following is true about a key?

When used to represent a relationship,the primary key must have the same name as the corresponding foreign key.

What requirements must a two-dimensional table satisfy in order to be a relation?

Which of the following is true about a relation?

Normalization is the process of removing all functional dependencies from a relation.

Every relation is a table,but not every table is a relation.

Getting Started

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters