DATABASE MANAGEMENT SYSTEMS

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

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

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: 
2019-20
  • Printer-friendly version