DATABASE MANAGEMENT SYSTEMS LAB

Paper Code: 
24CCAI402
Credits: 
02
Periods/week: 
04
Max. Marks: 
100.00
Objective: 

Objectives:

This course enables the students to

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

 

 

Course Outcomes: 

Course

Learning outcome

(at course level)

Learning and teaching strategies

Assessment Strategies

Course Code

Course

title

 

24CCAI 402

 

DATABASE MANAGEMENT SYSTEMS LAB

(PRACTICAL)

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

CO44. Create and manipulate databases from different domains using advanced functions.

CO45. Design SQL queries and implement constraints.

CO46. Solve queries, update data and prototype applications through MySQL Shell.

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

CO48. Contribute effectively in course-specific interaction

 

Approach in teaching:

Interactive Lectures, Discussion, Demonstrations.

 

Learning activities for the students:

 

Self-learning assignments, Practical questions

 

 

  • 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: 

Suggested Text Books:

  1. Silberschatz & H. F. Korth, “Database System Concepts”, Seventh edition, McGraw Hill, 2021. 
  2. Leon & Leon, “SQL”, Tata McGraw Hill.

 

REFERENCES: 
Suggested Reference Books:
  1. R. Ramakrishnan and J. Gharke, “Database Management System”, Tata McGraw Hill.
  2. C. J. Date, “Database Management System”, Pearson Education Asia.
  3. Sumita Arora,“Informatics Practices”, Dhanpat Rai & Co.

 

Reference Journals:

 

  1. International Journal of Intelligent Information and Database Systems, https://www.inderscience.com/jhome.php?jcode=ijiids
  2. Database Management Systems, Elsevier,  https://www.elsevier.com/books/database-management-systems/gorman/978-0-7506-0135-
  3. International Journal of Database Management Systems (Open Acess), airccse,  https://airccse.org/journal/ijdms/index.html 
  4. Journal of Database Management, IGI Global, https://www.igi-global.com/journal/journal-database-management-jdm/1072

 

e-Resources including links

 

  1. Database Management System, Prof. Partha Pratim Das, NPTEL/ SWAYAM/ SWAYAMPRABHA, https://swayamprabha.gov.in/index.php/program_data/flipMore/R10/13
  2. Database Management System, Prof. S. Srinath, https://swayamprabha.gov.in/index.php/search
  3. Database  System  http://ndl.iitkgp.ac.in/document/OEYweXpIRmlkYURkM3JkbUdtKy9UWmdVNEMreENBMmpNMk1GbFNoejlmZjk1SklyVk50eWZ5UUFZek1zaHpRbEhVc1d0ZzdaTnM4bjlQbHNvaEpRdGc9PQ
  4. Cloud Computing A practical approach for learning and implementation, A. Srinivasan, J. Suresh, Pearson

 

Academic Year: 
2024-25
  • Printer-friendly version