Database Management System Unit 2 Notes AKTU (BCS501)

AKTU · BTECH · Semester 5 · Database Management System · Unit 2 · Notes

AKTU Database Management System (BCS501) Unit 2 notes for B.Tech Semester 5 – Relational Model and SQL. Topics: Relational Data Model, SQL Basics and…

Open the interactive reader to study this resource on AcademicArk.

Main version of this resource: Database Management System Unit 2 Notes AKTU (BCS501)

Unit 2: Relational Model and SQL – AKTU syllabus topics

  • Relational Data Model: Entity Referential Integrity Constraints, Relational Algebra, Tuple and Domain Calculus
  • SQL Basics and Commands: SQL Data Types Commands, Tables Views Indexes
  • SQL Queries and Operations: Aggregate Functions Subqueries, Joins Unions Intersection Minus, Insert Update Delete Operations
  • Cursors Triggers Procedures

AKTU paper codes: BCS501, KCS501, RCS501

Other Database Management System units

Database Management System previous year papers

More Database Management System resources

Browse all notes · Semester 5 notes