MySQL Lab

Paper Code: 
25CBDA214
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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

25CBDA214

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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:

  1. Development of Data  Base  Applications (Application Domain):
  2. Student database for school.
  3. Employee database for a company.
  4. Library Database for Library.
  5. Railway Reservation System.
  6. Hotel Reservation.
  7. Inventory Control  System.
ESSENTIAL READINGS: 

1.  Abraham Silberschatz, Henry  Korth,  S. Sudarshan, “Database SystemsConcepts”,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 READINGS:

1.   R. Elmarsi and  S.B. Navathe, “Fundamentals of Database Systems”, AddisonWesley,  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: 
2025-26
  • Printer-friendly version