Database Management System (303105203)
Unit – 1: Introduction
, SYLLABUS
• UNIT-1
• Introduction: Introduction and applications of DBMS, File Processing System and its
limitations, ANSI/SPARC Model, Data Independence, Client-Server Architecture, Users &
DBA, Database Architecture.
• UNIT-2
• SQL: Data Definition Language (DDL) commands, Data Manipulation Language (DML)
commands, Data Control Language (DCL) commands, Transaction Control Language (TCL)
commands.
• Predicates & Clauses: Logical Operators (AND / OR), Relational Operators, BETWEEN
Predicate, IN & NOT IN Predicate, LIKE Predicate.
• Functions in SQL: Aggregate Functions, Character Functions, Arithmetic Functions,
• Date Functions, Conversion Functions.
, SYLLABUS
• UNIT-3
• Data Models: Hierarchical Model, Network Model, Relational Model, Object Oriented Model.
• E-R Diagram: Introduction to E-R Diagram, Entities, Attributes & its types, Relationships, Mapping
Cardinalities, Participation Constraints, Weak Entity Sets, Specialization, Generalization, Aggregation.
• UNIT-4
• Relational Data Model: Introduction, Degree, Cardinality.
• Constraints & Keys: Primary Key, Foreign Key, Super Key, Candidate Key, Not Null Constraint, Check
Constraint. Relational Algebra Operations: Selection, Projection, Cross-Product, Rename, Joins (Natural
& Outer Join), Set Operators (Union, Intersection, Set Difference), Aggregate Functions
, SYLLABUS
• UNIT-5
• UNIT-6
• Relational Data Model: Introduction, Degree, Cardinality.
• Constraints & Keys: Primary Key, Foreign Key, Super Key, Candidate Key, Not Null Constraint, Check
Constraint. Relational Algebra Operations: Selection, Projection, Cross-Product, Rename, Joins (Natural
& Outer Join), Set Operators (Union, Intersection, Set Difference), Aggregate Functions
Unit – 1: Introduction
, SYLLABUS
• UNIT-1
• Introduction: Introduction and applications of DBMS, File Processing System and its
limitations, ANSI/SPARC Model, Data Independence, Client-Server Architecture, Users &
DBA, Database Architecture.
• UNIT-2
• SQL: Data Definition Language (DDL) commands, Data Manipulation Language (DML)
commands, Data Control Language (DCL) commands, Transaction Control Language (TCL)
commands.
• Predicates & Clauses: Logical Operators (AND / OR), Relational Operators, BETWEEN
Predicate, IN & NOT IN Predicate, LIKE Predicate.
• Functions in SQL: Aggregate Functions, Character Functions, Arithmetic Functions,
• Date Functions, Conversion Functions.
, SYLLABUS
• UNIT-3
• Data Models: Hierarchical Model, Network Model, Relational Model, Object Oriented Model.
• E-R Diagram: Introduction to E-R Diagram, Entities, Attributes & its types, Relationships, Mapping
Cardinalities, Participation Constraints, Weak Entity Sets, Specialization, Generalization, Aggregation.
• UNIT-4
• Relational Data Model: Introduction, Degree, Cardinality.
• Constraints & Keys: Primary Key, Foreign Key, Super Key, Candidate Key, Not Null Constraint, Check
Constraint. Relational Algebra Operations: Selection, Projection, Cross-Product, Rename, Joins (Natural
& Outer Join), Set Operators (Union, Intersection, Set Difference), Aggregate Functions
, SYLLABUS
• UNIT-5
• UNIT-6
• Relational Data Model: Introduction, Degree, Cardinality.
• Constraints & Keys: Primary Key, Foreign Key, Super Key, Candidate Key, Not Null Constraint, Check
Constraint. Relational Algebra Operations: Selection, Projection, Cross-Product, Rename, Joins (Natural
& Outer Join), Set Operators (Union, Intersection, Set Difference), Aggregate Functions
