Semester - III

Module

Contents

No. of Hours

I

INTRODUCTION: Purpose of Database System - View of Data - Database Languages - Relational Databases – Database Design – Data Storage and Querying - Transaction Management – Database Architecture –Database Users and Administrators.

RELATIONAL DATABASES: Structure of Relational Databases – Database Schema – Keys – Relational Query Languages – Relational Operations.

9

II

DATABASE DESIGN AND THE E-R MODEL: The Entity - Relationship Model – Constraints – Entity-Relationship Diagrams.

RELATIONAL DATABASE DESIGN: Normalization – Decomposition Using Functional Dependencies.

INTERACTIVE SQL: Invoking SQL * plus- Data manipulation in Database Management Systems – Oracle Data Types – Two Dimension Matrix Creation- Insertion of data into tables- Updating the contents of a table – Deletion operations.

10

III

SQL : Many faces of the Select command- Modifying the structure of the table – Removing/Deleting/Dropping tables – Data constraints - Computations in expression lists used to select data - Logical operations – Range searching – Pattern matching – Oracle functions – Grouping data from tables in SQL – Manipulating dates in SQL.

10

IV

DATA MANIPULATION: Joins – Sub queries. Indexes – Views – Sequences- Granting permissions- Revoking the permissions given – Creation of reports in SQL* plus.

PL/SQL: Introduction – Execution – PL/SQL syntax, Oracle transaction locks – Cursors.

9

V

STORED PROCEDURES: Introduction - Creating Stored Procedures – An application using a Procedure - Deleting a Stored Procedures- Difference between stored Procedures and stored functions.

DATABASE TRIGGERS: Types of Triggers – Creating Triggers – Deleting Triggers.

10

Total Hours

48

References

Text Books:

1. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System Concepts”, Seventh Edition, Tata McGraw Hill, 2017 (Unit I, II).

2. Ivan Bayross, “Commercial Application Development Using ORACLE Developer 2000”, BPB Publication, New Delhi, 2007 (Unit III - V).

Reference Books:

1. Ramez Elmasri, Shamkant B.Navathe, “Fundamentals of Database Systems”, Pearson Education Asia, Seventh Edition, Reprint 2017.

2. Nilesh Shah, “Database Systems Using Oracle”, PHI Learning Private Limited, New Delhi, 2014.

Online Resources:

1.https://www.javatpoint.com/database-design

2. https://www.w3schools.com/database-design