About This Chapter
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
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Other chapters within the Computer Science 204: Database Programming course
- Creating & Managing Database Tables
- Populating & Retrieving Data in Databases
- Manipulating Data in Databases
- Data Queries in Multiple Tables Using Joins
- Data Queries in Multiple Tables Using Subqueries
- Views & Indexes in Databases
- Modifying Tables in Databases
- Manipulating Large Data Sets in Databases
- Developing & Using Regular Expressions in Databases
- Database Security