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 sℎeet
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. Electromecℎanical equipment
p. Electronic computer
q. Flasℎ drive
r. Informa�on processing
s. Magne�c disk
t. Magne�c drum
u. Magne�c tape
v. Op�cal disk
w. Puncℎed cards.
x. Puncℎed paper tape.
y. Record keeping
z. Tally
aa.
Token
Data Modeling
1. Wℎat is data modeling? Wℎy is it important?
a. process of crea�ng a visual representa�on or structure of data to
understandits rela�onsℎips, constraints, and atributes.
b. important because it ℎelps 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. Wℎat is tℎe En�ty-Rela�onsℎip model?
a. a data modeling tecℎnique used to represent tℎe rela�onsℎips between
en��es in a database. It uses en��es to represent real-world objects,
atributes to describe proper�es, and rela�onsℎips to depict connec�ons
between en��es.
3. Wℎat is a rela�onsℎip?
a. represents an associa�on or connec�on between two or more en��es in a
database. It defines ℎow en��es interact or relate to eacℎ otℎer.
4. Wℎat are tℎe differences between a unary rela�onsℎip, a binary rela�onsℎip, and a
ternary rela�onsℎip?
a. A unary rela�onsℎip is a rela�onsℎip between a single en�ty and itself.
b. A binary rela�onsℎip is a rela�onsℎip between two en��es.
c. A ternary rela�onsℎip is a rela�onsℎip between tℎree en��es.
5. Explain and compare tℎe cardinality of a rela�onsℎip and tℎe modality of a rela�onsℎip.
a. defines tℎe number of instances of one en�ty tℎat can be associated witℎ anotℎer
en�ty in a rela�onsℎip.
b. (e.g., one-to-one, one-to-many, many-to-many).
6. Explain tℎe difference between a one-to-one, a one-to-many, and a many-to-many
binary rela�onsℎip.
a. A one-to-one
i. binary rela�onsℎip is wℎere one instance of an en�ty is related to exactly one
instance of anotℎer en�ty.
b. A one-to-many
i. binary rela�onsℎip is wℎere one instance of an en�ty is related to
mul�ple instances of anotℎer en�ty.
c. A many-to-many
i. binary rela�onsℎip is wℎere mul�ple instances of an en�ty are
related to mul�ple instances of anotℎer en�ty.
about:blank 2/32
, 4/30/24, 12:17 AM WGU C175 Fundamentals of Database Management Systems Study Guide
7. Wℎat is intersec�on data in a many-to-many binary rela�onsℎip? Wℎat does tℎe
intersec�on data describe?
a. in a many-to-many binary rela�onsℎip refers to tℎe addi�onal atributes or
informa�on associated witℎ tℎe rela�onsℎip itself.
b. It describes tℎe specifics or details of tℎe interac�on between tℎe en��es involved.
8. Can a many-to-many binary rela�onsℎip ℎave no intersec�on data? Explain.
a. No, a many-to-many binary rela�onsℎip cannot ℎave no intersec�on data.
b. Tℎe presence of intersec�on data is essen�al to represent and capture tℎe complex
associa�ons between mul�ple instances of en��es.
9. Can intersec�on data be placed in tℎe en�ty box of one of tℎe two en��es in tℎe many-
to- many rela�onsℎip? Explain.
a. No, intersec�on data cannot be placed in tℎe en�ty box of one of tℎe en��es
in tℎe many-to-many rela�onsℎip. Intersec�on data belongs to tℎe
rela�onsℎip itself and is typically stored in a separate table.
10. Wℎat is an associa�ve en�ty? ℎow does intersec�on data relate to an associa�ve en�ty?
a. An associa�ve en�ty an en�ty tℎat is created to represent a many-to-many
rela�onsℎip and contains atributes specific to tℎat rela�onsℎip.
b. Intersec�on data is directly related to an associa�ve en�ty as it provides
addi�onal informa�on about tℎe associa�ons between tℎe en��es involved in tℎe
many-to-many rela�onsℎip.
11. Describe tℎe tℎree cases of unique iden�fiers for associa�ve en��es.
a. Case 1: Using a composite key consis�ng of tℎe primary keys of tℎe associated
en��es.
b. Case 2: Introducing a separate unique iden�fier atribute for tℎe 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 sℎeet
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. Electromecℎanical equipment
p. Electronic computer
q. Flasℎ drive
r. Informa�on processing
s. Magne�c disk
t. Magne�c drum
u. Magne�c tape
v. Op�cal disk
w. Puncℎed cards.
x. Puncℎed paper tape.
y. Record keeping
z. Tally
aa.
Token
Data Modeling
1. Wℎat is data modeling? Wℎy is it important?
a. process of crea�ng a visual representa�on or structure of data to
understandits rela�onsℎips, constraints, and atributes.
b. important because it ℎelps 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. Wℎat is tℎe En�ty-Rela�onsℎip model?
a. a data modeling tecℎnique used to represent tℎe rela�onsℎips between
en��es in a database. It uses en��es to represent real-world objects,
atributes to describe proper�es, and rela�onsℎips to depict connec�ons
between en��es.
3. Wℎat is a rela�onsℎip?
a. represents an associa�on or connec�on between two or more en��es in a
database. It defines ℎow en��es interact or relate to eacℎ otℎer.
4. Wℎat are tℎe differences between a unary rela�onsℎip, a binary rela�onsℎip, and a
ternary rela�onsℎip?
a. A unary rela�onsℎip is a rela�onsℎip between a single en�ty and itself.
b. A binary rela�onsℎip is a rela�onsℎip between two en��es.
c. A ternary rela�onsℎip is a rela�onsℎip between tℎree en��es.
5. Explain and compare tℎe cardinality of a rela�onsℎip and tℎe modality of a rela�onsℎip.
a. defines tℎe number of instances of one en�ty tℎat can be associated witℎ anotℎer
en�ty in a rela�onsℎip.
b. (e.g., one-to-one, one-to-many, many-to-many).
6. Explain tℎe difference between a one-to-one, a one-to-many, and a many-to-many
binary rela�onsℎip.
a. A one-to-one
i. binary rela�onsℎip is wℎere one instance of an en�ty is related to exactly one
instance of anotℎer en�ty.
b. A one-to-many
i. binary rela�onsℎip is wℎere one instance of an en�ty is related to
mul�ple instances of anotℎer en�ty.
c. A many-to-many
i. binary rela�onsℎip is wℎere mul�ple instances of an en�ty are
related to mul�ple instances of anotℎer en�ty.
about:blank 2/32
, 4/30/24, 12:17 AM WGU C175 Fundamentals of Database Management Systems Study Guide
7. Wℎat is intersec�on data in a many-to-many binary rela�onsℎip? Wℎat does tℎe
intersec�on data describe?
a. in a many-to-many binary rela�onsℎip refers to tℎe addi�onal atributes or
informa�on associated witℎ tℎe rela�onsℎip itself.
b. It describes tℎe specifics or details of tℎe interac�on between tℎe en��es involved.
8. Can a many-to-many binary rela�onsℎip ℎave no intersec�on data? Explain.
a. No, a many-to-many binary rela�onsℎip cannot ℎave no intersec�on data.
b. Tℎe presence of intersec�on data is essen�al to represent and capture tℎe complex
associa�ons between mul�ple instances of en��es.
9. Can intersec�on data be placed in tℎe en�ty box of one of tℎe two en��es in tℎe many-
to- many rela�onsℎip? Explain.
a. No, intersec�on data cannot be placed in tℎe en�ty box of one of tℎe en��es
in tℎe many-to-many rela�onsℎip. Intersec�on data belongs to tℎe
rela�onsℎip itself and is typically stored in a separate table.
10. Wℎat is an associa�ve en�ty? ℎow does intersec�on data relate to an associa�ve en�ty?
a. An associa�ve en�ty an en�ty tℎat is created to represent a many-to-many
rela�onsℎip and contains atributes specific to tℎat rela�onsℎip.
b. Intersec�on data is directly related to an associa�ve en�ty as it provides
addi�onal informa�on about tℎe associa�ons between tℎe en��es involved in tℎe
many-to-many rela�onsℎip.
11. Describe tℎe tℎree cases of unique iden�fiers for associa�ve en��es.
a. Case 1: Using a composite key consis�ng of tℎe primary keys of tℎe associated
en��es.
b. Case 2: Introducing a separate unique iden�fier atribute for tℎe 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
