Database Management System Lab

Subject Code: CIC 256

Faculty Coordinator Ms. Vanshika Grover
Lab Technician Shiv Karan Nishad
Software MySQL

Introduction

The objective of this lab course is to understand the practical applicability of database management system concepts. Working on existing database systems, designing databases, creating relational databases, and analysing table design. The lab course also provides practical knowledge to understand advanced database concepts such as data mining and Big Data Analysis.

Objectives of the Laboratory

S. No. Objective
1 Students get practical knowledge on designing and creating relational database systems.
2 Understand various advanced query executions such as relational constraints, joins, set operations, aggregate functions, triggers, views and embedded SQL.
3 Use of various software to design and build ER Diagrams, UML, and flowcharts for related database systems.
4 Students will be able to design and implement database applications on their own.