Module C Designing Databases and Entity-Relationship Diagramming
Answer Key
Multiple Choice Questions
1.
Relational databases are similar to spreadsheets in that:
2.
Which of the following defines a database?
3.
What is the most popular type of database?
4.
Which of the following characterizes a relational database?
5.
There are _____ primary steps in designing and building a database.
6.
_____ are statements concerning the information you need to work with and
the relationships within the information.
7.
Why would you define business rules for a database?
8.
An organization wishes to store information about its employees in a
database. The employees, in this case, constitute a(n) ____.
9.
What is the first step in designing and building a database?
10.
Which of the following is true about an entity class?
11.
What is a primary key?
12.
What is an instance?
13.
A supplier is an example of a(n) ____.
14.
Which of the following would be a good primary key for the entity class of
students?
15.
Which of the following is a graphic method of representing entity classes
and their relationships?
16.
An E-R diagram includes five basic symbols. Which one denotes an entity
class?
17.
Which of the following denotes a relationship between entity classes in an
E-R diagram?
18.
Which symbol should you use in an E-R diagram to show the relationship
between a student and the courses they are currently enrolled in?
19.
An E-R diagram includes five basic symbols. Which of the following denotes
a single relationship between entity classes?
20.
Which symbol would you use in an E-R diagram to show that a course is
taught by only one teacher?
21.
An E-R diagram includes five basic symbols. Which one denotes an optional
relationship between entity classes?
22.
Which symbol would you use in an E-R diagram to show that a student may
or may not enroll in a course?
23.
Which of the following denotes a multiple relationship between entity
classes in an E-R diagram?