DEV Community

Cover image for Relational Database
Rajon Dey
Rajon Dey

Posted on

Relational Database

Relational databases store data in tables consisting of rows and columns. Each table represents an entity (like customers or orders), and rows within the table represent individual records. The structure allows for easy data retrieval and management using SQL.

Popular Relational Database Management Systems (RDBMS)

  • MySQL: Widely used for web applications.
  • PostgreSQL: Known for its robustness and advanced features.
  • Oracle Database: Popular in large enterprises.
  • SQL Server: Common in environments that use Microsoft products.

What is SQL?

SQL (Structured Query Language) is the standard language for interacting with relational databases. It allows for querying, updating, and managing data.

Basic SQL Commands:

SELECT: Retrieves data from one or more tables.

SELECT * FROM Customers;
Enter fullscreen mode Exit fullscreen mode

INSERT: Adds new records to a table.

INSERT INTO Customers (Name, Email) VALUES ('John Doe', 'john@example.com');
Enter fullscreen mode Exit fullscreen mode

UPDATE: Modifies existing records.

UPDATE Customers SET Email = 'john.doe@example.com' WHERE Name = 'John Doe';
Enter fullscreen mode Exit fullscreen mode

DELETE: Removes records from a table.

DELETE FROM Customers WHERE Name = 'John Doe';
Enter fullscreen mode Exit fullscreen mode

Database Design Principles

Normalization and Its Forms

Normalization is the process of organizing data to reduce redundancy and improve data integrity. Common forms include:

  • 1NF (First Normal Form): Ensures that each column contains only atomic (indivisible) values.
  • 2NF (Second Normal Form): Requires that the table is in 1NF and all non-key columns are fully dependent on the primary key.
  • 3NF (Third Normal Form): Requires that the table is in 2NF and all columns are dependent only on the primary key.

Designing Efficient Databases

  • Define Clear Relationships: Use primary and foreign keys to define clear relationships between tables.
  • Indexing: Create indexes on frequently queried columns to speed up data retrieval.
  • Avoid Redundancy: Use normalization to eliminate redundant data, which can save storage space and improve performance.

A tool I like:
https://www.eraser.io/


Understanding these foundational concepts of relational databases will help you design and manage efficient, scalable, and reliable databases.

Top comments (0)