MYSQL LAB

Paper Code: 
CBDA 214
Credits: 
3
Periods/week: 
6
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 (COs).

 

Course Outcome (at course level)

 

Learning and teaching strategies

Assessment Strategies

On completion of this course, the students will:

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

CO68. Create and manipulate database using advanced functions.

CO69. Implement constraints, subqueries and joins in databases

CO70. Demonstrate database connectivity through MySQL to python

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

 

Approach in teaching:

Interactive Lectures, Discussion, Tutorials, Reading assignments, Demonstrations.

  • Class test
  • Semester end examinations
  • Quiz
  • Solving problems in tutorials
  • 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: 
E-RESOURCES:
  • https://spoken-tutorial.org/
  • https://www.slideshare.net/
  • https://pll.harvard.edu/subject/computer-science
  • https://onlinecourses.nptel.ac.in/
 
 
JOURNALS:  
  • https://www.journals.elsevier.com/international-journal-of-information-management-data-insights
  • https://journal-bcs.springeropen.com/
 
Academic Year: 
2022-23
  • Printer-friendly version