CBIS 3210 FINAL EXAM QUESTIONS AND
ANSWERS WITH VERIFIED SOLUTIONS 2024
The Entities of the ERD Equals - ANSWER Data Stores of DFD
Logical Database Modeling - ANSWER Deals with gathering business requirements and converting those
requirements into a model
Logical Database Modeling Systems Requirements - ANSWER Process Modeling: DFD
Conceptual Data Modeling: ERD
Logical Modeling Should Accurately Render - ANSWER A visual representation of the activities and data
relevant to a particular business
Physical Database Modeling - ANSWER Deals with the conversion of the logical, or business model, into a
relational database model
Relational Database - ANSWER Data represented as a set of related tables or relations
Normalization - ANSWER The process of converting complex data structures into simple, stable data
structures
Three Reasons for Normalization - ANSWER To minimize duplicate data
To minimize or avoid data modification issues
To simplify queries
Normalization Example - ANSWER What are the purposes of this table?
Minimize Data Duplication and Minimize or Avoid Data Modification Issues - ANSWER Do you see any
data duplication?
, Problems with Data Duplications - ANSWER It increases storage and decrease performance
It becomes more difficult to maintain data changes
Modification Anomalies - ANSWER Insert Anomaly
Update Anomaly
Deletion Anomaly
Search and Sort Issues - ANSWER In the SalesStaff table if you want to search the sales office which is in
charge of a specific customer such as Ford, you would have to write a query like the one on the next
slide.
Seems to be an easy question but the query is surprisingly complex
Normalization Equals Rules to - ANSWER Minimize data duplication
Minimize or avoid data modification issues
Simplify queries
Solution - Normalization - ANSWER Normalization simplifies databases by properly separating the data
into different tables, to house the data in tables which serve a single purpose
Common Forms of Normalization - ANSWER There are three common forms of normalization: 1st, 2nd,
and 3rd Normal Form
First Normal Form - ANSWER The information is stored in a relational table and each column contains
atomic values, and there are not repeating groups of columns
Second Normal Form - ANSWER The table is in first normal form and all the columns depend on the
table's primary key
Third Normal Form - ANSWER The table is in second normal form and all of its columns are not
transitively dependent on the primary key
ANSWERS WITH VERIFIED SOLUTIONS 2024
The Entities of the ERD Equals - ANSWER Data Stores of DFD
Logical Database Modeling - ANSWER Deals with gathering business requirements and converting those
requirements into a model
Logical Database Modeling Systems Requirements - ANSWER Process Modeling: DFD
Conceptual Data Modeling: ERD
Logical Modeling Should Accurately Render - ANSWER A visual representation of the activities and data
relevant to a particular business
Physical Database Modeling - ANSWER Deals with the conversion of the logical, or business model, into a
relational database model
Relational Database - ANSWER Data represented as a set of related tables or relations
Normalization - ANSWER The process of converting complex data structures into simple, stable data
structures
Three Reasons for Normalization - ANSWER To minimize duplicate data
To minimize or avoid data modification issues
To simplify queries
Normalization Example - ANSWER What are the purposes of this table?
Minimize Data Duplication and Minimize or Avoid Data Modification Issues - ANSWER Do you see any
data duplication?
, Problems with Data Duplications - ANSWER It increases storage and decrease performance
It becomes more difficult to maintain data changes
Modification Anomalies - ANSWER Insert Anomaly
Update Anomaly
Deletion Anomaly
Search and Sort Issues - ANSWER In the SalesStaff table if you want to search the sales office which is in
charge of a specific customer such as Ford, you would have to write a query like the one on the next
slide.
Seems to be an easy question but the query is surprisingly complex
Normalization Equals Rules to - ANSWER Minimize data duplication
Minimize or avoid data modification issues
Simplify queries
Solution - Normalization - ANSWER Normalization simplifies databases by properly separating the data
into different tables, to house the data in tables which serve a single purpose
Common Forms of Normalization - ANSWER There are three common forms of normalization: 1st, 2nd,
and 3rd Normal Form
First Normal Form - ANSWER The information is stored in a relational table and each column contains
atomic values, and there are not repeating groups of columns
Second Normal Form - ANSWER The table is in first normal form and all the columns depend on the
table's primary key
Third Normal Form - ANSWER The table is in second normal form and all of its columns are not
transitively dependent on the primary key
