CS311

DATABASE MANAGEMENT SYSTEMS LABORATORY

Credit: 2

Objectives

  • To explore the features of a Database Management Systems
  • To interface a database with front end tools
  • To understand the internals of a database system

 

Outcomes

  • Ability to use databases for building client server applications
  • Gaining knowledge about the internals of a database system

 

Experiments

  • Working with DDL,DML and DCL
  • Inbuilt functions in RDBMS.
  • Nested Queries & Join Queries.
  • Set operators & Views in SQL.
  • Control structures.
  • Working with Procedures and Functions.
  • Triggers
  • Dynamic & Embedded SQL
  • Working with XML Forms & Reports
  • Database Design and implementation (Mini Project)

 

References

  1. Abraham Silberschatz, Henry F. Korth, and S.Sudharshan, “Database System Concepts”,6th edition, Tata McGraw Hill, 2011
  2. Ramez Elmasri and Shamkant B. Navathe, “Fundamentals of Database Systems”, 4th Edition, Pearson/Addision wesley, 2007