DBMS-II LAB

Paper Code: 
CBCA 502
Credits: 
3
Periods/week: 
6
Max. Marks: 
100.00
Objective: 

The course will enable the students to

  1. Design rich databases through MySQL for various applications.
  2. Database connectivity for interactive database operations.

 

Course Outcomes (COs):

 

Learning Outcome (at course level)

 

Learning and teaching strategies

Assessment Strategies

CO 189 Implement different types of DDL, DML and DCL statements in MySQL.

CO 190 Create, add records, retrieve and manipulate database using advanced functions.

CO 191 Implement constraints, subqueries and joins in databases

CO 192 Demonstrate database connectivity through MySQL to java

Interactive Lectures, Discussion, Tutorials, Reading assignments, Demonstrations, Team teaching, Teaching using advanced IT audio-video tools, G-suite.

Class test, Semester end examinations, Quiz, Solving problems in tutorials, Assignments, Presentation, Individual and group projects and peer review.

 

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.

 

Academic Year: 
2020-21
  • Printer-friendly version