Question 1

The second step in assessing table structure is to examine data values and determine dependencies and keys.

Accepted Answer

A) True 
 B)False  True

Question 2

What are inconsistent values,and why are they a problem?

Accepted Answer

Inconsistent values are different forms of the same data value.For example,in a database of dog owners and their dogs,we might find a border collie listed as "b.collie","collie,border",and "border collie".This will create query problems.For example,a query for "border collie" will not return the dogs listed in the other formats.Or,alternatively,we would have to write a query that includes all possible (or at least known)variations of "border collie," and that would be a real pain.

Question 3

Read-only databases often use several copies of a set of the same data,where each copy is modified for a specific use.

Accepted Answer

A) True 
 B)False  True

Question 4

A defining requirement for BCNF is that every determinant must be a candidate key.

Accepted Answer

A) True 
 B)False

Question 5

Describe the steps in assessing table structure when you are given a set of tables and asked to construct a new database to store the existing data.

Accepted Answer

First,you should count the number of row

Question 6

When examining data values as a part of assessing table structure,you should try to determine three types of keys: the primary key,any candidate keys,and any foreign keys.

Accepted Answer

A) True 
 B)False

Question 7

Explain denormalization,and why it may be appropriate to denormalize a set of tables.

Accepted Answer

Denormalization is the process of taking

Question 8

When examining data values as a part of assessing table structure,there is no need to try to determine candidate keys other than the table's primary key.

Accepted Answer

A) True 
 B)False

Question 9

The SQL keyword TOP ________.

Accepted Answer

A) limits the number of columns retrieved from a table 
B) limits the number of rows retrieved from a table 
C) limits the number of tables retrieved from a database 
D) A and C 
A) limits the number of columns retrieved from a table 
B) limits the number of rows retrieved from a table 
C) limits the number of tables retrieved from a database 
D) A and C

Question 10

When accessing table structure,how do you determine how many rows are in a table?

Accepted Answer

To determine how many rows are

Question 11

If you see a column name Notes,it is likely that this is a general-purpose remarks column.

Accepted Answer

A) True 
 B)False

Question 12

When assessing table structure,how do you determine the number and types of columns in a table?

Accepted Answer

To determine the number and types of how

Question 13

Read-only databases are used for ________.

Accepted Answer

A) updating 
B) querying 
C) data entry 
D) user account management 
A) updating 
B) querying 
C) data entry 
D) user account management

Question 14

The problem of misspelled data entries is an entirely different problem than the inconsistent values problem.

Accepted Answer

A) True 
 B)False

Question 15

An inconsistent values problem is created when different users have coded the same data entries differently.

Accepted Answer

A) True 
 B)False

Question 16

To count the number of rows in a table,use the SQL construct ________.

Accepted Answer

A) SELECT * 
B) SELECT TOP n * 
C) SELECT COUNT(TOP n) 
D) SELECT COUNT(*) 
A) SELECT * 
B) SELECT TOP n * 
C) SELECT COUNT(TOP n) 
D) SELECT COUNT(*)

Question 17

The SQL IS NULL keyword can be used to count the number of nulls in a column.

Accepted Answer

A) True 
 B)False

Question 18

What are the advantages and disadvantages of normalization?

Accepted Answer

The advantages of normalization are that

Question 19

The SQL keyword IS NULL can be used to help ________.

Accepted Answer

A) count the number of columns in a table 
B) count the number of rows in a table 
C) count the number of null values in a column 
D) count the number of values in a column 
A) count the number of columns in a table 
B) count the number of rows in a table 
C) count the number of null values in a column 
D) count the number of values in a column

Question 20

Normalization requires applications to use more complex SQL since they will need to write subqueries and joins to recombine data stored in separate relations.

Accepted Answer

A) True 
 B)False

Exam 4: Database Design Using Normalization

The second step in assessing table structure is to examine data values and determine dependencies and keys.

What are inconsistent values,and why are they a problem?

Read-only databases often use several copies of a set of the same data,where each copy is modified for a specific use.

A defining requirement for BCNF is that every determinant must be a candidate key.

Describe the steps in assessing table structure when you are given a set of tables and asked to construct a new database to store the existing data.

When examining data values as a part of assessing table structure,you should try to determine three types of keys: the primary key,any candidate keys,and any foreign keys.

Explain denormalization,and why it may be appropriate to denormalize a set of tables.

When examining data values as a part of assessing table structure,there is no need to try to determine candidate keys other than the table's primary key.

The SQL keyword TOP ________.

When accessing table structure,how do you determine how many rows are in a table?

If you see a column name Notes,it is likely that this is a general-purpose remarks column.

When assessing table structure,how do you determine the number and types of columns in a table?

Read-only databases are used for ________.

The problem of misspelled data entries is an entirely different problem than the inconsistent values problem.

An inconsistent values problem is created when different users have coded the same data entries differently.

To count the number of rows in a table,use the SQL construct ________.

The SQL IS NULL keyword can be used to count the number of nulls in a column.

What are the advantages and disadvantages of normalization?

The SQL keyword IS NULL can be used to help ________.

Normalization requires applications to use more complex SQL since they will need to write subqueries and joins to recombine data stored in separate relations.

Introduction

Introduction to Structured Query Language

The Relational Model and Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

SQL for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

Managing Databases With SQL Server 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Access 2013

Getting Started With Systems Analysis and Design

E-R Diagrams and the IDEF1X Standard

E-R Diagrams and the UML Standard

Getting Started With Mysql Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2013

Data Structures for Database Processing

the Semantic Object Model

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

Business Intelligence Systems

Big Data

Filters