DATABASE MANAGEMENT SYSTEMS

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

Course Objectives:

The course will enable the students to know about the fundamental concepts of database designing including the process of creating ER diagrams to normalization.

 

Course Outcomes: 

Course

Learning outcome

(at course level)

Learning and teaching strategies

Assessment Strategies

Course Code

Course

title

 

24CCAI 401

 

DATABASE MANAGEMENT SYSTEMS

(Theory)

CO37. Analyse and evaluate advanced database and data mining concepts through theoretical and practical application.

CO38. Create ER diagram and transform them into database using relational algebra.

CO39. Apply relational database design principles to normalize and optimize database structures using My SQL

CO40. Apply Structured Query Language (SQL) for database definition and database manipulation.

CO41. Create database for any application using DDL, DML commands and constraints.

CO42. Contribute effectively in course-specific interaction

 

Approach in teaching:

Interactive Lectures, Discussion, PowerPoint Presentations, Informative videos

 

Learning activities for the students: 

Self-learning assignments, Effective questions, presentations.

 

 

 

Assessment tasks will include Class Test on the topics, Semester end examinations, Quiz, Student presentations and assignments.

 

12.00
Unit I: 
Introduction:

Database definition, History of Database Systems, Database System Applications, Database Systems versus conventional File Systems, View of Data, Data Abstraction, Data Independence.

Introduction to Data Models (Network, Hierarchical, Relational), Database Languages, Database Users and Administrators, Database Design, Data Storage and Querying, Data Mining and Information Retrieval, Specialty Databases, History of Database Systems.

 

12.00
Unit II: 
Entity-Relationship Model:

E-R diagram, Constraints, Keys (Candidate key, Alternate key, Primary Key, Foreign Keys), Weak Entity Sets.

Relational Algebra: Basics of relational algebra (Select, Project, Union, Set Difference, Cartesian-Product, Natural join)

 

12.00
Unit III: 
Relational-Database Design:

Normalization, Functional Dependencies, Normalized forms [1NF, 2NF, 3NF].

Relational Database Management Systems: Brief history of MySQL, Key Features, MySQL server and Clients, MySQL and SQL, Classification of SQL statements, Some MySQL SQL elements (Literals, Data Types, Null values, comments), SQL command syntax.

 

12.00
Unit IV: 
Databases in MySQL:

Create, Open, Remove, Creating Tables: Create Command. Viewing structure of table using DESC command.

Changing data with DML commands: INSERT INTO command, inserting values through substitution, inserting NULL values, inserting dates, inserting data from other tables.

Selec Statement, using WHERE clause.

Operators: Relational operators, Logical operators. Condition based on a range, list, pattern match.

Searching and Sorting: Searching for NULL (IS NULL), Sorting results (ORDER BY Clause), Sorting by Column Alias. Grouping result – Group by command, Having Clause. Eliminating redundant data with Distinct keyword.

 

12.00
Unit V: 
MySQL Functions and Grouping:

Types of MySQL Functions (String, Numeric, Date/Time).

Changing data with DML commands: Modifying data with update command, Deleting data with delete command. DDL commands: ALTER TABLE command, adding columns, modifying data- type and size of a column, DROP TABLE.

Managing Constraints: Creating constraints, Unique, Primary Key, Default, Check and Foreign Key, table constraints, dropping constraints, enabling and disabling constraints, deferring constraints checks.

 

ESSENTIAL READINGS: 

Suggested Text Books:

  1. A. Silberschatz & H. F. Korth, “Database System Concepts”, Seventh edition, McGraw Hill, 2021.
  2. A. Leon & Leon, “SQL”, Tata McGraw Hill.

 

REFERENCES: 

Suggested Reference Books:

  1. R. Ramakrishnan and J. Gharke, “Database Management System”, Tata McGraw Hill.
  2. C. J. Date, “Database Management System”, Pearson Education Asia.
  3. Sumita Arora,“Informatics Practices”, Dhanpat Rai & Co.

Reference 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-
  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

 

e-Resources including links

 

  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. DatabaseManagementSystem, http://ndl.iitkgp.ac.in/document/OEYweXpIRmlkYURkM3JkbUdtKy9UWmdVNEMreENBMmpNMk1GbFNoejlmZjk1SklyVk50eWZ5UUFZek1zaHpRbEhVc1d0ZzdaTnM4bjlQbHNvaEpRdGc9PQ
  4. Cloud Computing A practical approach for learning and implementation, A. Srinivasan, J. Suresh, Pearson

 


{C}   

Academic Year: 
2024-25
  • Printer-friendly version