DATABASE MANAGEMENT SYSTEMS (Generic Elective Course)

Paper Code: 
GCAI 402
Credits: 
4
Max. Marks: 
100.00
Objective: 

Objective: This module is designed to help students to know about the fundamental concepts of database management and Structured Query Language.

 

Course Learning Outcome

Learning and Teaching Strategies

Assessment Strategies-

The Students will:

  1. Understand the fundamental concepts of a database system and its types.
  2. Analyze database requirements,         identify the entities involved in the system and determine their relationship to one another.
  3. Develop the logical design of the database using data modeling concepts and deduce into relational schema.
  4. Learn and apply Structured Query Language (SQL) for database definition  and database manipulation.
  5. Create a 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-Database Design: Normalization, Functional Dependencies, Normalized forms [1NF, 2NF, 3NF]

 

 

9.00
Unit III: 

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

Select 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: 

Suggested Text Books:

  • A. Silberschatz & H. F. Korth, “Database System Concepts”, Seventh edition, McGraw Hill International Edition, 2019.
  • A. Leon & Leon, “SQL”, Tata McGraw Hill, 2001.

Suggested Reference Books:

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

 

 

REFERENCES: 

Reference Journals

E-Resources including links

Academic Year: 
2023-24
  • Printer-friendly version