Question 1

The term that describes one non-key field of a table being dependent on another non-key field of the table is ____.

Accepted Answer

A)  full functional dependency 
B)  determinant 
C)  partial functional dependency 
D)  transitive dependency 
E)  minimum dependency 
A)  full functional dependency 
B)  determinant 
C)  partial functional dependency 
D)  transitive dependency 
E)  minimum dependency

Question 2

In first normal form tables every attribute value is atomic, that is no attribute is multi-valued.

Accepted Answer

A) True 
 B)False

Question 3

The input to the data normalization process is a list of the attributes in the database and a list of the functional dependencies among them.

Accepted Answer

A) True 
 B)False

Question 4

In third normal form, all foreign keys appear where needed to logically tie together related tables.

Accepted Answer

A) True 
 B)False

Question 5

Data normalization ____.

Accepted Answer

A)  is capable of creating relational tables that are free of data redundancy 
B)  is a logical database design technique 
C)  can be used to check the accuracy of the E-R diagrams to relational tables conversion technique 
D)  All of the above. 
E)  None of the above. 
A)  is capable of creating relational tables that are free of data redundancy 
B)  is a logical database design technique 
C)  can be used to check the accuracy of the E-R diagrams to relational tables conversion technique 
D)  All of the above. 
E)  None of the above.

Question 6

The two major logical database design techniques are conversion of E-R diagrams to relational tables and data normalization.

Accepted Answer

A) True 
 B)False

Question 7

A partial functional dependency occurs when an attribute of a relational table is dependent on only part of the table's key.

Accepted Answer

A) True 
 B)False

Question 8

A many-to-many unary relationship in an E-R diagram requires the creation of a total of three tables in a relational database.

Accepted Answer

A) True 
 B)False

Question 9

Converting a many-to-many unary relationship into a relational database from an E-R diagram ____.

Accepted Answer

A)  can be done by adding another copy of the unique identifier of the single entity's table into the same table with a different attribute name 
B)  can be done by splitting the attributes of the single entity into two tables, each with its own copy of the unique identifier 
C)  requires the creation of an additional table beyond the one that represents the single entity in the relationship 
D)  a & b above 
E)  a & c above 
A)  can be done by adding another copy of the unique identifier of the single entity's table into the same table with a different attribute name 
B)  can be done by splitting the attributes of the single entity into two tables, each with its own copy of the unique identifier 
C)  requires the creation of an additional table beyond the one that represents the single entity in the relationship 
D)  a & b above 
E)  a & c above

Question 10

Converting a one-to-one unary relationship into a relational database from an E-R diagram ____.

Accepted Answer

A)  can be done by adding another copy of the unique identifier of the single entity's table into the same table with a different attribute name 
B)  can be done by splitting the attributes of the single entity into two tables, each with its own copy of the unique identifier 
C)  requires the creation of an additional table beyond the one that represents the single entity in the relationship 
D)  a & b above 
E)  a & c above 
A)  can be done by adding another copy of the unique identifier of the single entity's table into the same table with a different attribute name 
B)  can be done by splitting the attributes of the single entity into two tables, each with its own copy of the unique identifier 
C)  requires the creation of an additional table beyond the one that represents the single entity in the relationship 
D)  a & b above 
E)  a & c above

Question 11

Converting from first to second normal form involves subdividing tables to remove transitive dependencies.

Accepted Answer

A) True 
 B)False

Question 12

Converting a one-to-many binary relationship into a relational database from an E-R diagram ____.

Accepted Answer

A)  can be done by placing the unique identifier of one of the tables into the other 
B)  can be done by creating a single table that combines the attributes of the two entities 
C)  requires the creation of an additional table beyond the two that represent the two entities in the relationship 
D)  a & b above 
E)  a & c above 
A)  can be done by placing the unique identifier of one of the tables into the other 
B)  can be done by creating a single table that combines the attributes of the two entities 
C)  requires the creation of an additional table beyond the two that represent the two entities in the relationship 
D)  a & b above 
E)  a & c above

Question 13

Logical database design ____.

Accepted Answer

A)  is a part of physical database design 
B)  includes physical database design as one of its elements 
C)  results in a set of database tables that contain redundant data 
D)  results in a set of database tables that are optimized for performance 
E)  None of the above. 
A)  is a part of physical database design 
B)  includes physical database design as one of its elements 
C)  results in a set of database tables that contain redundant data 
D)  results in a set of database tables that are optimized for performance 
E)  None of the above.

Question 14

The goal of logical database design is ____.

Accepted Answer

A)  to fine tune the database's physical database design 
B)  to convert databases from a hierarchical or network structure to a relational structure 
C)  to improve performance 
D)  to create well-structured tables that properly reflect the company's business environment 
E)  None of the above. 
A)  to fine tune the database's physical database design 
B)  to convert databases from a hierarchical or network structure to a relational structure 
C)  to improve performance 
D)  to create well-structured tables that properly reflect the company's business environment 
E)  None of the above.

Question 15

Convert the following Grand Travel Airline entity-relationship diagram into a relational database.

Accepted Answer

@#IMG-DLM& PILOT
 @#IMG-DLM& FLIGHT
 @#IMG-DLM& PASSENGER
 @#IMG-DLM&

Question 16

Which of the following are logical database design techniques?

Accepted Answer

A)  Conversion of E-R diagrams to relational tables. 
B)  Data normalization. 
C)  System development. 
D)  a & b above 
E)  All of the above. 
A)  Conversion of E-R diagrams to relational tables. 
B)  Data normalization. 
C)  System development. 
D)  a & b above 
E)  All of the above.

Question 17

A ternary relationship in an E-R diagram requires the creation of a total of three tables in a relational database.

Accepted Answer

A) True 
 B)False

Question 18

Converting a many-to-many binary relationship into a relational database from an E-R diagram ____.

Accepted Answer

A)  can be done by placing the unique identifier of one of the tables into the other 
B)  can be done by creating a single table that combines the attributes of the two entities 
C)  requires the creation of an additional table beyond the two that represent the two entities in the relationship 
D)  a & b above 
E)  a & c above 
A)  can be done by placing the unique identifier of one of the tables into the other 
B)  can be done by creating a single table that combines the attributes of the two entities 
C)  requires the creation of an additional table beyond the two that represent the two entities in the relationship 
D)  a & b above 
E)  a & c above

The term that describes one non-key field of a table being dependent on another non-key field of the table is ____.

In first normal form tables every attribute value is atomic, that is no attribute is multi-valued.

The input to the data normalization process is a list of the attributes in the database and a list of the functional dependencies among them.

In third normal form, all foreign keys appear where needed to logically tie together related tables.

Data normalization ____.

The two major logical database design techniques are conversion of E-R diagrams to relational tables and data normalization.

A partial functional dependency occurs when an attribute of a relational table is dependent on only part of the table's key.

A many-to-many unary relationship in an E-R diagram requires the creation of a total of three tables in a relational database.

Converting a many-to-many unary relationship into a relational database from an E-R diagram ____.

Converting a one-to-one unary relationship into a relational database from an E-R diagram ____.

Converting from first to second normal form involves subdividing tables to remove transitive dependencies.

Converting a one-to-many binary relationship into a relational database from an E-R diagram ____.

Logical database design ____.

The goal of logical database design is ____.

Convert the following Grand Travel Airline entity-relationship diagram into a relational database.

Which of the following are logical database design techniques?

A ternary relationship in an E-R diagram requires the creation of a total of three tables in a relational database.

Converting a many-to-many binary relationship into a relational database from an E-R diagram ____.

Data: the New Corporate Resource

Data Modeling

The Database Management System Concept

Relational Data Retrieval: SQL

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Physical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters

Exam 7: Logical Database Design

The term that describes one non-key field of a table being dependent on another non-key field of the table is ____.

In first normal form tables every attribute value is atomic, that is no attribute is multi-valued.

The input to the data normalization process is a list of the attributes in the database and a list of the functional dependencies among them.

In third normal form, all foreign keys appear where needed to logically tie together related tables.

Data normalization ____.

The two major logical database design techniques are conversion of E-R diagrams to relational tables and data normalization.

A partial functional dependency occurs when an attribute of a relational table is dependent on only part of the table's key.

A many-to-many unary relationship in an E-R diagram requires the creation of a total of three tables in a relational database.

Converting a many-to-many unary relationship into a relational database from an E-R diagram ____.

Converting a one-to-one unary relationship into a relational database from an E-R diagram ____.

Converting from first to second normal form involves subdividing tables to remove transitive dependencies.

Converting a one-to-many binary relationship into a relational database from an E-R diagram ____.

Logical database design ____.

The goal of logical database design is ____.

Convert the following Grand Travel Airline entity-relationship diagram into a relational database.

Which of the following are logical database design techniques?

A ternary relationship in an E-R diagram requires the creation of a total of three tables in a relational database.

Converting a many-to-many binary relationship into a relational database from an E-R diagram ____.

Data: the New Corporate Resource

Data Modeling

The Database Management System Concept

Relational Data Retrieval: SQL

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Physical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters