Database Management System Unit-2

NA

December 17, 2020 March 08, 2021

Relational data Model and Language: Relational Data Model Concepts, Integrity Constraints,

Entity Integrity, Referential Integrity, Keys Constraints, Domain Constraints, Relational Algebra,

Relational Calculus, Tuple and Domain Calculus. Introduction on SQL: Characteristics of SQL,

Advantage of SQL. SQl Data Type and Literals. Types of SQL Commands. SQL Operators and

Their Procedure. Tables, Views and Indexes. Queries and Sub Queries. Aggregate Functions.

Insert, Update and Delete Operations, Joins, Unions, Intersection, Minus, Cursors, Triggers,

Procedures in SQL/PL SQL.