DATABASE MANAGEMENT SYSTEM

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

This Course enables the students to

  1. Demonstrate the relations between Data elements.
  2. Test the applicability of queries to extract the data.
  3. Select appropriate methods to extract the right data as may be required by the user.
  4. Design codes for apt storage, retrieval and representations of data from databases.

Course Outcomes(COs):

 

Learning Outcome (at course level)

 

Learning and teaching strategies

Assessment Strategies

CO13.Compare various data models and schemas used in database management systems.

CO14.Use the fundamental concepts, data definitions and query processing tasks in relational query languages.

CO15.Analyze functional dependencies and normal forms in databases.

CO16.Evaluate the operations of transaction and concurrent query processing tasks to obtain correct results. 

CO17.Design and build a simple database system and demonstrate competence with the fundamental tasks involved with modeling, designing, and implementing a DBMS.

 

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.

10.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.

Transactions: Transaction Concept, State, ACID properties, basic understanding of Concurrency & Recovery.

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, 7th Edition, 2016.
  • 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, 6th Edition, 2014.
  • 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: 
2021-22
  • Printer-friendly version