MIS Exam 2

MIS Exam 2 - M IS Exam 2: Chapters 6, 5, 3 Chapter 6:...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: M IS Exam 2: Chapters 6, 5, 3 Chapter 6: Databases & Data Warehouses 1. List, describe, and provide an example of each of the five characteristics of high quality information (ACCUT) Accuracy- all the values are correct, no errors Consistency- the summary information is in agreement with detailed information Completeness- there is no missing values Uniqueness- each entity is represented only once in the information Timeliness- the information is current with respect to business requirements Sources of Low-Quality data: online customers, information from different systems with different entry standards, call center operators typos, third party & external information contain inconsistent, inaccurate information 2. Define the relationship between a database and a database management system. database management system (DBMS)- software through which users and application programs interact with a database. Database- a collection of information that has been systematically organized for easy access and analysis, may be part of a DBMS. 3. Describe the advantages an organization can gain by using a database. Increased data sharing Increased flexibility Increased scalability/performance Reduced information redundancy Increased information integrity (quality) Increased information security 4. Define the fundamental concepts of the relational database model. Relational database model- stores information in the form of logically related 2- dimensional tables 5. Know the synonyms between RDBMS and ERD RDBMS- ERD- 6. Who are the leading DBMS vendors ? IBM Oracle Microsoft 7. I nformation I ntegrity- measures the quality of the information I ntegrity Constraints- rules that help ensure the quality of information relational- enforces basic & fundamental information-based constraints business-critical- enforces business rules vital to an organizations success 8. Describe the role & purpose of a database management system and the four components of a database management system Role of DBMS : to allow users to create, access, and use information stored in a database Four Components: Data definition- helps create & maintain the data dictionary & structure of the database Data manipulation- allows users to create, read, update, & delete information Application generation- tools for creating visually appealing & easy-to-use applications Data administration- tools for managing the overall environment by...
View Full Document

Page1 / 10

MIS Exam 2 - M IS Exam 2: Chapters 6, 5, 3 Chapter 6:...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online