Question 1

A candidate key is ________.

Accepted Answer

A)  never a primary key 
B)  a combination of two or more attributes 
C)  is always automatically generated by the DBMS 
D)  a candidate to be the primary key 
E)  None of the above 
A)  never a primary key 
B)  a combination of two or more attributes 
C)  is always automatically generated by the DBMS 
D)  a candidate to be the primary key 
E)  None of the above

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Question 4

Which of the following functional dependency diagrams accurately represents the following situation:
•A campus has many buildings.
•Each building has a unique name.
•Each building has many rooms.
•All rooms in any given building are numbered sequentially starting at "101."
•Each room has a certain capacity,although many rooms in the same building or different buildings may have the same capacity.
•Each room is assigned to a single department.
•A department may have many rooms in one or more buildings,each with the same or different capacities.

Accepted Answer

A)  BuildingName → (RoomNumber, Capacity, Department) 
B)  RoomNumber → (BuildingName, Department, Capacity) 
C)  (Department, Capacity) → (BuildingName, RoomNumber) 
D)  (BuildingName, Capacity) → (Department, RoomNumber) 
E)  (BuildingName, RoomNumber) → (Capacity, Department) 
A)  BuildingName → (RoomNumber, Capacity, Department) 
B)  RoomNumber → (BuildingName, Department, Capacity) 
C)  (Department, Capacity) → (BuildingName, RoomNumber) 
D)  (BuildingName, Capacity) → (Department, RoomNumber) 
E)  (BuildingName, RoomNumber) → (Capacity, Department)

Question 5

Which of the following is not true of surrogate keys?

Accepted Answer

A)  They are meaningful to the users. 
B)  They are numeric. 
C)  They are usually generated by the DBMS. 
D)  They are unique. 
E)  They are usually hidden on forms and reports. 
A)  They are meaningful to the users. 
B)  They are numeric. 
C)  They are usually generated by the DBMS. 
D)  They are unique. 
E)  They are usually hidden on forms and reports.

Question 6

A key must be unique.

Accepted Answer

A) True 
 B)False

Question 7

Any table that meets the requirements of a(n)________ is in first normal form.

Accepted Answer

The answer of Any table that meets the requirements of...

Question 8

The unique keys that are not chosen to be the primary key are called ________ keys.

Accepted Answer

The answer of The unique keys that are not chosen...

Question 9

One important relational design principle is that ________.

Accepted Answer

A)  every determinant must be a candidate key 
B)  every candidate key must not be a determinant 
C)  every primary key must be a surrogate key 
D)  every determinant must be functionally dependent on the primary key 
E)  every primary key must be functionally dependent on every determinant 
A)  every determinant must be a candidate key 
B)  every candidate key must not be a determinant 
C)  every primary key must be a surrogate key 
D)  every determinant must be functionally dependent on the primary key 
E)  every primary key must be functionally dependent on every determinant

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

The relationship between two attributes that denotes that if the value of the first attribute is known,then the value of the second attribute can be determined,is called a(n)________.

Accepted Answer

functional

Question 12

What is normalization?

Accepted Answer

Normalization is a process whereby relat

Question 13

Explain the concept of a foreign key.

Accepted Answer

To implement a relationship within a rel

Question 14

A table that meets the requirements of a relation is said to be in which normal form?

Accepted Answer

A)  Relational normal form (RNF) 
B)  First normal form 
C)  Second normal form 
D)  Boyce-Codd normal form 
E)  Domain/key normal form 
A)  Relational normal form (RNF) 
B)  First normal form 
C)  Second normal form 
D)  Boyce-Codd normal form 
E)  Domain/key normal form

Question 15

________ was the developer of the relational model for databases.

Accepted Answer

The answer of ________ was the developer of the relational...

Question 16

Explain the possible interpretations of a null value.

Accepted Answer

The problem with allowing null values in

Question 17

In the normalization process,it is not necessary to ________.

Accepted Answer

A)  identify all the candidate keys of a relation 
B)  identify all the foreign keys of a relation 
C)  identify all the functional dependencies of a relation 
D)  identify all the determinants of a relation 
E)  determine if every determinant is a candidate key 
A)  identify all the candidate keys of a relation 
B)  identify all the foreign keys of a relation 
C)  identify all the functional dependencies of a relation 
D)  identify all the determinants of a relation 
E)  determine if every determinant is a candidate key

Question 18

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

Accepted Answer

It is not uncommon for a table that is r

Question 19

Explain the terms relation,tuple,and attribute.

Accepted Answer

The terms relation,tuple,and attribute a

Question 20

Explain the concept of a surrogate key.

Accepted Answer

A surrogate key is an artificial key tha

A candidate key is ________.

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

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

Which of the following is not true of surrogate keys?

A key must be unique.

Any table that meets the requirements of a(n)________ is in first normal form.

The unique keys that are not chosen to be the primary key are called ________ keys.

One important relational design principle is that ________.

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

The relationship between two attributes that denotes that if the value of the first attribute is known,then the value of the second attribute can be determined,is called a(n)________.

What is normalization?

Explain the concept of a foreign key.

A table that meets the requirements of a relation is said to be in which normal form?

________ was the developer of the relational model for databases.

Explain the possible interpretations of a null value.

In the normalization process,it is not necessary to ________.

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

Explain the terms relation,tuple,and attribute.

Explain the concept of a surrogate key.

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

A candidate key is ________.

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

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

Which of the following is not true of surrogate keys?

A key must be unique.

Any table that meets the requirements of a(n)________ is in first normal form.

The unique keys that are not chosen to be the primary key are called ________ keys.

One important relational design principle is that ________.

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

The relationship between two attributes that denotes that if the value of the first attribute is known,then the value of the second attribute can be determined,is called a(n)________.

What is normalization?

Explain the concept of a foreign key.

A table that meets the requirements of a relation is said to be in which normal form?

________ was the developer of the relational model for databases.

Explain the possible interpretations of a null value.

In the normalization process,it is not necessary to ________.

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

Explain the terms relation,tuple,and attribute.

Explain the concept of a surrogate key.

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