11-07-2015, 10:08 AM
5th sem cse aradhya tutorials notes download
UNIT - I
Basic concepts: database & database users, characteristics of the database, database systems,
concepts and architecture, date models, schemas & instances, DBMS architecture & data
independence, database languages & interfaces, data modeling using the entity-relationship
approach. Overview of hierarchical, Network & Relational Data Base Management Systems.
UNIT - II
Relational model, languages & systems: relational data model & relational algebra: relational
model concepts, relational model constraints, relational algebra, SQL- a relational database
language: date definition in SQL, view and queries in SQL, specifying constraints and indexes in
sql.
UNIT - III
Oracle Architecture, Logical Data Structures Physical Data Structure, Instances, Table Spaces,
Types of Tablespaces, Internal Memory Structure, Background Processes, Data Types, Roles &
Privileges, Stored Procedures, User Defined Functions, Cursors, Error Handling, Triggers.
UNIT - IV
Relational data base design: function dependencies & normalization for relational databases:
functional dependencies, normal forms based on primary keys, (1NF, 2NF, 3NF & BCNF),
lossless join and dependency preserving decomposition. Concurrency control & recovery
techniques: concurrency control techniques, locking techniques, time stamp ordering, granularity
of data items, recovery techniques: recovery concepts, database backup and recovery from
catastrophic failures. Concepts of object oriented database management systems, Distributed Data
Base Management Systems.
TEXT BOOKS:
1. Elmsari and Navathe, "Fundamentals of Database Systems", Pearson Education, 5th Ed.,
2006.
2. Korth, Silberschatz, "Fundamentals of Database System Concepts", TMH, 6th Ed., 2010.
3. Desai, B., "An Introduction to Database Concepts", Galgotia.
4. Sham Tickoo and Sunil Raina, "Oracle 11g with PL/SQL Approach", Pearson, 2010.
REFERENCE:
1. Date C. J., "An Introduction to Database Systems", Narosa Publishing, 7th Ed., 2005.
2. S. K. Singh, "Database Systems: Concept, Design, and Applications", Pearson's
Education, 1st Ed., 2008.
3. Kiffer, "Database Systems: An Application oriented Approach", Pearson.
4. Ullman J. D., "Principals of database systems", Galgotia .
5. Shio Kumar Singh, "Databases Systems Concepts, Design and Applications," Pearson,
2006.