About This Chapter
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
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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!
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.
Other chapters within the UExcel Business Information Systems: Study Guide & Test Prep course
- Introduction to Business Information Systems
- Computer-Based Information System Components
- Information Systems Application & Impact
- Information Systems Hardware
- Information Systems Software Programs
- Information Systems Software Applications
- Networking & Systems Technology
- Internet, Intranet, & Extranet
- Virtualization for Business
- Electronic & Mobile Commerce
- Enterprise Systems for Business
- Decision Making & Specialized Information Systems
- Systems Development Components & Lifecycle
- Personal & Social Impact of Computers
- UExcel Business Information Systems Flashcards