CBIS 3210 Final Exam Questions &
Answers
The Entities of the ERD Equals - ANSWERSData Stores of DFD
Logical Database Modeling - ANSWERSDeals with gathering business requirements and
converting those requirements into a model
Logical Database Modeling Systems Requirements - ANSWERSProcess Modeling: DFD
Conceptual Data Modeling: ERD
Logical Modeling Should Accurately Render - ANSWERSA visual representation of the activities
and data relevant to a particular business
Physical Database Modeling - ANSWERSDeals with the conversion of the logical, or business
model, into a relational database model
Relational Database - ANSWERSData represented as a set of related tables or relations
Normalization - ANSWERSThe process of converting complex data structures into simple, stable
data structures
Three Reasons for Normalization - ANSWERSTo minimize duplicate data
To minimize or avoid data modification issues
To simplify queries
, Normalization Example - ANSWERSWhat are the purposes of this table?
Minimize Data Duplication and Minimize or Avoid Data Modification Issues - ANSWERSDo you
see any data duplication?
Problems with Data Duplications - ANSWERSIt increases storage and decrease performance
It becomes more difficult to maintain data changes
Modification Anomalies - ANSWERSInsert Anomaly
Update Anomaly
Deletion Anomaly
Search and Sort Issues - ANSWERSIn 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 - ANSWERSMinimize data duplication
Minimize or avoid data modification issues
Simplify queries
Solution - Normalization - ANSWERSNormalization 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 - ANSWERSThere are three common forms of normalization:
1st, 2nd, and 3rd Normal Form
Answers
The Entities of the ERD Equals - ANSWERSData Stores of DFD
Logical Database Modeling - ANSWERSDeals with gathering business requirements and
converting those requirements into a model
Logical Database Modeling Systems Requirements - ANSWERSProcess Modeling: DFD
Conceptual Data Modeling: ERD
Logical Modeling Should Accurately Render - ANSWERSA visual representation of the activities
and data relevant to a particular business
Physical Database Modeling - ANSWERSDeals with the conversion of the logical, or business
model, into a relational database model
Relational Database - ANSWERSData represented as a set of related tables or relations
Normalization - ANSWERSThe process of converting complex data structures into simple, stable
data structures
Three Reasons for Normalization - ANSWERSTo minimize duplicate data
To minimize or avoid data modification issues
To simplify queries
, Normalization Example - ANSWERSWhat are the purposes of this table?
Minimize Data Duplication and Minimize or Avoid Data Modification Issues - ANSWERSDo you
see any data duplication?
Problems with Data Duplications - ANSWERSIt increases storage and decrease performance
It becomes more difficult to maintain data changes
Modification Anomalies - ANSWERSInsert Anomaly
Update Anomaly
Deletion Anomaly
Search and Sort Issues - ANSWERSIn 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 - ANSWERSMinimize data duplication
Minimize or avoid data modification issues
Simplify queries
Solution - Normalization - ANSWERSNormalization 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 - ANSWERSThere are three common forms of normalization:
1st, 2nd, and 3rd Normal Form
