DBMS LAB

Paper Code: 
24MCA127
Credits: 
02
Periods/week: 
04
Max. Marks: 
100.00
Objective: 

 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: 

Course

Learning Outcome (at course level)

 

Learning and teaching strategies

Assessment Strategies

Course Code

Course

Title

24MCA 127

 

DBMS LAB

(Practical)

  1. Analyse various data models and schemas used in database management systems.
  2. Design real database and apply SQL statements to solve a problem.
  3. Describe the principles of SQL programming, ability to create and store information as a database 
  4. Capability of maintaining and modifying SQL databases commands.
  5. Apply SQL to find solutions to a broad range of queries.
  6. Contribute effectively in course-specific interaction

Approach in teaching:

Interactive Lectures, Discussion, Tutorials, Demonstration

 

Learning activities for the students:

Self-learning assignments, Effective questions, Quizzes, Presentations, Discussions

 

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

 

Unit I: 

 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

Unit II: 

                                                                                                                                           

Unit III: 
Unit IV: 
Unit V: 

            

ESSENTIAL READINGS: 

 

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


 

REFERENCES: 

Suggested Readings:

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

e-Resources:

1. Database Management System, Prof. Partha Pratim Das, NPTEL/ SWAYAM/ SWAYAMPRABHA, https://swayamprabha.gov.in/index.php/program_data/flipMore/R10/13                                                                                             2. Database Management System, Prof. S. Srinath, https://swayamprabha.gov.in/index.php/search                                                                                       3.Databases and Database Management Systems, Science SuperCourse, NDLI, http://ndl.iitkgp.ac.in/document OEYweXpIRmlkYURkM3JkbUdtKy9UWmdVNEMreENBMmpNMk1GbFNoej       lmZjk1SklyVk50eWZ5UUFZek1zaHpRbEhVc1d0ZzdaTnM4bjlQbHNvaEpRdGc9PQ  4.Database Management System, e-Gyankosh (Videos), NDLI,  https://ndl.iitkgp.ac.in/result?q={%22t%22:%22search%22,%22k%22:%22DATABASE%20MANAGEMENT%20SYSTEM%22,%22s%22:[%22type=\%22video\%22%22],%22b%22:{%22filters%22:[]}}                                5.Introduction to SQL, Science Supercourse, NDLI, http://ndl.iitkgp.ac.in/document OEYweXpIRmlkYURkM3JkbUdtKy9UVmN3dW9QYTNzb1lmWEdvTzd   OTTNIS1RCSE1BVmhOVHBSMVJydk9qQlFHRG1qaklXYnhyYjNyekNMWVlITWozalE9PQ

Journals:                                                                                                                                                   1. International Journal of Intelligent Information and Database Systems (Journal also publishes Open Access Articles), Inderscience Publishers, https://www.inderscience.com/jhome.php?jcode=ijiids.                                         2.Database Management Systems, Elsevier, https://www.elsevier.com/books/database-management-systems/gorman/978-0-7506-0135-1.                  3.International Journal of Database Management Systems (Open Acess), airccse, https://airccse.org/journal/ijdms/index.html.                                                     4.Journal of Database Management, IGI Global, https://www.igi-global.com/journal/journal-database-management-jdm/1072.

 

Academic Year: 
2024-25
  • Printer-friendly version