Gain insights into fundamental database concepts, relational databases, and entity-relationship diagrams. Learn about normalization techniques and basics of SQL to enhance database efficiency.

Databases are universal - they underlie the technology you use every day. They're a crucial component of everything from telecommunications systems, banking systems, and video games to just about any other software system that maintains some amount of persistent data.

In this course, you'll learn about the fundamental concepts of databases, why and when they're used, what relational databases are, and entity-relationship diagrams. You will also be exposed to techniques like normalization that help to increase the efficiency of databases. You'll wrap up with a look at the basics of Structured Query Language (SQL). 

After completing this course, you will be able to move onto more advanced courses involving database systems and SQL.

Database Design Fundamentals for Software Engineers

## Benefits of using the database approach

We will now discuss some advantages of using a database system and the capabilities that a good DBMS should possess:

### 1. Control of data redundancy

In the database approach, ideally, each data item is stored in only one place in the database. This is known as **data normalization**, and it ensures consistency and saves storage space. In some cases, data redundancy still exists to improve system performance but it is kept to a minimum.

### 2. Data sharing

The integration of all the data for an organization within a database system has many advantages. First, it allows for data sharing among employees and others who have access to the system. Second, it gives users the ability to generate more information from a given amount of data than would be possible without the integration.

### 3. Enforcement of integrity constraints

Database management systems must be able to define and enforce certain constraints to ensure that users enter valid information and maintain data integrity. A database constraint is a restriction or rule that dictates what can be entered or edited in a table, such as adding a valid course name in the `Course_Name` column in the COURSE table.

There are many types of database constraints. One of them is data type, which determines the sort of data that can be entered. For example, integers only. Another restraint is **data uniqueness**, which specifies that data item values must be unique, such as every record in the STUDENT table must have a unique value for `ID`.

### 4. Restriction of unauthorized access

Not all users of a database system will have the same access privileges. For example, one user might have **read-only** access (i.e., the ability to read a file but not make changes), while another might have **read and write privileges** (which is the ability to both read and modify a file). For this reason, a database management system should provide a security subsystem to create and control different types of user accounts and restrict unauthorized access.

### 5. Backup and recovery facilities

Backup and recovery are methods that allow you to protect your data from loss. The database system provides a facility for backing up and recovering data. If a hard drive fails and the database stored on the hard drive is not accessible, the only way to recover the database is with a backup.

If a computer system fails in the middle of a complex update process, the recovery subsystem is responsible for making sure that the database is restored to its original state. 


---

The next lesson will include a quick quiz to test your knowledge of these fundamentals.


# Benefits of using the database approach

We will now discuss some advantages of using a database system and the capabilities that a good DBMS should possess:

## 1. Control of data redundancy

In the database approach, ideally, each data item is stored in only one place in the database. This is known as **data normalization**, and it ensures consistency and saves storage space. In some cases, data redundancy still exists to improve system performance but it is kept to a minimum.

## 2. Data sharing

The integration of all the data for an organization within a database system has many advantages. First, it allows for data sharing among employees and others who have access to the system. Second, it gives users the ability to generate more information from a given amount of data than would be possible without the integration.

## 3. Enforcement of integrity constraints

Database management systems must be able to define and enforce certain constraints to ensure that users enter valid information and maintain data integrity. A database constraint is a restriction or rule that dictates what can be entered or edited in a table, such as adding a valid course name in the `Course_Name` column in the COURSE table.

There are many types of database constraints. One of them is data type, which determines the sort of data that can be entered. For example, integers only. Another restraint is **data uniqueness**, which specifies that data item values must be unique, such as every record in the STUDENT table must have a unique value for `ID`.

## 4. Restriction of unauthorized access

Not all users of a database system will have the same access privileges. For example, one user might have **read-only** access (i.e., the ability to read a file but not make changes), while another might have **read and write privileges** (which is the ability to both read and modify a file). For this reason, a database management system should provide a security subsystem to create and control different types of user accounts and restrict unauthorized access.

## 5. Backup and recovery facilities

Backup and recovery are methods that allow you to protect your data from loss. The database system provides a facility for backing up and recovering data. If a hard drive fails and the database stored on the hard drive is not accessible, the only way to recover the database is with a backup.

If a computer system fails in the middle of a complex update process, the recovery subsystem is responsible for making sure that the database is restored to its original state. 


---

The next lesson will include a quick quiz to test your knowledge of these fundamentals.


In this lesson we will discuss the advantages of the database approach.

Introduction

Fundamental Concepts

Data Modeling

Entity-Relationship Data Model

The Relational Data Model

Functional Dependencies

Normalization

Structured Query Language

Conclusion

Benefits of the Database Approach

Benefits of using the database approach

1. Control of data redundancy