First Normal Form (1NF) » CS Taleem

Introduction To DBMS

Database System

Structured Vs Unstructured Database

File System Vs DBMS

DBMS Architecture

Three Schema Architecture

Schema in DB

Data Independence

Database Languages

Data Modeling

ER Model And Its Symbols

Entity in ER Model

Attributes in ER Model

Relationships in ER Model

Cardinality and Modality in ER Model

Participation Constraints in ER Model

Extended ER Model

Keys And Its Types

Relational Data Model

Introduction to Relational Algebra

Unary Operators in Relational Algebra

Binary Operators in Relational Algebra

Extended Operators in Relational Algebra

Natural Join

Outer Join And Its Types

Equi Join

Normalization

Functional Dependency (FD)

Inference Rule (IR)

Redundancy Problems

Closure Method In DBMS

Candidate vs. Super Key AND Prime vs. Non-Prime Attributes

Normalization And Its Types

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce Codd Normal Form (BCNF)

Fourth Normal Form (4NF)

Fifth Normal Form (5NF)

Important Points of Normal Forms

Relational Decomposition

Lossless Decomposition

Dependency Preserving Decomposition

Decomposition Without Dependency Preserving

Equivalence of Two Sets of FD’s

Non Prime Attribute in DBMS

Transaction

Transaction in Database

Transaction Properties

Transaction States

Schedule In DBMS

Conflict in DBMS | Expert Guide

Serializability In DBMS

Topological Sort Examples

Conflict Equivalent Schedule

Recoverability of Schedule

Types of Recoverable Schedules

Serial Vs. Non-Serial Schedules

Conflict Serializability

Concurrency Control

Concurrency Problems In Database

Lock Based Concurrency Control Protocol

Two Phase Locking Protocol

Categories of Two Phase Locking

Timestamp Ordering Protocol

Conflicts in Timestamp Protocol

Timestamp Ordering With Examples

First Normal Form (1NF)

According to first normal form (1NF),

The table should not contain any multivalued attributes. It should only have single (atomic) valued attributes/columns.
Column names of entire tables should be unique.

Note: The primary key will be the composite key, i.e. (“Std_ID” and “Std_Course”) in the above example.