DATABASE MANAGEMENT SYSTEMS LAB

Paper Code: 
CCAI 402
Credits: 
03
Periods/week: 
06
Max. Marks: 
100.00
Objective: 

This course enables the students to:

  1. Design rich databases through MySQL for various applications.
  2. Apply MySQL to create, update and query databases.

 

Learning Outcome

Learning and Teaching Strategies

Assessment Strategies-

 

The Students will:

CO36. Construct database schema using data definition and manipulation statements in MySQL.

CO37. Create and manipulate databases using advanced functions.

CO38. Write SQL queries and implement constraints.

CO39. Execute queries, update data and prototype applications through MySQL Shell.

CO40. Design and develop a relational database for various application domains.

Approach in teaching:

Interactive Lectures, Discussion, Tutorials, Demonstrations.

 

  • Class test
  • Semester end examinations
  • Problem solving exercises
  • Assignments
  • Individual and group projects and peer reviews 

Following exercises should also be given to them:

  • Development of Database Applications (Application Domain):
  • Student database for school.
  • Employee database for a company.
  • Library Database for Library.
  • Railway Reservation System.
  • Hotel Reservation.
  • Inventory Control System.

 

 

ESSENTIAL READINGS: 

E-Resources including links:

 

Academic Year: 
2023-24
  • Printer-friendly version