Completion
Complete each sentence or
statement.
|
|
|
1.
|
A(n)
____________________ view is the set of requirements that is necessary to support the operations of a
particular database user.
|
|
|
2.
|
For
each table, you must identify the primary key, any alternate keys, secondary keys, and
____________________ keys.
|
|
|
3.
|
It is
through the foreign keys that you can create relationships among tables and enforce certain types of
____________________ constraints in a database.
|
|
|
4.
|
To
create a(n) ____________________ relationship, create a new table whose primary key is the
combination of the primary keys of the original table.
|
|
|
5.
|
After
establishing the relationships among the entities, the step is to normalize each table with the
target being the ____________________ normal form.
|
|
|
6.
|
A(n)
____________________ key is a column or collection of columns that could have been chosen as a
primary key, but was not.
|
|
|
7.
|
A(n)
____________________-relationship diagram visually represents the structure of a
database.
|
|
|
8.
|
____________________ key restrictions determine the relationships between the
tables.
|
|
|
9.
|
When
merging the result into the design, combine tables that have the same ____________________ key to
form a new table.
|
|
|
10.
|
An
entity that does not require a relationship to another entity for identification is called a(n)
____________________ entity.
|
|
|
11.
|
In an
E-R diagram, the ____________________ entities have rounded corners.
|
|
|
12.
|
A
relationship that is not necessary is called a(n) ____________________ relationship.
|
|
|
13.
|
When
the DBMS cannot enforce restrictions, the task must be completed by the users or the
____________________.
|
|
|
14.
|
In an
E-R diagram, when the relationships are denoted by a "1" and an "n", this
represents a(n) ____________________ relationship.
|
|
|
15.
|
In an
E-R diagram, a diamond shape within a rectangle represents a(n) _____________________
entity.
|
|
|
16.
|
In an
E-R diagram, an alternate way to represent a one-to-many relationship is to omit the "one"
and put a(n) ____________________ at the "many" end of the relationship.
|
|
|
17.
|
The
number of items that must be included in a relationship within an E-R diagram represent
____________________.
|
|
|
18.
|
An
entity in a relationship with a minimum cardinality of ____________________ plays an optional role in
the relationship.
|
|
|
19.
|
An
entity with a minimum of _____________________ plays a mandatory role in the
relationship.
|
Short Answer
|
|
|
20.
|
What
is the name of the set of requirements that is necessary to support the operations of a particular
database user?
|
|
|
21.
|
After
establishing the relationships between the entities during a design, the next task is to normalize
each table. In what normal form should these tables be targeted?
|
|
|
22.
|
What
is a column or collection of columns that could have been chosen as a primary key but was
not?
|
|
|
23.
|
What
type of diagram visually represents the structure of a database?
|
|
|
24.
|
What
restrictions determine the relationships between the tables?
|
|
|
25.
|
What
shape generally represents an entity in an E-R diagram?
|
|
|
26.
|
An
entity that does not require a relationship to another entity for identification is known as what
type of entity?
|
|
|
27.
|
When
the DBMS cannot enforce restrictions on a table, who should enforce these rules?
|
|
|
28.
|
A
diamond within a rectangle in an E-R diagram represents what type of entity?
|
|
|
29.
|
When
indicating a one-to-many relationship, an alternative to the "one" and "many"
indicators is to delete the "one" and place what at the "many" end of the
relationship?
|
Essay
|
|
|
|
|
|
30.
|
Please refer to the above figure. Break this table apart into two separate
tables.
|
|
|
|
|
|
31.
|
Please refer to the above figure. Define the primary key of the Sales table and
explain your answer.
|