DBMS-I LAB

Paper Code: 
CBCA 306
Credits: 
3
Periods/week: 
3
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):

Course Outcome (at course level)Learning and teaching strategiesAssessment Strategies
The students will:
CO123. Design the structure of databases and tables
CO124.   Create entity relationship diagrams for modelling logical schema
CO125.   Implement the basic relational algebra concepts
CO126. Create and manipulate data through SQL
CO127.   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 practicalClass test, Semester end examinations, Quiz, Solving problems in tutorials, Assignments, Presentation, Individual and group projects

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

 

  • ER-Diagrams
  • Relational Algebra
  • SQL
REFERENCES: 
E-Resources:
 
https://www.slideshare.net/
https://pll.harvard.edu/subject/computer-science
https://onlinecourses.nptel.ac.in/
 
Academic Year: