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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller PASSINGPOINT. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.99. You're not tied to anything after your purchase.