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