C175
Objective Assessment
STUDY GUIDE
Fundamentals of Database Management Systems
Western Governors University
This document provides a focused study guide
• The guide is structured to help students
reinforce understanding, identify weak areas,
and prepare confidently for the assessment.
• you can review quickly and walk into exam
confident and prepared.
,4/30/24, 12:17 AM WGU C175 Fundamentals of Database Management Systems Study Guide
Intro to Informa�on Data
1. Key terms Defined:
a. Balance sheet
b. Barter
c. Calcula�ng Devices
d. Census
e. Compact Disk
f. Compe��ve Advantage
g. Corporate resource
h. Data
i. Data storage
j. Database
k. Database environment
l. Database management system
m. Disk Drive
n. Double entry bookkeeping
o. Electromechanical equipment
p. Electronic computer
q. Flash drive
r. Informa�on processing
s. Magne�c disk
t. Magne�c drum
u. Magne�c tape
v. Op�cal disk
w. Punched cards.
x. Punched paper tape.
y. Record keeping
z. Tally
aa. Token
Data Modeling
1. What is data modeling? Why is it important?
a. process of crea�ng a visual representa�on or structure of data to understand its
rela�onships, constraints, and atributes.
b. important because it helps in designing databases, ensuring data integrity, and providing
a blueprint for system development.
about:blank 1/32
,4/30/24, 12:17 AM WGU C175 Fundamentals of Database Management Systems Study Guide
2. What is the En�ty-Rela�onship model?
a. a data modeling technique used to represent the rela�onships between en��es in a
database. It uses en��es to represent real-world objects, atributes to describe
proper�es, and rela�onships to depict connec�ons between en��es.
3. What is a rela�onship?
a. represents an associa�on or connec�on between two or more en��es in a database. It
defines how en��es interact or relate to each other.
4. What are the differences between a unary rela�onship, a binary rela�onship, and a ternary
rela�onship?
a. A unary rela�onship is a rela�onship between a single en�ty and itself.
b. A binary rela�onship is a rela�onship between two en��es.
c. A ternary rela�onship is a rela�onship between three en��es.
5. Explain and compare the cardinality of a rela�onship and the modality of a rela�onship.
a. defines the number of instances of one en�ty that can be associated with another en�ty
in a rela�onship.
b. (e.g., one-to-one, one-to-many, many-to-many).
6. Explain the difference between a one-to-one, a one-to-many, and a many-to-many binary
rela�onship.
a. A one-to-one
i. binary rela�onship is where one instance of an en�ty is related to exactly one
instance of another en�ty.
b. A one-to-many
i. binary rela�onship is where one instance of an en�ty is related to mul�ple
instances of another en�ty.
c. A many-to-many
i. binary rela�onship is where mul�ple instances of an en�ty are related to
mul�ple instances of another en�ty.
about:blank 2/32
, 4/30/24, 12:17 AM WGU C175 Fundamentals of Database Management Systems Study Guide
7. What is intersec�on data in a many-to-many binary rela�onship? What does the intersec�on
data describe?
a. in a many-to-many binary rela�onship refers to the addi�onal atributes or informa�on
associated with the rela�onship itself.
b. It describes the specifics or details of the interac�on between the en��es involved.
8. Can a many-to-many binary rela�onship have no intersec�on data? Explain.
a. No, a many-to-many binary rela�onship cannot have no intersec�on data.
b. The presence of intersec�on data is essen�al to represent and capture the complex
associa�ons between mul�ple instances of en��es.
9. Can intersec�on data be placed in the en�ty box of one of the two en��es in the many-to-
many rela�onship? Explain.
a. No, intersec�on data cannot be placed in the en�ty box of one of the en��es in the
many-to-many rela�onship. Intersec�on data belongs to the rela�onship itself and is
typically stored in a separate table.
10. What is an associa�ve en�ty? How does intersec�on data relate to an associa�ve en�ty?
a. An associa�ve en�ty an en�ty that is created to represent a many-to-many rela�onship
and contains atributes specific to that rela�onship.
b. Intersec�on data is directly related to an associa�ve en�ty as it provides addi�onal
informa�on about the associa�ons between the en��es involved in the many-to-many
rela�onship.
11. Describe the three cases of unique iden�fiers for associa�ve en��es.
a. Case 1: Using a composite key consis�ng of the primary keys of the associated en��es.
b. Case 2: Introducing a separate unique iden�fier atribute for the associa�ve en�ty.
c. Case 3: Combining Case 1 and Case 2, using a composite key and adding a separate
unique iden�fier atribute.
about:blank 3/32
Objective Assessment
STUDY GUIDE
Fundamentals of Database Management Systems
Western Governors University
This document provides a focused study guide
• The guide is structured to help students
reinforce understanding, identify weak areas,
and prepare confidently for the assessment.
• you can review quickly and walk into exam
confident and prepared.
,4/30/24, 12:17 AM WGU C175 Fundamentals of Database Management Systems Study Guide
Intro to Informa�on Data
1. Key terms Defined:
a. Balance sheet
b. Barter
c. Calcula�ng Devices
d. Census
e. Compact Disk
f. Compe��ve Advantage
g. Corporate resource
h. Data
i. Data storage
j. Database
k. Database environment
l. Database management system
m. Disk Drive
n. Double entry bookkeeping
o. Electromechanical equipment
p. Electronic computer
q. Flash drive
r. Informa�on processing
s. Magne�c disk
t. Magne�c drum
u. Magne�c tape
v. Op�cal disk
w. Punched cards.
x. Punched paper tape.
y. Record keeping
z. Tally
aa. Token
Data Modeling
1. What is data modeling? Why is it important?
a. process of crea�ng a visual representa�on or structure of data to understand its
rela�onships, constraints, and atributes.
b. important because it helps in designing databases, ensuring data integrity, and providing
a blueprint for system development.
about:blank 1/32
,4/30/24, 12:17 AM WGU C175 Fundamentals of Database Management Systems Study Guide
2. What is the En�ty-Rela�onship model?
a. a data modeling technique used to represent the rela�onships between en��es in a
database. It uses en��es to represent real-world objects, atributes to describe
proper�es, and rela�onships to depict connec�ons between en��es.
3. What is a rela�onship?
a. represents an associa�on or connec�on between two or more en��es in a database. It
defines how en��es interact or relate to each other.
4. What are the differences between a unary rela�onship, a binary rela�onship, and a ternary
rela�onship?
a. A unary rela�onship is a rela�onship between a single en�ty and itself.
b. A binary rela�onship is a rela�onship between two en��es.
c. A ternary rela�onship is a rela�onship between three en��es.
5. Explain and compare the cardinality of a rela�onship and the modality of a rela�onship.
a. defines the number of instances of one en�ty that can be associated with another en�ty
in a rela�onship.
b. (e.g., one-to-one, one-to-many, many-to-many).
6. Explain the difference between a one-to-one, a one-to-many, and a many-to-many binary
rela�onship.
a. A one-to-one
i. binary rela�onship is where one instance of an en�ty is related to exactly one
instance of another en�ty.
b. A one-to-many
i. binary rela�onship is where one instance of an en�ty is related to mul�ple
instances of another en�ty.
c. A many-to-many
i. binary rela�onship is where mul�ple instances of an en�ty are related to
mul�ple instances of another en�ty.
about:blank 2/32
, 4/30/24, 12:17 AM WGU C175 Fundamentals of Database Management Systems Study Guide
7. What is intersec�on data in a many-to-many binary rela�onship? What does the intersec�on
data describe?
a. in a many-to-many binary rela�onship refers to the addi�onal atributes or informa�on
associated with the rela�onship itself.
b. It describes the specifics or details of the interac�on between the en��es involved.
8. Can a many-to-many binary rela�onship have no intersec�on data? Explain.
a. No, a many-to-many binary rela�onship cannot have no intersec�on data.
b. The presence of intersec�on data is essen�al to represent and capture the complex
associa�ons between mul�ple instances of en��es.
9. Can intersec�on data be placed in the en�ty box of one of the two en��es in the many-to-
many rela�onship? Explain.
a. No, intersec�on data cannot be placed in the en�ty box of one of the en��es in the
many-to-many rela�onship. Intersec�on data belongs to the rela�onship itself and is
typically stored in a separate table.
10. What is an associa�ve en�ty? How does intersec�on data relate to an associa�ve en�ty?
a. An associa�ve en�ty an en�ty that is created to represent a many-to-many rela�onship
and contains atributes specific to that rela�onship.
b. Intersec�on data is directly related to an associa�ve en�ty as it provides addi�onal
informa�on about the associa�ons between the en��es involved in the many-to-many
rela�onship.
11. Describe the three cases of unique iden�fiers for associa�ve en��es.
a. Case 1: Using a composite key consis�ng of the primary keys of the associated en��es.
b. Case 2: Introducing a separate unique iden�fier atribute for the associa�ve en�ty.
c. Case 3: Combining Case 1 and Case 2, using a composite key and adding a separate
unique iden�fier atribute.
about:blank 3/32
