CBIS 3210 Final Exam Questions With Complete Solutions
3 views 0 purchase
Course
CBIS 3210
Institution
CBIS 3210
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
Concep...
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.
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 Classroom. 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.
