DATABASE MANAGEMENT SYSTEMS

Paper Code: 
24MCA122
Credits: 
04
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 122

Database Management Systems

(Theory)

  1. Identify Data models and schemas used in database management systems.
  2. Construct Entity-Relationship diagrams to represent simple database application scenarios
  3. Analyse Relational Algebra, Calculus and RDBMS Keys.
  4. Interpret and identify the use of database design theory, and evaluate normal forms and functional dependencies in DBMS.
  1. Explain and write SQL commands to create tables and indexes, insert/update/delete data, and querydata in a relational DBMS and  Build effective solutions for database handling.
  2. Contribute effectively in course-specific interaction

Approach in teaching:

Interactive Lectures, Discussion, Tutorials, Reading assignments, Demonstration, Team teaching

 

Learning activities for the students:

Self-learning assignments, Effective questions, Simulation, Seminar presentation, Giving tasks, Field practical

  • Assignment
  • Written test in classroom
  • Classroom activity
  • Multiple choice questions
  • Continuous Assessment
  • Semester End Examination



 

 

10.00
Unit I: 
Introduction:

 Overview of DBMS, Advantages of DBMS, Basic DBMS terminology, Database System v/s File System, Data Independence, Architecture of DBMS, Introduction to data models: Relational Model, Network Model, Hierarchical Model, Entity-Relationship Model, Comparison of network, hierarchical and relational models.

12.00
Unit II: 
Data modeling using the Entity Relationship Model:

 ER model concepts, Types of Relationships, notation for ER diagram, Reduction of ER-Diagrams to Relational Model, mapping constraints, Generalization, Aggregation, Specialization, Extended ER model, relationships of higher degree.

10.00
Unit III: 
Relational model:

Relational Algebra, Set Operations, Relational Calculus, Concepts of Primary key, Foreign key, Alternate key, Candidate key, Integrity Rules, Data Dictionary.

Normalization: Functional dependencies, normal forms, first, second, third normal forms, BCNF, inclusion dependencies, loss less join decompositions, normalization using FD, MVD, and JDs, alternative approaches to database design.

10.00
Unit IV: 
Transaction And Concurrency control:

Transaction Concepts, ACID Properties, States Of Transaction, Serializibility, Conflict & View Serializable Schedule, Recovery From Transaction Failures, Checkpoints, Deadlock Handling.

Concurrency Control: Concept, Locks Based Protocols, Time Stamp Based Protocols, Validation Based Protocol, Multiple Granularity, Multi-version Schemes.

 

16.00
Unit V: 
Introduction to SQL:

Characteristics of SQL, Advantages of SQL, SQL data types and literals, Types of SQL commands: DDL, DML, TCL, DCL, SQL operators, Tables, Views and Indexes, Constraints, Group By and Having Clause, Order By Clause, Queries and sub queries, Aggregate Functions, Numeric Functions, String Functions, Date & Time Functions, Insert, Update and Delete operations, Unions, Intersection, Minus, Joins: Equi-Join, Natural Join, Self Join, Inner Join, Outer Join.

 

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
  4. Bipin C. Desai, “An Introduction to Database Systems”, Galgotia Publication, Revised Edition, 2010
  5. Majumdar & Bhattacharya, “Database Management System”, TMH, 2005.
  6. Paul Beynon Davies, “Database Systems”, Palgrave Macmillan, 3rd Edition, 2003.

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/OEYweXpIRmlkYURkM3JkbUdtKy9UWmdVNEMreENBMmpNMk1GbFNoejlm   Zjk1SklyVk50eWZ5UUFZek1zaHpRbEhVc1d0ZzdaTnM4bjlQbHNvaEpRdGc9PQ

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:[]}}

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