DBMS-I LAB

Paper Code: 
24CBCA306
Credits: 
02
Periods/week: 
04
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: 

 

Course

Learning Outcome

(at course          level)

Learning and teaching strategies

Assessment Strategies

Course

 Code

Course

Title

24CBCA

306

DBMS-I LAB

(Practical)

CO157.Design the structure of databases and tables

CO158.  Create entity-

relationship diagrams for modelling logical schema

CO159.  Implement  the basic   relational algebra concepts

CO160.Create and manipulate data through SQL

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

CO162.Contribute effectively in course-  specific interaction.

Approach in teaching: 

Interactive Lectures,

Discussion,

Demonstration,

 

Learning activities for the students: 

Self-learning assignments, Practical questions

Class test, Semester end examinations, Quiz, Presentation,

Individual and group

Assignments

 

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

  • ER-Diagrams
  • Relational Algebra
  • SQL

 

REFERENCES: 

e -RESOURCES:

1. https://www.slideshare.net/

2. https://pll.harvard.edu/subject/computer-science

3. https://onlinecourses.nptel.ac.in/

 

Academic Year: 
2024-25
  • Printer-friendly version