CBIS 3210 Final Exam Questions With
Complete Solutions
The Entities of the ERD Equals correct answer: Data Stores of DFD
Logical Database Modeling correct answer: Deals with gathering business requirements and converting those requirements into a model
Logical Database Modeling Systems Requirements correct answer: Process Modeling: DFD
Conceptual Data Modeling: ERD
Logical Modeling Should Accurately Render correct answer: A visual representation of the activities and data relevant to a particular business
Physical Database Modeling correct answer: Deals with the conversion of the logical, or business model, into a relational database model
Relational Database correct answer: Data represented as a set of
related tables or relations
Normalization correct answer: The process of converting complex data structures into simple, stable data structures Three Reasons for Normalization correct answer: To minimize duplicate data
To minimize or avoid data modification issues
To simplify queries
Normalization Example correct answer: What are the purposes of this table?
Minimize Data Duplication and Minimize or Avoid Data Modification Issues correct answer: Do you see any data duplication?
Problems with Data Duplications correct answer: It increases storage and decrease performance
It becomes more difficult to maintain data changes
Modification Anomalies correct answer: Insert Anomaly
Update Anomaly
Deletion Anomaly
Search and Sort Issues correct 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 correct answer: Minimize data duplication
Minimize or avoid data modification issues
Simplify queries Solution - Normalization correct 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 correct answer: There are three common forms of normalization: 1st, 2nd, and 3rd Normal Form
First Normal Form correct 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 correct answer: The table is in first normal form and all the columns depend on the table's primary key
Third Normal Form correct answer: The table is in second normal form and all of its columns are not transitively dependent
on the primary key
Normal Form Abbreviations correct answer: First Normal Form
- 1NF
Second Normal Form - 2NF
Third Normal Form - 3NF
First Normal Form Rules correct answer: The data is in a database table. The table stores information in rows and columns
where one or more columns, called the primary key, uniquely identify each row.
Complete Solutions
The Entities of the ERD Equals correct answer: Data Stores of DFD
Logical Database Modeling correct answer: Deals with gathering business requirements and converting those requirements into a model
Logical Database Modeling Systems Requirements correct answer: Process Modeling: DFD
Conceptual Data Modeling: ERD
Logical Modeling Should Accurately Render correct answer: A visual representation of the activities and data relevant to a particular business
Physical Database Modeling correct answer: Deals with the conversion of the logical, or business model, into a relational database model
Relational Database correct answer: Data represented as a set of
related tables or relations
Normalization correct answer: The process of converting complex data structures into simple, stable data structures Three Reasons for Normalization correct answer: To minimize duplicate data
To minimize or avoid data modification issues
To simplify queries
Normalization Example correct answer: What are the purposes of this table?
Minimize Data Duplication and Minimize or Avoid Data Modification Issues correct answer: Do you see any data duplication?
Problems with Data Duplications correct answer: It increases storage and decrease performance
It becomes more difficult to maintain data changes
Modification Anomalies correct answer: Insert Anomaly
Update Anomaly
Deletion Anomaly
Search and Sort Issues correct 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 correct answer: Minimize data duplication
Minimize or avoid data modification issues
Simplify queries Solution - Normalization correct 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 correct answer: There are three common forms of normalization: 1st, 2nd, and 3rd Normal Form
First Normal Form correct 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 correct answer: The table is in first normal form and all the columns depend on the table's primary key
Third Normal Form correct answer: The table is in second normal form and all of its columns are not transitively dependent
on the primary key
Normal Form Abbreviations correct answer: First Normal Form
- 1NF
Second Normal Form - 2NF
Third Normal Form - 3NF
First Normal Form Rules correct answer: The data is in a database table. The table stores information in rows and columns
where one or more columns, called the primary key, uniquely identify each row.
