DATA MANAGEMENT FOUNDATIONS 2026
TEST PAPER QUESTIONS SOLUTIONS GRADED
A+
◉ Data Integrity Management. Answer: Functions performed by the
DBMS to guarantee integrity and consistency of the data in a
database
◉ Data Storage Management. Answer: Functions performed by the
DBMS to guarantee integrity and consistency of the data in a
database
◉ Security Management. Answer: Functions performed by the DBMS
to guarantee integrity and consistency of the data in a database
◉ Data Sharing. Answer: Enables sharing of data in a DBMS
environment
◉ Storage of Vast Volumes of Data. Answer: Increases effectiveness
in working with data in a DBMS environment
,◉ Improved Query Response Time. Answer: Advantage gained from
using a relational database management system to store customer
information
◉ Data Normalization. Answer: Method of organizing attributes into
tables
◉ Business Intelligence System. Answer: Expected to increase
profitability, throughput, and visibility while decreasing workloads
and improving satisfaction
◉ Relational Model. Answer: A database model based on
mathematical principles
◉ Domain. Answer: Set of values = 'Data Type'
◉ Tuple. Answer: Finite sequence of values pulled from a fixed
domain = 'Row'
◉ Relation. Answer: A named set of tuples, all from the same domain
= 'Table'
◉ Attribute. Answer: A tuple position
,◉ Cardinality. Answer: Refers to the MAXIMUM number of times an
instance in one entity can be associated with an instance of another
entity
◉ Unary Relationship. Answer: One entity involved in a relationship
(one box, one line)
◉ Binary Relationship. Answer: Two entities involved in a
relationship (two boxes combined by one line)
◉ Mandatory Entity. Answer: Depicted in an ER diagram with a
single vertical line through the relationship line
◉ Mandatory. Answer: 'M' shown on an entity in an ER diagram
◉ Primary Identifier. Answer: 'PI' shown on an entity in an ER
diagram, used for attribute(s) that uniquely identify the whole entity
◉ Maxima and Minima. Answer: Depicted in an ER diagram as the
first letter/number shown (maxima) and the letter next to it in
parentheses (minima)
◉ Singular Attribute. Answer: Each entity instance has at most ONE
attribute instance
, ◉ Plural Attribute. Answer: Each entity instance can have MANY
attribute instances
◉ Unique Attribute. Answer: Each attribute instance describes only
ONE entity instance
◉ Select Operation. Answer: Selects table rows based on logical
expression (σ)
◉ Project Operation. Answer: Selects Table Columns (II)
◉ Join Operation. Answer: Joins two tables
◉ Union Operation. Answer: Combines ALL rows of two compatible
tables into a single table (U)
◉ Intersect Operation. Answer: Operates on two compatible tables
and returns only rows that appear in BOTH tables (∩)
◉ Cardinality in ER Diagram. Answer: Appears as a 1 or M on the
relationship line, closest to the entity
TEST PAPER QUESTIONS SOLUTIONS GRADED
A+
◉ Data Integrity Management. Answer: Functions performed by the
DBMS to guarantee integrity and consistency of the data in a
database
◉ Data Storage Management. Answer: Functions performed by the
DBMS to guarantee integrity and consistency of the data in a
database
◉ Security Management. Answer: Functions performed by the DBMS
to guarantee integrity and consistency of the data in a database
◉ Data Sharing. Answer: Enables sharing of data in a DBMS
environment
◉ Storage of Vast Volumes of Data. Answer: Increases effectiveness
in working with data in a DBMS environment
,◉ Improved Query Response Time. Answer: Advantage gained from
using a relational database management system to store customer
information
◉ Data Normalization. Answer: Method of organizing attributes into
tables
◉ Business Intelligence System. Answer: Expected to increase
profitability, throughput, and visibility while decreasing workloads
and improving satisfaction
◉ Relational Model. Answer: A database model based on
mathematical principles
◉ Domain. Answer: Set of values = 'Data Type'
◉ Tuple. Answer: Finite sequence of values pulled from a fixed
domain = 'Row'
◉ Relation. Answer: A named set of tuples, all from the same domain
= 'Table'
◉ Attribute. Answer: A tuple position
,◉ Cardinality. Answer: Refers to the MAXIMUM number of times an
instance in one entity can be associated with an instance of another
entity
◉ Unary Relationship. Answer: One entity involved in a relationship
(one box, one line)
◉ Binary Relationship. Answer: Two entities involved in a
relationship (two boxes combined by one line)
◉ Mandatory Entity. Answer: Depicted in an ER diagram with a
single vertical line through the relationship line
◉ Mandatory. Answer: 'M' shown on an entity in an ER diagram
◉ Primary Identifier. Answer: 'PI' shown on an entity in an ER
diagram, used for attribute(s) that uniquely identify the whole entity
◉ Maxima and Minima. Answer: Depicted in an ER diagram as the
first letter/number shown (maxima) and the letter next to it in
parentheses (minima)
◉ Singular Attribute. Answer: Each entity instance has at most ONE
attribute instance
, ◉ Plural Attribute. Answer: Each entity instance can have MANY
attribute instances
◉ Unique Attribute. Answer: Each attribute instance describes only
ONE entity instance
◉ Select Operation. Answer: Selects table rows based on logical
expression (σ)
◉ Project Operation. Answer: Selects Table Columns (II)
◉ Join Operation. Answer: Joins two tables
◉ Union Operation. Answer: Combines ALL rows of two compatible
tables into a single table (U)
◉ Intersect Operation. Answer: Operates on two compatible tables
and returns only rows that appear in BOTH tables (∩)
◉ Cardinality in ER Diagram. Answer: Appears as a 1 or M on the
relationship line, closest to the entity
