What this chapter covers
A decision is only as good as the data behind it. This chapter begins with what makes data trustworthy — accurate, complete, consistent, timely and unique — then explains how a relational database stores it: entities, attributes, and primary and foreign keys, and why companies move from scattered spreadsheets to a database. From there you follow data into a data warehouse through extraction, transformation and loading (ETL), and see how data marts, data mining and business intelligence turn stored records into answers a manager can use. It is the idea behind the Access work in the practical.
What you will be able to do after it
- Judge data quality: accurate, complete, consistent, timely and unique.
- Explain a relational database with entities, attributes, and primary and foreign keys.
- Explain why companies move from spreadsheets to databases.
- Describe how a data warehouse is filled through ETL, and what a data mart is.
- Explain how data mining and business intelligence turn stored data into decisions.
Key terms
data qualitydatabaserelational databaseentityattributeprimary keyforeign keyDBMSdata warehousedata martETLdata miningbusiness intelligenceقواعد البياناتالمفتاح الأساسيمستودع البياناتالتنقيب في البيانات
How you take it with us
This chapter is taught in live classes on Zoom. Every class has a recording and a summary in your portal, to go back to whenever you need.
The certificate of completion records that you took the course; it is not a university qualification.
Chapters of MIST201
Midterm stage2 classes · 2.5 hours
Final stage7 classes · 10 hours
- Chapter 4Ethics and Information Security: MIS Business Concerns1 class · 2 hours
- Chapter 6Data: Business Intelligence2 classes · 3 hours
- Chapter 8Enterprise Applications: Business Communications2 classes · 2.5 hours
- Chapter 9Systems Development and Project Management: Corporate Responsibility2 classes · 2.5 hours
Midterm stage
- Chapter 1نظم المعلومات في عالم الاعمال اليوم
- Chapter 2كيف تستخدم المنشات نظم المعلومات؟
Final stage1 class · 1 hour
- Ethical Case Study1 class · 1 hour