Ch 1: Introduction to General & Relational Databases

About This Chapter

You can use this chapter as an introduction to relational and general databases on any mobile device or computer. This resource was written by professionals to help you finish a tough homework assignment or study for an upcoming test with ease.

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

13 Lessons in Chapter 1: Introduction to General & Relational Databases
Test your knowledge with a 30-question chapter practice test
What are Data? - Types, Sources & Definition

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.

What are Databases? - Examples & Types

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.

What is Database Management? - How Databases Help Organizations

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.

What is an Entity in a Database?

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.

What is an Attribute in a Database?

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.

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

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.

Relational Model for Managing Data: History, Concepts & Examples

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.

Flat File Database: Definition & Example

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.

Flat File Database vs. Relational Database

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.

Hierarchical Database: Model & Definition

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.

Hierarchical Database vs. Relational Database

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.

Database Terminology

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.

Database Fields: Definition & Types

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.

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