DBMS-I LAB

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

Course

Learning Outcome

(at course  level)

Learning and

teaching

strategies

Assessment

Strategies

Course

Code

Course

Title

5CBCA306

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

 

Unit I: 

This c o u r s e  will be based on theory 2 5 C BCA305. Exercises given will be covering entiresyllabi 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: