DATABASE MANAGEMENT SYSTEMS

Paper Code: 
CAI 501
Credits: 
03
Periods/week: 
03
Max. Marks: 
100.00
Objective: 
The course will enable the students to
 
  • Get knowledge about the fundamentals of database management. 
  • Understand core concepts for managing databases.
Course Learning OutcomeLearning and Teaching StrategiesAssessment Strategies-
Students will be able to:
 
 CO48. Understand the fundamental concepts of a database system  
 

 CO49. Analyze database requirements and determine the entities involved in the system, model ER diagrams

 CO50. Map ER diagrams Concepts to Relations

 CO51. Manipulate a database using SQL.

CO52. 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: 
2020-21
  • Printer-friendly version