Introduction: purpose of the database system -view of data - data models - database languages - transaction management - storage management - database administrator - database users. Entity-Relationship models: basic concepts design issues mapping constraints keys E-R diagram weak entity sets Extended E-R features.
Relational Model: Structure of relational databases the relational algebra - the tuple relational calculus - the domain relational calculus. Relational Database Design: Pitfalls in relational-database design decomposition normalization using fundamental dependencies - Distributed Databases: distribution transaction model commit protocols concurrency control.
Oracle Tables: DDL: Naming Rules and conventions Data Types Constraints Creating Oracle Table Displaying Table Information Altering an Existing Table Dropping, Renaming, Truncating Table Table Types Spooling Error codes.
Working with Table: Data Management and Retrieval: DML adding a new Row/Record Customized Prompts Updating and Deleting an Existing Rows/Records retrieving Data from Table Arithmetic Operations restricting Data with WHERE clause Sorting Revisiting Substitution Variables DEFINE command CASE structure. Functions and Grouping: Built-in functions Grouping Data. Multiple Tables: Joins and Set operations: Join Set operations.
PL/SQL: A Programming Language: History Fundamentals Block Structure Comments Data Types Other Data Types Declaration Assignment operation Bind variables Substitution Variables Printing Arithmetic Operators. Control Structures and Embedded SQL: Control Structures Nested Blocks SQL in PL/SQL Data Manipulation Transaction Control statements. PL/SQL Composite Data Types: Records Tables Varrays.
Reference Book:
Rajesh Narang, “Database Management Systems, PHI, 2006. 2. Gerald V.Post, Database Management Systems, Tata McGraw-Hill, Sixth Reprint, 2008
Text Book:
. Henry F.Korth, Abraham Silberschatz & S. Sudarshan, Database System Concepts, Tata McGraw-Hill, 2010. (Unit-I, II) 2. Nilesh Shah, Database Systems Using Oracle”, 2nd edition, PHI, 2008(Unit-III, IV, V)