DATABASE MANAGEMENT SYSTEMS

Paper Code: 
CAI 501
Credits: 
03
Periods/week: 
03
Max. Marks: 
100.00
Objective: 

The course will enable the students to:

 

This module is designed to help students to know about the fundamental concepts of database management. 

Course Learning Outcome

Learning and Teaching Strategies

Assessment Strategies-

Students will :

 

CO61. Understand the fundamental concepts of a database system
CO62. Analyze database requirements and determine the entities involved in the system, model ER diagrams
CO63. Map ER diagrams Concepts to Relations
CO64. Manipulate a database using SQL.
CO65. Apply normalization concepts in database design

 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.

 

 

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

 

8.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]

 

11.00
Unit III: 

Relational-Database Design: Normalization, Functional Dependencies, Normalized forms [1NF, 2NF, 3NF].

ORACLE: Introduction, Oracle Server and Oracle Database, Two and Three-tier architecture, Login Screen, Entering Name and Password.

 

 

 

10.00
Unit IV: 

Data Types, Null values, comments, SQL command syntax.

SQL SELECT Statement: Selecting All the Columns, Reordering columns in Query Results, Selecting Specific Column, Duplicate rows and their elimination (DISTINCT keyword).SQL: Displaying Table Structure (DESC command), Limiting Rows during selection (using WHERE clause), concatenating strings.

Operators: Relational operators, Logical operators. Condition based on a range (BETWEEN Operator), Condition based on a list (IN Operator), Condition based on pattern match (LIKE Operator). Searching and Sorting: Searching for NULL (IS NULL), Sorting results (ORDER BY Clause). Making simple queries based on these operations.

8.00
Unit V: 

SQL Functions and Grouping: Types of SQL Function (Single Row/Multiple Row).

Character Functions - Case Conversion, Character Manipulation.

Numeric Functions, Date Functions.

Grouping result – Group By command, placing conditions on groups – Having Clause. Simple Queries based on these operations.

 

 

ESSENTIAL READINGS: 
  1. A. Silberschatz & H. F. Korth, “Database System Concepts”, Fourth edition, McGraw Hill International Edition, 2002.
  2. A. Leon & Leon, “SQL”, Tata McGraw Hill.

 

REFERENCES: 

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.

 

Academic Year: 
2021-22
  • Printer-friendly version