DATABASE MANAGEMENT SYSTEMS

Paper Code: 
CCAI 401
Credits: 
03
Periods/week: 
03
Max. Marks: 
100.00
Objective: 

This course is designed to help students to know about the fundamental concepts of database designing including the process of creating ER diagrams to normalization.

 

Learning Outcome

Learning and Teaching Strategies

Assessment Strategies-

 

The Students will:

CO31. Comprehend the fundamental concepts of a database system and its types.

CO32. analyse  database requirements,    identify the entities involved in the system and determine their relationship to one another.

CO33. Develop the logical design of the database using data modeling concepts and deduce into relational schema.

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

CO35. Create database for any application using normalization principles.

Approach in teaching:

Interactive Lectures, Discussions, student centered approach, Through video Tutorials 

Learning activities:

Presentations, Quizzes and Assignments

 

Class test, Semester end examinations, Quiz, Solving problems in tutorials,

Assignments, Presentation, Individual and group projects and peer review.

 

 

 

 

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

 

9.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)

 

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

 

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

 

9.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: 
  • A. Silberschatz & H. F. Korth, “Database System Concepts”, Seventh edition, McGraw Hill, 2021.
  • A. Leon & Leon, “SQL”, Tata McGraw Hill.

 

REFERENCES: 

Suggested Reference Books

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

 Reference Journals

 E-Resources including links:

Academic Year: 
2023-24
  • Printer-friendly version