Data Analytics

Topics: SQL, Database management system, Entity-relationship model Pages: 3 (517 words) Published: October 1, 2014
MIS2502: Exam 1 Study Guide
The exam will be a combination of short-answer and multiple-choice questions. It is a closed-book, closed-notes exam. You will not be able to use a computer during the exam. The following is a list of items that you should review in preparation for the exam. Note that not every item on this list may be on the exam, and there may be items on the exam not on this list. The Things You Can Do With Data/The Information Architecture of an Organization What is the difference between data and information? Give examples. Data = discrete, unorganized, raw facts

Quantity Sold, Course Enrollment, Customer Name, Discount, Star Rating. Information = transformation of those facts into meaning.
Financial data (deposits), daily loans.
What is a transaction?
Action performed in a database management system

What are the characteristics of an operational data store?
Stores real time transactional data
What are the goals of this type of database?
Optimized for storage efficiency and data integrity
Day to day operations

What are the characteristics of an analytical data store?
Stores historical and summarized data
Data extracted from operational database and reformatted
What are the goals of this type of database?
Optimized for data retrieval and summarization
Periodic and on demand analysis

What is the relationship between an operational data store and an analytical data store? Analytical Data Store uses reformatted operational data store info Relational Data Modeling
Identify and define entities, relationships, and attributes
Entity- square – a uniquely identifiable thing (person, order) Relationship – diamond – describes how two entities relate to one another Attribute – oval – a characteristic of an entity or relationship. Cardinality

Defines the rules of the association between entities
One-to-one, II--------II
one-to-many, II--------I<
many-to-many >I--------I<
optional >0---------0<
Be able to draw an ERD...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Data Resource Management Essay
  • Data Modeling by Example Essay
  • Business Analytics Essay
  • Data Base Mangement System Essay
  • The New Frontier: Data Analytics Essay
  • Business Analytics and Advanced Analytics Companies in India Top Analytics Companies in India Essay
  • Data Mining for Business Intelligence Essay
  • data mart Essay

Become a StudyMode Member

Sign Up - It's Free