About This Chapter
Introduction to General & Relational Databases - Chapter Summary
In this chapter, you'll find a series of lessons and self-assessment quizzes about general and relational databases. The short video lessons cover the different types and sources of data, database types, how database management works, and what an entity is in a database. With each lesson we've included a multiple-choice quiz to help give you a sense for the topics you need to study further. Assistance from one of our experts is available in the Dashboard if you need it. This chapter is designed to help you achieve the following objectives:
- Define attributes in databases
- Discuss the elements, advantages and design of relational databases
- Explain the history and concepts of the relational model for managing data
- Provide examples of flat file databases
- Differentiate between relational databases and flat file databases
- Explain hierarchical databases and how they differ from relational databases
- Outline pertinent database terminology
- Define database fields and their different types
1. What are Data? - Types, Sources & Definition
In this lesson, learn what data are and compare different types. Understanding how to represent and organize data is a key element of using a computer.
2. What are Databases? - Examples & Types
In this lesson, we'll be looking at databases, which are computer mechanisms for storing and retrieving data. Test your knowledge following the lesson with a quiz.
3. What is Database Management? - How Databases Help Organizations
Organizations use large amounts of data. Database management makes it possible to organize and analyze these data. Learn why database management is important to support business operations.
4. What is an Entity in a Database?
This lesson describes the concept of an entity in a database. Entity attributes are also discussed along with the relationships between entities, including a simple example of an entity relationship diagram.
5. What is an Attribute in a Database?
Explore how and what an attribute in a relational database is in this lesson. In database management systems, it refers to a table within the database. In relational databases, it refers to a column within the table.
6. 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.
7. Relational Model for Managing Data: History, Concepts & Examples
While the relational model is used globally, it wasn't always so. This lesson will highlight the history of the relational model for databases, and the core concepts of the model. You will be able to explain the key components of a relational database.
8. Flat File Database: Definition & Example
This lesson will define and explain flat file databases; examples will be provided. While most database administrators strive to create relational databases, there are valid uses for flat file databases.
9. Flat File Database vs. Relational Database
There are two database models in existence: flat file databases and relational databases. In this lesson, we'll look at each, as well as the differences between them.
10. Hierarchical Database: Model & Definition
How do you efficiently organize data that is dependent on data above it and is dependent on data 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.
11. Hierarchical Database vs. Relational Database
In this lesson, we'll take a look at hierarchical and relational databases, their organization, and why we might use them. At the end of this lesson, you should have a basic understanding of these interesting technologies.
12. Database Terminology
This is a lesson that covers basic terminology needed to navigate and understand a database. From the definition of what a database itself is to the various relationships between the tables therein, this gives an overview of the language needed to get started.
13. Database Fields: Definition & Types
Database fields are the containers that store pieces of information or data in database tables. In this lesson, we will learn about database fields and explore some of the common types of database fields.
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 Analytics 103: Intro to Relational Databases & SQL course
- Relational Database Management Systems
- Relational Database Design Fundamentals
- Introduction to SQL Syntax & Queries
- Database Table Design & SQL Data Types
- Using SQL to Populate & Retrieve Data
- Modifying Data in Databases With SQL
- Using SQL to Remove Data
- Joins & Subqueries Using SQL
- Using Views, Indexes & Triggers in SQL