refers to the organization of data as a blueprint of how the database is

Refers to the organization of data as a blueprint of

This preview shows page 28 - 33 out of 91 pages.

______________ refers to the organization of data as a blueprint of how the database is constructed. ________________ are ordered lists of values and are used for grouping and organizing data. They are used in relational database models and can be used to represent related data that belong together, such as student records. Cohort Modules C724 Data Resource Management - Module 4 relational database OLTP tuple OLAP primary key data warehouse diversity database data schema records attribute foreign key
Image of page 28
words below Feedback Please Answer Please Answer Please Answer Please Answer Please Answer Please Answer Please Answer Please Answer Please Answer BACK TO FASTSTART TAB
Image of page 29
Term Description Database Entity Attributes Field Record Table Relationships Primary Key Foreign Key Schema Ad Hoc Reporting Query Type Description Relational Database Object-oriented Database OLTP Cloud-based Database Clickstream Levels or Tools Description Conceptual data models Logical data models Physical data models Tool: Decision Tree Relationship Description of the visual One and only one None to many One to many Concepts Description Purpose of Normalization 1. Key Database Terms 3. Types of Databases OLAP & Analytical Database 4. Principles of Database Design Entity Relationship Diagram (ERD) 5. Crow’s Foot Line perpendicular to the line connecting the tables and a crow’s foot (3 lines radiating from the line connecting the tables) 6. Normalization
Image of page 30
1NF 2NF All fields in a record must be connected with a primary key. 3NF Factors Description Volume Variety Velocity Concept Description (What makes each of the following unique?) Data warehouse Data mart Primary Components Description Source Systems Data Quality Data Governance Metadata ETL Step Description Extract Transform Load Static Data Concept Description Forecasting Associations Classifications There is no repeating data or group of data. For example, having a person's name in the database in two different tables. Using Primary and Foreign keys to link the tables is the means why which you eliminate the need to list someone's name in two different tables. All fields in a table must be connected by and associated with a primary key. 7. Referential Integrity Define Referential Integrity Why is Referential Integrity Important? 8. Big Data 9. Data warehouse & Data Mart? 10. Components of a data warehouse 11. Transferring Data to a Data Warehouse 12. Data Mining Concepts
Image of page 31
Clustering Sequences Concept Description Data Mining Predictive Analytics Business Intelligence Concept Description Data Dictionary Data Management Data Retrieval Data Administration Component Description Integrity Confidentiality Availability Methods of Maintaining Description Data Integrity Limit Risk of Destruction Formatting Rules Principle of Least Privilege Activity Description Data Properly Recorded Data Properly Stored Data Properly Retrieved 13. Analytics & Business Intelligence Concepts Sentiment Analysis 14. DBMS 15. CIA Triad 16. Maintaining Quality Data/Data Integrity Access Policies/Authorization 17. Data Governance Data Properly Retained & Destroyed 18. What is the purpose of a data warehouse?
Image of page 32
Image of page 33

You've reached the end of your free preview.

Want to read all 91 pages?

  • Spring '17

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture