1,795
18
Essay, 2 pages (300 words)

Data analytics

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, unrecognized, 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 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 entitles One-to-one, II— en-to-many, 11 many-to-many optional > O—- Be able to draw an RED based on a scenario description using the correct symbols and cardinality Identify when attributes describe entities and when they describe relationships Be able to relate an RED to Its corresponding schema Understand and implement primary key/foreign key relationships.

Thank's for Your Vote!
Data analytics. Page 1
Data analytics. Page 2
Data analytics. Page 3

This work, titled "Data analytics" was written and willingly shared by a fellow student. This sample can be utilized as a research and reference resource to aid in the writing of your own work. Any use of the work that does not include an appropriate citation is banned.

If you are the owner of this work and don’t want it to be published on AssignBuster, request its removal.

Request Removal
Cite this Essay

References

AssignBuster. (2022) 'Data analytics'. 13 January.

Reference

AssignBuster. (2022, January 13). Data analytics. Retrieved from https://assignbuster.com/data-analytics/

References

AssignBuster. 2022. "Data analytics." January 13, 2022. https://assignbuster.com/data-analytics/.

1. AssignBuster. "Data analytics." January 13, 2022. https://assignbuster.com/data-analytics/.


Bibliography


AssignBuster. "Data analytics." January 13, 2022. https://assignbuster.com/data-analytics/.

Work Cited

"Data analytics." AssignBuster, 13 Jan. 2022, assignbuster.com/data-analytics/.

Get in Touch

Please, let us know if you have any ideas on improving Data analytics, or our service. We will be happy to hear what you think: [email protected]