Copyright

Ch 7: Data Management in Information Systems

About This Chapter

Expand your knowledge of how databases are manipulated, how data is stored and retrieved, and other database management concepts using this chapter. This information can support your class studies, help you prepare for an exam or earn course credit.

Data Management in Information Systems - Chapter Summary

Learn more about database structures, concepts and systems using the short text and video lessons in this chapter. Review details about database modeling and management systems in addition to administration, security and design practices. Brief lessons take less than 10 minutes to review and are accessible 24/7 from any device, making study self-paced and convenient. The lessons are presented by expert instructors, who can be contacted with questions using an online form. Once you have completed this chapter, you should be able to:

  • Understand database structures
  • Use a hierarchical database to organize and store data
  • Define data modeling methodologies
  • Explain what a data flow diagram is and how it is used
  • Relate the purpose and function of a database management system
  • Understand database management models
  • Detail the design and elements of a relational database
  • Use SQL to manipulate data
  • Employ database administration and security tools
  • Explain the uses of data warehousing and data mining
  • Provide examples of a data mart and big data analytics

12 Lessons in Chapter 7: Data Management in Information Systems
Test your knowledge with a 30-question chapter practice test
Database Concepts and Structures: The Elements That Make Up a Database

1. Database Concepts and Structures: The Elements That Make Up a Database

Learn the fundamental elements of databases and how they are structured. One common data structure is a database table, which uses records and fields to organize data.

Hierarchical Database: Model & Definition

2. Hierarchical Database: Model & Definition

How do you efficiently organize data that is dependent on both the data above it and below it? You'd need a hierarchical database to establish these 'parent-child' relationships, and that's what we'll be learning in this lesson.

Storing Hierarchical Data in a Database

3. Storing Hierarchical Data in a Database

Hierarchical databases are some of the most intuitive for us to understand. In this lesson, we see how data fits into a hierarchical database typical to many organizations.

What is a Data Flow Diagram?

4. What is a Data Flow Diagram?

In this lesson, you'll learn what a data flow diagram is, how it is different from a flow chart, and some common uses for data flow diagrams. You'll also find out how to create your own simple data flow diagram.

What is a Database Management System? - Purpose and Function

5. What is a Database Management System? - Purpose and Function

In this lesson, we will describe the purpose and functions of a database management system, as well as the advantages and disadvantages of using a database management system in an organization.

Models of Database Management Systems (DBMS)

6. Models of Database Management Systems (DBMS)

Get to know the different models of database management systems and learn how each one is used to systematically organize large amounts of data in a logical manner.

What is a Relational Database? - Elements, Design & Advantages

7. What is a Relational Database? - Elements, Design & Advantages

The relational database is the most widely used type of database management system. Learn how the relational database organizes data using tables, keys and associations.

Structured Query Language: Manipulating Databases Using SQL

8. Structured Query Language: Manipulating Databases Using SQL

Describe how to manipulate a database using the logic of Structured Query Language. Learn the basic syntax to write database queries in SQL using the SELECT statement.

Database Administration and Security: Definition and Purpose

9. Database Administration and Security: Definition and Purpose

A database administrator, or DBA, plays a critical role in managing the databases of an organization. Learn about the various roles of a DBA and the tools used to keep data safe and secure.

Data Warehousing and Data Mining: Information for Business Intelligence

10. Data Warehousing and Data Mining: Information for Business Intelligence

Collections of databases that work together are called data warehouses. This makes it possible to integrate data from multiple databases. Data mining is used to help individuals and organizations make better decisions.

What is a Data Mart? - Design, Types & Example

11. What is a Data Mart? - Design, Types & Example

Sometimes it's easier to shop in a small store, rather than a super-sized grocery store. This lesson will cover data marts (the small store of the data world), describe how they are designed, and give examples.

What is Big Data Analytics? - Definition & Examples

12. What is Big Data Analytics? - Definition & Examples

Companies often have an abundance of data to comb through. It can be difficult to know how to interpret all of that data. One method that has helped make that task more manageable is using big data analytics. Let us take a look now!

Chapter Practice Exam
Test your knowledge of this chapter with a 30 question practice chapter exam.
Not Taken
Practice Final Exam
Test your knowledge of the entire course with a 50 question practice final exam.
Not Taken

Earning College Credit

Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Support