Name: 
 

Chapter Six Study Guide (A114 & I111 Fall 2003)



Multiple Choice
Identify the letter of the choice that best completes the statement or answers the question.
 
 
chsix2_files/i0020000.jpg
 

1. 

Please refer to the above figure.  What is the primary key of the Sales table?
a.
RepNum
b.
CustomerNum
c.
PartNum
d.
RepNum, PartNum, and CustomerNum
 

2. 

A set of requirements that is necessary to support the operations of a particular database user is known as a
a.
user view.
c.
user attribute.
b.
user table.
d.
user field.
 

3. 

A design that supports all the user views encountered in the design process is known as a
a.
merged design.
c.
defined design.
b.
cumulative design.
d.
listed design.
 

4. 

What is the first step needed in designing a user view?
a.
Represent the user view as a collection of tables
b.
Normalize these tables
c.
Identify all keys in these tables
d.
Merge the result into the cumulative design
 

5. 

When a correct design is not obvious, what is the first step in creating a user view?
a.
Determine the entities involved and create a separate table for each type of entity
b.
Determine the primary key for each table
c.
Determine the properties for each entity
d.
Determine relationships among the entities
 

6. 

When determining the properties for each entity as you design the user view, these properties will become what in the table?
a.
rows
c.
data
b.
columns
d.
DBMS
 

7. 

One of the basic relationships among tables is
a.
one-to-many.
c.
one-to-one.
b.
many-to-many.
d.
all of the above
 

8. 

After establishing the relationships among the entities, what normal form should the tables ideally be in?
a.
first
c.
third
b.
second
d.
none of the above
 
 
chsix2_files/i0110000.jpg
 

9. 

Please refer to the above figure. What does the entry FK DepartmentNum -> Department represent?
a.
a first key
c.
a fourth key
b.
a foreign key
d.
a fifth key
 

10. 

An alternative to the primary key of a table (another possible primary key) is listed with what abbreviation in DBDL?
a.
SK
c.
PK
b.
FK
d.
AK
 

11. 

What type of diagram visually represents the structure of a database?
a.
DBDL
c.
E-R
b.
AK
d.
MOUS
 

12. 

An entity that does not require a relationship to another entity for identification is called a(n)
a.
alternative entity.
c.
independent entity.
b.
foreign entity.
d.
single entity.
 
 
chsix2_files/i0160000.jpg
 

13. 

Please refer to the above figure.  Which table can be considered a dependent entity?
a.
Customer table
c.
OrderLine table
b.
Rep table
d.
Part table
 

14. 

In the design diagram, independent entities are distinguished by
a.
square corners.
c.
cut corners.
b.
rounded corners.
d.
chipped corners.
 

15. 

In the design diagram, dependent entities are distinguished by
a.
square corners.
c.
cut corners.
b.
rounded corners.
d.
chipped corners.
 

16. 

A relationship that is necessary for identification is called a(n)
a.
objectifying relationship.
c.
identifying relationship.
b.
merging relationship.
d.
referential relationship.
 

17. 

After the information level design is completed, what is the next step?
a.
the physical level design
c.
the DBMS level design
b.
the modality level design
d.
the table level design
 

18. 

What is the easiest way to produce the design for the DBMS, given that the final information-level design already exists in a relational format?
a.
design a new database
c.
use the same tables and columns
b.
use new tables
d.
use a different DBMS
 

19. 

When a DBMS cannot enforce the restrictions you place on tables, who should enforce them?
a.
the users of the system
c.
the manufacturers of the DBMS
b.
the database administrators
d.
no one
 

20. 

Aside from the user, who else can enforce restrictions when the DBMS cannot?
a.
the programmer
c.
the CEO
b.
the administrator
d.
the DBDL
 

21. 

What is the letter "n" used for in an E-R diagram?
a.
one
c.
many
b.
two
d.
nothing
 

22. 

When there is a many to many relationship, what should you do?
a.
merge all columns into one table
c.
define a new database
b.
create an additional table
d.
change column names
 

23. 

In a many to many situation, what letters are used to denote this relationship?
a.
m and n
c.
n and n
b.
m and m
d.
m and y
 

24. 

In most E-R diagrams, what is the shape used to denote an entity?
a.
circle
c.
rectangle
b.
square
d.
diamond
 

25. 

In most E-R diagrams, what is the shape used to denote the implementation of the relationship?
a.
circle
c.
rectangle
b.
square
d.
diamond
 

26. 

When an entity exists to implement a relationship, it is called a
a.
composite entity.
c.
complicated entity.
b.
complex entity.
d.
circular entity.
 

27. 

What does the crow's foot denote in an E-R diagram?
a.
a one-to-one relationship
c.
a many-to-many relationship
b.
a one-to-many relationship
d.
no relationship listed
 

28. 

When using the crow's foot in an E-R diagram, which end of the relationship does that crow's foot represent?
a.
the one end
c.
either end
b.
the many end
d.
both ends
 

29. 

The number of items that must be included in a relationship in an E-R diagram are known as
a.
entities.
c.
DBDL.
b.
cardinality.
d.
composites.
 

30. 

The number closest to the entity represents what cardinality?
a.
maximum
c.
midvalue
b.
minimum
d.
smallest
 

31. 

The number closest to the relationship represents what cardinality?
a.
maximum
c.
midvalue
b.
minimum
d.
largest
 

32. 

What does it mean when an entity has a minimum cardinality of zero?
a.
The entity has a mandatory role in the relationship.
b.
The entity is not required in the relationship.
c.
The entity should not be in the relationship as an attribute.
d.
The entity must be listed with all zeroes in the data fields.
 

33. 

What does it mean when an entity has a minimum cardinality of one?
a.
The entity is required in the relationship.
b.
The entity is not required in the relationship.
c.
The entity should not be in the relationship as an attribute.
d.
The entity must be listed with all ones in the data fields.
 

34. 

The design strategy in which specific user requirements are synthesized into a design is known as
a.
top-down design methodology.
c.
bottom-up design methodology.
b.
listing design methodology.
d.
original design methodology.
 

35. 

The design strategy in which a general database design that models the overall enterprise, and that repeatedly refines the model to achieve a design that supports all necessary applications, is known as
a.
top-down design methodology.
c.
bottom-up design methodology.
b.
listing design methodology.
d.
original design methodology.
 

36. 

The best way to obtain required information from the user is to complete a
a.
user form.
c.
relational form.
b.
database form.
d.
survey form.
 

37. 

Which type of information collected on the survey form contains the name and description and identifies any synonyms for each entity?
a.
attribute information
c.
relationships
b.
entity information
d.
functional dependencies
 

38. 

Which type of information collected on the survey form contains the attributes for the name, a description, and synonyms for each entity?
a.
attribute information
c.
relationships
b.
entity information
d.
functional dependencies
 

39. 

Which type of information collected on the survey form contains the type of relationships, the significance of the relationships, and the restrictions on the relationship?
a.
attribute information
c.
relationships
b.
processing information
d.
functional dependencies
 

40. 

Which type of information collected on the survey form indicates how the entities are related?
a.
attribute information
c.
relationships
b.
entity information
d.
functional dependencies
 

41. 

Which type of information collected on the survey form describes how the data is updated?
a.
attribute information
c.
relationships
b.
processing information
d.
entity information
 

42. 

The first step in obtaining information from an existing document is to identify and list all
a.
rows.
c.
entities.
b.
columns.
d.
groups.
 

43. 

After obtaining the column information from an existing document, the next step is to identify
a.
entities.
c.
functional dependencies.
b.
rows.
d.
columns.
 

44. 

After determining the preliminary functional dependencies from an existing document, you can begin to determine the tables and assign the
a.
columns.
c.
entities.
b.
rows.
d.
data.
 

45. 

After identifying the columns from an original document and identifying the functional dependencies, the table must be converted to what normal form?
a.
first
c.
third
b.
second
d.
none of the above
 

46. 

How can you force uniqueness in a table?
a.
designate foreign keys as alternate keys
b.
designate alternate keys as foreign keys
c.
designate primary keys as alternate keys
d.
designate foreign keys as primary keys
 
 
chsix2_files/i0510000.jpg
 

47. 

Please refer to the above figure.  What term describes the relationship between the RepNum, CustomerNum, and PartNum?
a.
one-to- many
c.
many-to-many-to-many
b.
many-to-many
d.
one-to-one-to-one
 

48. 

A null represents a(n)
a.
zero in a field.
c.
blank space in a field.
b.
absence of a value in a field.
d.
single value in a field.
 

49. 

When combining third normal forms, the result does not have to be in
a.
first normal form.
c.
third normal form.
b.
second normal form.
d.
an entity.
 



 
Check Your Work     Reset Help