Skip to content

sharpchen

Main Navigation

👾 Csharp Design Patterns

🗿 Entity Framework Core

😬 HTML & CSS

🐚 Powershell

Articles Home

Appearance

Sidebar Navigation

SQL

Complex Query

ALL and ANY

Correlated subqueries

EXISTS

Subquery

Data Types

Designing Database

Normal Forms

Essenitial Functions

Functions

Inserting, Updating, and Deleting Data

Create a Copy of a Table

Deleting Records

Inserting Records

Update Records

Retrieving Data From Multiple Tables

CROSS JOIN Clause

INNER JOIN Clause

NATURAL JOIN Clause

OUTER JOIN Clause

UNION Operator

USING Clause

Retrieving Data From Single Table

LIMIT clause

ORDER BY clause

Operators

SELECT Statement

Stored Procedures and Stored Functions

Basic Function Syntax

Basic Procedure Syntax

Control Flow Statements

Define a Variable

OUT Modifier

Raise Exception in SQL

Value Assignment

Summarizing Data

Aggregate Functions

The GROUP BY Clause

The HAVING Clause

Transactions

Transaction Isolation Levels

Transactions

View

On this page

Normal Forms

1NF

A table must not have duplicate columns.

2NF

Each table should only describe one entity, and all columns of the table should describe the entity.

3NF

Columns should not be derived from other tables.

Edit this page on GitHub

Last updated:

Pager

Previous pageData Types

Next pageFunctions

Normal Forms ​

1NF ​

2NF ​

3NF ​

Normal Forms

1NF

2NF

3NF