DBMS LAB

Paper Code: 
MCA 127
Credits: 
02
Periods/week: 
04
Max. Marks: 
100.00
Objective: 

Course Objectives

This course enables the students to

  1. Observe that how the real world data is stored, retrieved, and communicate under the DBMS environment
  2. Design a logical model which having the unique relation between the Data.
  3. Apply the query for the modification of the system.
  4. Develop a conceptual design which allows as to avoid anomalies in superior’s data.
  5. Discuss a system which allows restricting the uncontrolled exaction and providing rigorous variation of the task.

 

Course Outcomes(COs):

 

Learning Outcome (at course level)

 

Learning and teaching strategies

Assessment Strategies

  1. Describe various data models and schemas used in database management systems.
  2. Explain the fundamental concepts, data definitions and query processing tasks in relational query languages.
  3. Recognize database design theory, and evaluate functional dependencies and normal forms in databases.
  4. Formulate the operations of transaction and concurrent query processing tasks to obtain the correct results even under strict time constraints.
  5. Interpret the foundational concepts of distributed databases. Illustrate several techniques related to transaction management and query processing in distributed database management systems.

Approach in teaching:

Demonstrations, implementing enquiry based learning, Application based examples

 

Learning activities for the students:

Discussions, Lab Assignments, Exercises based on real world problems.

 

  • Practical Exam
  • Practical Record
  • Viva Voce
  • Semester End Practical Exam
 

Contents

1. SQL data types, Operators, Literals, Constraints

2. DDL Commands: Create Tables/Create Synonym /Create index /Views / Alter /                         Drop/Truncate/Comment/Rename/DBCC (Database Console Commands)

3.DML Commands:  Insert / Update / Delete / Merge/Lock Table

4.TCL Commands: Commit / Rollback / Save-Points /Set Transaction

5. DCL Commands: Grant / Revoke/Deny

6. Simple Queries: Select / From / Where 

7. Group By/Having Clause

8. Order By clause

9. SQL Operators: Arithmetic / Logical /In / Like / Between

10. Functions: Aggregate / Numeric / String / Date & Time / Logical

11. Joins: Equi-Join / Natural Join / Self Join / Inner Join / Outer Join

12. Unions / Intersection / Minus 

13. Subqueries or Nested Queries

ESSENTIAL READINGS: 

 

  • Elmasri, Navathe, “Fundamentals of Database Systems”, Addison Wesley, 7th Edition, 2017.
  • Korth, Silberschatz, Sudarshan, “Database System Concepts”, McGraw Hill, 7th Edition, 2021.

 

Suggested Readings:

  • Thomas Connolly and Carolyn Begg, “Database Systems: A Practical Approach to Design, Implementation, and Management, Addison Wesley, 6th Edition, 2015.
  • Ramakrishnan, Gehrke, “Database Management System”, McGraw Hill, 3rd Edition, Jan 2014.
  • Date C J, “An Introduction to Database System”, Addision Wesley, 8th Edition 2006.

 

REFERENCES: 

 

 

Academic Year: 
2023-24
  • Printer-friendly version