Database Management System

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

 The course will enable 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 to restrict the uncontrolled exaction and provide rigorous variation of the task.

 

  Course Learning Outcomes (CLOs):

 

Learning Outcome (at course level)

Students will be able to:

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.
  6. Illustrate several techniques related to transaction management and query processing in distributed database management systems.

Approach in teaching:

Interactive Lectures, Tutorials, Demonstrations, Flipped classes.

 

Learning activities for the students:

Self-learning assignments, Quizzes, Presentations, Discussions

  • Assignments
  • Written tests in classroom
  • Classroom Activity
  • Objective Quiz

Semester End Exam

 

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: Storage Organizations for Relations, Relational Algebra, Set Operations, Relational Calculus, Concepts of Alternate key, candidate key, primary key, Foreign key, Integrity Rules, Data Dictionary.

12.00
Unit IV: 

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.

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: 
  • Elmasri, Navathe, “Fundamentals of Database Systems”, Addison Wesley, 6th Edition, 2011..
  • Korth, Silberschatz, Sudarshan, “Database Concepts”, McGraw Hill, 6th Edition, 2010.
REFERENCES: 
  • Thomas Connolly and Carolyn Begg, “Database Systems: A Practical Approach to Design, Implementation, and Management, Addison Wesley , 5th Edition, 2010
  • Ramakrishnan, Gehrke, “Database Management System”, McGraw Hill, 3rd Edition, Jan 2007
  • Date C J, “An Introduction to Database System”, Addision Wesley, 8th Edition 2003
  • Bipin C. Desai, “An Introduction to Database Systems”, Galgotia Publication, Revised Edition, 2010
  • Majumdar& Bhattacharya, “Database Management System”, TMH, 2005
  • Paul Beynon Davies, “Database Systems”, Palgrave Macmillan, 3rd Edition, 2003
Academic Year: 
2019-20
  • Printer-friendly version