learningmonkey01@gmail.com

Follow Us :

Home
Courses
About Us
FAQs
Blog
Contact

GATE Bits 11 on Normalization

Home
GATE Bits 11 on Normalization

Database Management Systems GATE Bits 11 on Normalization

GATE Bits 11 on Normalization

For Complete YouTube Video: Click Here

Previous Lesson

Course Home

Introduction

Understanding the Definition of Data and Database

Definition of Database Management Systems DBMS

File System v/s Database Management System DBMS

An Example Database – Company Database

Entity Relationship Model

Database Design using Entity-Relationship Model ER-Model

Definitions of Entity Attribute and Entity Type

Simple and Composite Attributes

Single-Valued and Multi-Valued Attributes

Stored and Derived Attributes

Key Attributes of an Entity Type

Identifying the Entity Types and Attributes from the Requirements

Identifying the Relationship Types between the Entity Types

Relationship Instance and the Degree of a Relationship Type

Identifying another Relationship Type and Understanding Attributes of a Relationship Type

Cardinality Ratio of a Binary Relationship

Participation Constraint

Many to Many Relation on Works_On Relationship Type

One to Many Relation on Controls Relationship Type

Role Names of an Entity Type in a Relationship Type

Recursive Relationships

Weak Entity Types

Relational Database Management Systems

Requirements to ER Diagrams to Database Schema

Relation Attributes and Tuples in RDBMS

Domain Relation Schema and Relation State in RDBMS

ER Diagram to Database Scheme 1

How to Download and Install Oracle 18c

CREATE TABLE Command in SQL

INSERT INTO command in SQL

Understanding the use of NOT NULL and Primary Key

Relational Model Constraints Domain constraints

Key Constraints and NULL Value Constraints

Referential Integrity constraints and Foreign Keys

Implementation of Referential Integrity Constraint Using Foreign keys

One-to-One Relationships in ER Diagram to Database Schema

Multivalued Attributes to Database Schema

One-to-Many Relationships to Database Schema

Structured Query Language - SQL

Implementing the Complete Company Database

ALTER TABLE Command in SQL

ADD and DROP a Constraint using ALTER TABLE command in SQL

TRUNCATE TABLE and DROP TABLE Commands in SQL

SELECT Command in SQL

WHERE Clause in SQL

UPDATE Command in SQL

DELETE Command in SQL

COMMIT and ROLLBACK Commands in SQL

Equal to Greater than Less than Not Equal to Operators in SQL

LIKE Operator in SQL

IS NULL and IS NOT NULL Operators in SQL

IN and NOT IN Operators in SQL

BETWEEN and NOT BETWEEN Operators in SQL

AND OR NOT Logical Connectors in SQL

UPPER LOWER INITCAP in SQL

RPAD and LPAD in SQL

LTRIM and RTRIM Functions in SQL

LENGTH SUBSTR INSTR Functions in SQL

ABS CEIL FLOOR functions in SQL

MOD POWER SQRT functions in SQL

ROUND and TRUNC functions in SQL

NVL Function in SQL

AVG COUNT MAX MIN SUM Functions in SQL

SYSDATE CURRENT_DATE SYSTIMESTAMP Functions in SQL

DATE Arithmetic Difference between the dates

ADD_MONTHS GREATEST LEAST TO_DATE Functions in SQL

NEXT_DAY LAST_DAY MONTHS_BETWEEN Functions in SQL

ORDER BY in SQL

DISTINCT in SQL

CARTESIAN PRODUCT in SQL

Aliasing and AS Operator in SQL

SQL Query 1 on Multiple Tables

SQL Query 2 on Multiple Tables

SQL Query 3 on Multiple Tables

INTERSECT Operator in SQL

UNION UNION ALL MINUS Set Operators in SQL

Nested Queries 1 in SQL

Nested Query 2 in SQL

Nested Query 3 in SQL

Nested Query 4 in SQL

GROUP BY and HAVING in SQL

Example 1 of GROUP BY and HAVING in SQL

Example 2 on GROUP BY and HAVING in SQL

INNER JOIN in SQL

LEFT JOIN RIGHT JOIN and FULL JOIN in SQL

Correlated Nested Queries in SQL

EXISTS and NOT EXISTS in SQL

Understanding ALL ANY or SOME in SQL

Example 1 on Correlated Nested Queries in SQL

Example 2 on Correlated Nested Queries in SQL

Introduction to Relational Algebra and its operators in DBMS

Rename Union Intersection Set Difference and Cartesian Product Operators in Relational Algebra

Inner join Theta join Equi join Natural join

Outer join Left outer join Right outer join Full outer join

Understanding Division Operator in Relational Algebra

Solving Examples on Relational Algebra

Understanding Relational Calculus and Types of Relational Calculus

Existential Quantifier and Universal Quantifier

Transforming Universal and Existential Quantifiers

Relationally Complete Language, Safe and Unsafe Expressions

Examples 01 on Tuple Relational Calculus

Examples 02 on Tuple Relational Calculus

Domain Relational Calculus

GATE Bits 07 on Relational Algebra and Relational Calculus

GATE Bits 08 on Relational Algebra and Relational Calculus

GATE Bits 09 on Relational Algebra and Relational Calculus

Introduction to Normalization

Redundancy and Anomalies

Understanding Functional Dependencies

Understanding Super Key, Key, Candidate Key and Primary key

Armstrong’s Axiom

Closure of the Functional Dependency

Determining Candidate Keys

Example 01, 02 on Determining Candidate Keys

GATE Bits 10 on Determining Candidate Keys

Equivalence of Functional Dependencies

Minimal Cover or Canonical Cover

First Normal Form 1NF

Lossless Decomposition

Dependency Preserving Decomposition

Second Normal Form 2NF

Examples on Second Normal Form 2NF

Third Normal Form 3NF

Examples on Third Normal Form 3NF

Boyce Codd Normal Form BCNF

Examples on Boyce Codd Normal Form BCNF

GATE Bits 11 on Normalization

GATE Bits 12 on Normalization

GATE Bits 13 on Normalization

GATE Bits 14 on Normalization

Return to Database Management Systems

Learning Monkey is perfect platform for self learners.

Contact Us

learningmonkey01@gmail.com

www.learningmonkey.in

© 2021Learning Monkey. All rights reserved.