DBMS LAB

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

This course enables the students to

  1. Apply the query for the modification of the system.
  2. Formulate a conceptual design which allows to avoid anomalies in superior’s data.
  3. Review a system which allows restricting the uncontrolled exaction and providing rigorous variation of the task.
  4. Evaluate the viability of Conceptual Design

Course Outcomes(COs):

Learning Outcome (at course level)

 

Learning and teaching strategies

Assessment Strategies

CO36.Apply query processing tasks in relational query languages. 

CO37.Design databases using concepts of functional dependencies and normal forms 

CO38.Formulate the operations of transaction and concurrent query processing tasks to obtain the correct results even under strict time constraints. 

CO39.Detect the       foundational concepts of distributed databases. 

CO40.Prepare 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

 

Academic Year: 
2021-22
  • Printer-friendly version