Relational Database and Normalization

Kursusindhold

Relational Database and Normalization

1. Database Models

Introduction Difference between Relational and Non-relational Databases Entity-Relationship Model Entity-Relationship Model. Relationships

2. Relational Database

Structure. Primary Key and Foreign Key Foreign Key Constraints. ON DELETE Options Many-to-One and One-to-Many One-to-One and Many-to-Many

3. Normalization and Normal Forms

Normalization First Normal Form Second Normal Form Third Normal Form

Introduction

Basic Concepts

Databases are ubiquitous, but no single database model can cater to the diverse needs of various projects and servers. There's a spectrum of database types and database management systems.

Database (DB) is a repository of information;
Database Management System (DBMS) offers a suite of tools to manage and interact with a database. It allows users to oversee the data, structure the database, and provides an interface for these operations.

Primarily, there are two database models: relational and non-relational. Additionally, there are multi-model database management systems, such as Oracle Database.

Non-relational databases encompass a variety of types, including document data stores, column-oriented databases, key-value stores, and graph databases.

The most popular databases

1. What models are databases divided into?

2. Choose relational databases:

3. Choose non-relational databases:

What models are databases divided into?

Select the correct answer

Relational Databases

Non-Relational Databases

Multi-Model Databases

Oracle Databases

Choose relational databases:

Select the correct answer

MySQL

MongoDB

Redis

PostgreSQL

Choose non-relational databases:

Select the correct answer

MySQL

MongoDB

Redis

PostgreSQL

Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 1. Kapitel 1

Spørg AI

Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat

Kursusindhold

Relational Database and Normalization

1. Database Models

Introduction Difference between Relational and Non-relational Databases Entity-Relationship Model Entity-Relationship Model. Relationships

2. Relational Database

Structure. Primary Key and Foreign Key Foreign Key Constraints. ON DELETE Options Many-to-One and One-to-Many One-to-One and Many-to-Many

3. Normalization and Normal Forms

Normalization First Normal Form Second Normal Form Third Normal Form

Introduction

Basic Concepts

Databases are ubiquitous, but no single database model can cater to the diverse needs of various projects and servers. There's a spectrum of database types and database management systems.

Database (DB) is a repository of information;
Database Management System (DBMS) offers a suite of tools to manage and interact with a database. It allows users to oversee the data, structure the database, and provides an interface for these operations.

Primarily, there are two database models: relational and non-relational. Additionally, there are multi-model database management systems, such as Oracle Database.

Non-relational databases encompass a variety of types, including document data stores, column-oriented databases, key-value stores, and graph databases.

The most popular databases

1. What models are databases divided into?

2. Choose relational databases:

3. Choose non-relational databases:

What models are databases divided into?

Select the correct answer

Relational Databases

Non-Relational Databases

Multi-Model Databases

Oracle Databases

Choose relational databases:

Select the correct answer

MySQL

MongoDB

Redis

PostgreSQL

Choose non-relational databases:

Select the correct answer

MySQL

MongoDB

Redis

PostgreSQL

Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 1. Kapitel 1