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 strategies

Assessment 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 practical

Class   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:

  1. https://spoken-tutorial.org/
  2. https://www.slideshare.net/
  3. https://pll.harvard.edu/subject/computre-science
  4. https://onlinecourses.nptel.ac.in

 

 

Academic Year: 
2022-23
  • Printer-friendly version