About This Chapter
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.
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
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.