Copyright

Ch 1: Intro to Relational Database Management Systems

About This Chapter

If you need a quick introduction to relational database management systems, use this helpful chapter as your guide. Whether you're catching up in class or need a resource to use in your curriculum writing, this mobile-friendly and professionally written resource can help.

Intro to Relational Database Management Systems - Chapter Summary

In this chapter, you'll find a helpful introduction to relational database management systems you can use to refresh your knowledge of these subjects. Our lessons cover the elements and advantages of a relational database, database applications and different types of database programs. These lessons work equally well if you're new to these topics or want a quick refresher of information you already know. The quizzes along with each lesson provide a quick assessment you can use to guide your study more wisely. Help from one of our experts is available in the Dashboard should you need it. After completing this chapter, you should be able to:

  • Explain how to design a database schema
  • Give an example of SQL normalization
  • Outline the types of normal form in DBMS
  • Provide examples of first normal form and third normal form in DBMS
  • Define database query and its tools
  • Identify DDL, DCL and DML in MySQL
  • Discuss basic SQL commands in database management systems
  • Understand how to install Oracle Database Express Edition for database programming
  • Install MySQL and SQL Server Express Edition for database programming

14 Lessons in Chapter 1: Intro to Relational Database Management Systems
Test your knowledge with a 30-question chapter practice test
What is a Relational Database? - Elements, Design & Advantages

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

What is a Database Application?

2. What is a Database Application?

From social media to your bank, practically everything you do depends on a database. Database applications are used to access those databases in an efficient and secure way.

Database Programs: Types & Examples

3. Database Programs: Types & Examples

In this lesson you'll learn about databases and database programs. We'll look at examples of various types of database programs and highlight their differences in application.

How to Design a Database Schema

4. How to Design a Database Schema

Just as in construction, a solid database needs a blueprint. Database schemas are blueprints for databases. In this lesson, we will discuss how to design and create a database schema.

SQL Normalization: Example & Rules

5. SQL Normalization: Example & Rules

The amount of information we capture these days is staggering, so removing duplication is important. In this lesson, we'll take a look at SQL, normalization, and the rules associated with them.

What is Normal Form in DBMS? - Types & Examples

6. What is Normal Form in DBMS? - Types & Examples

This lesson explains the concept of correcting table structures in order to minimize database anomalies through a process called normalization. The normal process consists of multiple steps, called normal forms, each ensuring the elimination of the various types of anomalies.

First Normal Form in DBMS with Examples

7. First Normal Form in DBMS with Examples

First Normal Form might sound like the place to be if you're a database. But being first has its drawbacks. This lesson will define first normal form and provide real-world examples.

Third Normal Form in DBMS with Examples

8. Third Normal Form in DBMS with Examples

Normalization in databases help organize tables and keeps records clean. This lesson will cover the third normal form of database normalization which, through the extension of the second normal form (2NF), further reduces dependencies within the data.

Database Query: Definition & Tools

9. Database Query: Definition & Tools

This lesson will cover the concept of a database query. Database queries will be defined, and some basic examples will be explained. An example of query design using the Microsoft Access tool is described.

What are DDL, DML and DCL in MySQL?

10. What are DDL, DML and DCL in MySQL?

Information comes us at from many directions. Databases help us make sense of the information in our world. In this lesson, we'll take a look at a specific example, MySQL, and the commands that can be employed to make sense of data.

Basic SQL Commands in Database Management Systems (DBMS)

11. Basic SQL Commands in Database Management Systems (DBMS)

Basic SQL commands allow the user to achieve significant manipulation of data in the database. The database management system is the software that allows access to the database and to apply SQL commands to manage data.

Installing Oracle Database Express Edition for Database Programming

12. Installing Oracle Database Express Edition for Database Programming

This is a guided lesson where step-by-step instructions are provided to assist students in installing the free version of Oracle Database Express 11g along with the recent release of Oracle SQL Developer.

Installing MySQL for Database Programming

13. Installing MySQL for Database Programming

This lesson contains step-by-step guide to download, install, and configure the latest version of the free RDBMS, MySQL Community Server. The example executed on a 32-bit Windows 7 computer.

Installing SQL Server Express Edition for Database Programming

14. Installing SQL Server Express Edition for Database Programming

Microsoft SQL Server Express Edition is from the Microsoft family of database products which is a free downloadable product. This is a step-by-step guide to install MS SQL Server 2017 Express Edition and to test to ensure that the installation is successful.

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