DBMS-I LAB

Paper Code: 
CBCA 306
Credits: 
03
Periods/week: 
03
Max. Marks: 
100.00
Objective: 

The course will enable the students to

  1. Make ER-Diagrams
  2. Use Relational Algebra
  3. Use SQL to extract data from tables.

 

Course Outcomes (COs):

Learning Outcome

(at course level)

Learning and teaching strategies

Assessment Strategies

The students will:

CO 121.Design the structure of databases and tables

CO 122.Create entity relationship diagrams for modelling logical schema

CO 123.Implement the basic relational algebra concepts

CO 124.Create and manipulate data through SQL

CO 125.Design and build a simple database system for a real world application

 

Interactive Lectures, Discussion, Tutorials, reading assignments, Demonstrations,  G-suite. Self-learning assignments, Effective questions, Seminar presentation, Giving tasks, Performing practical

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

 

 

This paper will be based on theory paper CBCA305. Exercises given will be covering entire syllabi as follows:

  • ER-Diagrams
  • Relational Algebra
  • SQL

 

Academic Year: 
2021-22
  • Printer-friendly version