MySQL Lab

Paper Code: 
24CBDA214
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. To apply MySQL to create, update and query database.

 

Course Outcomes: 

Course

Learning outcome

(at course level)

Learning and teaching strategies

Assessment Strategies

Course

Code

Course

Title

24CBDA214

MySQL Lab

(Practical)

 

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

CO80. Create and manipulate database using advanced functions.

CO81. Implement constraints, subqueries and joins in databases

CO82. Demonstrate database connectivity through MySQL to python

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

CO84. Contribute effectively in course-specific interaction

Approach in teaching:

Interactive Lectures, Discussion, Reading assignments, Demonstrations.

  • Class test
  • Semester end examinations
  • Quiz
  • Assignments
  • Presentations
  • Individual and group projects and peer reviews
 

 

Following exercises should also be given to them:

  • Development of Data Base 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. Abraham Silberschatz, Henry Korth, S. Sudarshan, “Database Systems Concepts”,7th Edition, McGraw Hill, 2021.
  2. Aspin, Adam. “Querying MySQL: Make Your MySQL Database Analytics Accessible with SQL Operations, Data Extraction, and Custom Queries.” BPB Publications, 29 July 2022.

 

REFERENCES: 

SUGGESTED REFERENCE BOOKS

  1. R. Elmarsi and S.B. Navathe, “Fundamentals of Database Systems”, Addison Wesley, 7th Ed., 2016.
  2. A. K. Majumdar, P. Battacharya, “Database Management Systems’, TMH, 2017.
  3. Bipin Desai, “An Introduction to Database Systems”, Galgotia Publications, 2015.

 

      e-RESOURCES:

1. mysql, spoken tutorial: https://spoken-tutorial.org/

2. https://www.slideshare.net/medhedhly/database-management-systems-

27179628

 3. introduction to database systems and design, iit madras:                 https://nptel.ac.in/courses/106106095

 4. mysql, spoken tutorial: https://spoken-tutorial.org/

 

       Journals:  

  1. https://www.journals.elsevier.com/international-journal-of-information-management-data-insights
  2. https://dl.acm.org/journal/jdbm

 

Academic Year: 
2024-25
  • Printer-friendly version