Chapter 7-Physical database Design

Question 1

Why can’t table names contain blank spaces?

Answer 1

Spaces are used to separate individual words of statements.

Question 2

Secondary Index

Answer 2

A mechanism that creates an additional key for a relation.

Question 3

ALTER TABLE

Answer 3

Can be used to change a constraint that is already in a table.

Question 4

What can you use the CHECK constraint for?

Answer 4

To create a list of acceptable values of an attribute.

Question 5

When are CHECK constraints tested?

Answer 5

Upon update and insertion operations.

Question 6

The data dictionary should provide the following information.

Answer 6

Each attributes domain.
Any default values for each attribute.
The attributes value if it can be null.

Question 7

In the physical design phase each relation should provide the following

Answer 7

The relations name.
The relations attributes.
The primary key and any foreign keys.
The integrity constraints for any foreign keys.

Question 8

CREATE TABLE statement is used to:

Answer 8

Create base relations.
( Blank spaces are used to separate individual words of statements. The name of the table precedes the attribute name and is separated by a dot)