Copyright

Ch 6: Database Structure

About This Chapter

Use this chapter to learn about database structure and the different types of databases. These engaging lessons show you essential database terminology and concepts that can enhance your professional skills and knowledge.

Database Structure Basics - Chapter Summary

This chapter contains several lessons covering the basics of database structure. You'll learn about several types of databases and understand the differences between them. The chapter also covers database terms and instruction on how to design a relational database.

These lessons are taught by professional instructors who present database structure concepts in a clear and engaging way. Our lessons lay out key definitions, which helps you quickly scan and review the concepts you've been learning. Self-assessment quizzes are included at the end of each lesson so you can check your understanding of the material and make sure you've got a firm handle on the most important concepts.

How It Helps

These comprehensive lessons help you understand the structures, purposes, functionalities, benefits and differences between multiple types of databases used in professional businesses and organizations. This type of knowledge can be beneficial for professionals who want to expand their database understanding or find database solutions for their companies. The chapter also teaches you how to design a relational database, which can be helpful for supplementing and expanding your skills in database design and structure.

Skills Covered

By the end of this chapter, you'll be able to:

  • Model and design a relational database
  • Define several types of databases, including SQL, NoSQL and subject
  • Understand database objects, fields, indices and schema
  • Differentiate between flat file databases, hierarchical databases and relational databases
  • Explain database attributes and entities
  • Describe conventions for database tables
  • Types of NoSQL databases

16 Lessons in Chapter 6: Database Structure
Test your knowledge with a 30-question chapter practice test
Relational Database: Model & Example

1. Relational Database: Model & Example

Relational databases help make up some of the most common uses of computers that we have. In this lesson, we'll see what relational databases are, and how they are used and structured.

Designing a Relational Database: Tutorial & Overview

2. Designing a Relational Database: Tutorial & Overview

This lesson is designed to teach the basic steps in relational database design using a library as an illustrative example. Basic relational database terminology is defined and explained with illustrations.

Flat File Database: Definition & Example

3. 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

4. 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

5. 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

6. 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.

What are Subject Databases? - Definition & Types

7. What are Subject Databases? - Definition & Types

In this lesson, you will learn how subject databases can benefit your research. You will also get a sneak peek into how subject databases work behind the scenes.

Design for Databases & SQL

8. Design for Databases & SQL

An SQL database is a relational database that makes uses of the Structured Query Language (SQL) to query or communicate with the database. In this lesson, we will learn more about SQL databases.

What is a Database Schema? - Example & Definition

9. What is a Database Schema? - Example & Definition

A database schema is the blueprint that defines the database structure. The schema tells the database engine, the program that runs the database, how to put and get information in a database. The schema provides the framework for the database operations and contents.

What is a Database Index? - Definition & Tutorial

10. What is a Database Index? - Definition & Tutorial

Have you ever wondered if there was tool to help you with finding information more quickly? We will explore the different types of database indexes and how they can help you save time in this lesson.

Database Table: Design & Conventions

11. Database Table: Design & Conventions

A database consists of at least one table, the components of which are standardized regardless of the content found within the table. This lesson defines and provides examples of the design and conventions used to create a database table.

Database Fields: Definition & Types

12. 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.

What are Database Objects? - Definition & Examples

13. What are Database Objects? - Definition & Examples

Having trouble telling the difference between an object and a record? This lesson will help explain what database objects are as well as provide examples of them.

What is an Attribute in a Database?

14. 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 an Entity in a Database?

15. 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.

NoSQL Databases: Design & Types

16. NoSQL Databases: Design & Types

There are alternatives to SQL databases and relational databases in general. This lesson covers these alternate database management systems, referred to as NoSQL databases.

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 160 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