HLCM25 – RDBMS

Please Login to view this page

Course Content

Expand All | Collapse All

Lessons Status

1

UNIT I – INTRODUCTION TO RDBMS

• Introduction
• RDBMS Terminology
• Relational Data Structure
• Codd’s Rule
• Relational Data Integrity and Database Constraints

2

UNIT II – ENTITY RELATIONAL MODELING

• Introduction
• ER-Model
• Components of an ER model
• ER-Modeling Symbols
• Relational Algebra and Relational Algebraic operations
• Relational Calculus

3

UNIT III – INTRODUCTION TO SQL

• Introduction
• SQL Datatypes and Literals
• Types of SQL Commands
• SQL operators
• Advantages of SQL

4

UNIT IV – QUERIES AND AGGREGATE FUNCTIONS

• Tables
• Views
• Indexes
• Queries and SubQueries
• Aggregate Functions
• Insert Update Delete Operations

5

UNIT V – DATA NORMALIZATION

• Introduction
• 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)
• Domain Key Normal Form
• Denormalization

QuizzesStatus

1

HLCM25 -RDBMS QUIZ

By Govindammal M | February 12, 2019 | PG Commerce-CA | Tags: pgcom