DBMS-I LAB

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

Course Objectives:

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

CO 113 Design the structure of databases and tables

CO 114 Create and explain entity relationship diagrams

CO 115 Implement the basic relational algebra concepts

CO 116 Manipulate data through SQL

Interactive Lectures, Discussion, Tutorials, reading assignments, Demonstrations, Team teaching, Teaching using advanced IT audio-video tools, G-suite. Self-learning assignments, Effective questions, Simulation, Seminar presentation, Giving tasks, Performing practical

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


 

To make students familiar with the basics of database management system.

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

  • ER-Diagrams
  • Relational Algebra
  • SQL
Academic Year: 
2020-21
  • Printer-friendly version