DATA MANAGEMENT FOUNDATIONS EXAM REVIEW SOLVED QUESTIONS COMPLETE
ANSWERS GRADED A PLUS
Question:
Data Integrity Management.
Answer:
Functions performed by the DBMS to guarantee integrity and consistency of the data in a database
Question:
Data Storage Management.
Answer:
Functions performed by the DBMS to guarantee integrity and consistency of the data in a database
Question:
Security Management.
Answer:
Functions performed by the DBMS to guarantee integrity and consistency of the data in a database
Question:
Data Sharing.
Answer:
Enables sharing of data in a DBMS environment
Question:
Storage of Vast Volumes of Data.
,Answer:
Increases effectiveness in working with data in a DBMS environment
Question:
Improved Query Response Time.
Answer:
Advantage gained from using a relational database management system to store customer
information
Question:
Data Normalization.
Answer:
Method of organizing attributes into tables
Question:
Business Intelligence System.
Answer:
Expected to increase profitability, throughput, and visibility while decreasing workloads and
improving satisfaction
Question:
Relational Model.
Answer:
A database model based on mathematical principles
Question:
Domain.
,Answer:
Set of values = 'Data Type'
Question:
Tuple.
Answer:
Finite sequence of values pulled from a fixed domain = 'Row'
Question:
Relation.
Answer:
A named set of tuples, all from the same domain = 'Table'
Question:
Attribute.
Answer:
A tuple position
Question:
Cardinality.
Answer:
Refers to the MAXIMUM number of times an instance in one entity can be associated with an
instance of another entity
Question:
Unary Relationship.
Answer:
, One entity involved in a relationship (one box, one line)
Question:
Binary Relationship.
Answer:
Two entities involved in a relationship (two boxes combined by one line)
Question:
Mandatory Entity.
Answer:
Depicted in an ER diagram with a single vertical line through the relationship line
Question:
Mandatory.
Answer:
'M' shown on an entity in an ER diagram
Question:
Primary Identifier.
Answer:
'PI' shown on an entity in an ER diagram, used for attribute(s) that uniquely identify the whole entity
Question:
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)
ANSWERS GRADED A PLUS
Question:
Data Integrity Management.
Answer:
Functions performed by the DBMS to guarantee integrity and consistency of the data in a database
Question:
Data Storage Management.
Answer:
Functions performed by the DBMS to guarantee integrity and consistency of the data in a database
Question:
Security Management.
Answer:
Functions performed by the DBMS to guarantee integrity and consistency of the data in a database
Question:
Data Sharing.
Answer:
Enables sharing of data in a DBMS environment
Question:
Storage of Vast Volumes of Data.
,Answer:
Increases effectiveness in working with data in a DBMS environment
Question:
Improved Query Response Time.
Answer:
Advantage gained from using a relational database management system to store customer
information
Question:
Data Normalization.
Answer:
Method of organizing attributes into tables
Question:
Business Intelligence System.
Answer:
Expected to increase profitability, throughput, and visibility while decreasing workloads and
improving satisfaction
Question:
Relational Model.
Answer:
A database model based on mathematical principles
Question:
Domain.
,Answer:
Set of values = 'Data Type'
Question:
Tuple.
Answer:
Finite sequence of values pulled from a fixed domain = 'Row'
Question:
Relation.
Answer:
A named set of tuples, all from the same domain = 'Table'
Question:
Attribute.
Answer:
A tuple position
Question:
Cardinality.
Answer:
Refers to the MAXIMUM number of times an instance in one entity can be associated with an
instance of another entity
Question:
Unary Relationship.
Answer:
, One entity involved in a relationship (one box, one line)
Question:
Binary Relationship.
Answer:
Two entities involved in a relationship (two boxes combined by one line)
Question:
Mandatory Entity.
Answer:
Depicted in an ER diagram with a single vertical line through the relationship line
Question:
Mandatory.
Answer:
'M' shown on an entity in an ER diagram
Question:
Primary Identifier.
Answer:
'PI' shown on an entity in an ER diagram, used for attribute(s) that uniquely identify the whole entity
Question:
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)
