DBMS FULL(1-8) MATERIALS IN PPT's FORM,DOWNLOAD THESE by Following the below links

UNIT-I
http://www.ziddu.com/download/13803383/UNIT01-DBMS.ppt.html

UNIT-II

http://www.ziddu.com/download/13803400/UNIT02-DBMS.ppt.html

 UNIT-III

http://www.ziddu.com/download/13803414/UNIT03-DBMS.ppt.html

UNIT-IV 
http://www.ziddu.com/download/13803463/UNIT04-DBMS-1.ppt.html 


UNIT-V
http://www.ziddu.com/download/13803462/UNIT05-DBMS.ppt.html
 
UNIT-VI


http://www.ziddu.com/download/13803461/UNIT06-DBMS.ppt.html

UNIT-VII



http://www.ziddu.com/download/13803503/UNIT07-DBMS.ppt.html

UNIT-VIII


http://www.ziddu.com/download/13803502/UNIT08-DBMS.ppt.html

DBMS-THEORY SYLLABUS

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY

KAKINADA

II Year B.Tech. CSE -II Sem                                                                                                                                              T      P    C

                                                                                                                                            4+1*   0    4

                           DATA BASE MANAGEMENT SYSTEMS

UNIT I :

Data base System Applications, data base System VS file System – View of Data – Data Abstraction –

Instances and Schemas – data Models – the ER Model – Relational Model – Other Models – Database

Languages – DDL – DML – database Access for applications Programs – data base Users and

Administrator – Transaction Management – data base System Structure – Storage Manager – the Query

Processor

UNIT II :

History of Data base Systems. Data base design and ER diagrams – Beyond ER Design Entities,

Attributes and Entity sets – Relationships and Relationship sets – Additional features of ER Model –

Concept Design with the ER Model – Conceptual Design for Large enterprises.

UNIT III :

Introduction to the Relational Model – Integrity Constraint Over relations – Enforcing Integrity constraints –

Querying relational data – Logical data base Design – Introduction to Views – Destroying /altering Tables

and Views.

Relational Algebra – Selection and projection set operations – renaming – Joins – Division – Examples of

Algebra overviews – Relational calculus – Tuple relational Calculus – Domain relational calculus –

Expressive Power of Algebra and calculus.

UNIT IV :

Form of Basic SQL Query – Examples of Basic SQL Queries – Introduction to Nested Queries –

Correlated Nested Queries Set – Comparison Operators – Aggregative Operators – NULL values –

Comparison using Null values – Logical connectivity’s – AND, OR and NOT – Impact on SQL Constructs –

Outer Joins – Disallowing NULL values – Complex Integrity Constraints in SQL Triggers and Active Data

bases.

UNIT V :

Schema refinement – Problems Caused by redundancy – Decompositions – Problem related to

decomposition – reasoning about FDS – FIRST, SECOND, THIRD Normal forms – BCNF – Lossless join

Decomposition – Dependency preserving Decomposition – Schema refinement in Data base Design –

Multi valued Dependencies – FORTH Normal Form.

UNIT VI :

Transaction Concept- Transaction State- Implementation of Atomicity and Durability – Concurrent –

Executions – Serializability- Recoverability – Implementation of Isolation – Testing for serializability- Lock

–Based Protocols – Timestamp Based Protocols- Validation- Based Protocols – Multiple Granularity.

UNIT VII :

Recovery and Atomicity – Log – Based Recovery – Recovery with Concurrent Transactions – Buffer

Management – Failure with loss of nonvolatile storage-Advance Recovery systems- Remote Backup

systems.

UNIT VIII :

Data on External Storage – File Organization and Indexing – Cluster Indexes, Primary and Secondary

Indexes – Index data Structures – Hash Based Indexing – Tree base Indexing – Comparison of File

Organizations – Indexes and Performance Tuning- Intuitions for tree Indexes – Indexed Sequential

Access Methods (ISAM) – B+ Trees: A Dynamic Index Structure.

TEXT BOOKS :

1. Data base Management Systems, Raghurama Krishnan, Johannes Gehrke, TATA McGrawHill 3rd

Edition

2. Data base System Concepts, Silberschatz, Korth, McGraw hill, V edition.

REFERENCES :

1. Data base Systems design, Implementation, and Management, Peter Rob & Carlos Coronel 7th Edition.

2. Fundamentals of Database Systems, Elmasri Navrate Pearson Education

3. Introduction to Database Systems, C.J.Date Pearson Education

To download a copy,Follow the below link:
http://www.ziddu.com/download/13802292/dbms_theory.docx.html

DBMS-LAB SYLLABUS

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY

KAKINADA

II Year B.Tech. CSE -II Sem               T P C

                                                 0 3 2

DATA BASE MANAGEMENT SYSTEMS LAB

Objectives:

· To teach the student database design and query and PL/SQL.

Recommended Systems/Software Requirements:

· Intel based desktop PC

· Mysql /Oracle latest version Recommended

1) Creation, altering and droping of tables and inserting rows into a table (use constraints while

creating tables) examples using SELECT command.

2) Queries (along with sub Queries) using ANY, ALL, IN, EXISTS, NOTEXISTS, UNION,

INTERSET, Constraints.

Example:- Select the roll number and name of the student who secured fourth rank in the class.

3) Queries using Aggregate functions (COUNT, SUM, AVG, MAX and MIN), GROUP BY, HAVING

and Creation and dropping of Views.

4) Queries using Conversion functions (to_char, to_number and to_date), string functions

(Concatenation, lpad, rpad, ltrim, rtrim, lower, upper, initcap, length, substr and instr), date

functions (Sysdate, next_day, add_months, last_day, months_between, least, greatest, trunc,

round, to_char, to_date)

5) i)Creation of simple PL/SQL program which includes declaration section, executable section and

exception –Handling section (Ex. Student marks can be selected from the table and printed for

those who secured first class and an exception can be raised if no records were found)

ii)Insert data into student table and use COMMIT, ROLLBACK and SAVEPOINT in PL/SQL

block.

6) Develop a program that includes the features NESTED IF, CASE and CASE expression. The

program can be extended using the NULLIF and COALESCE functions.

7) Program development using WHILE LOOPS, numeric FOR LOOPS, nested loops using ERROR

Handling, BUILT –IN Exceptions, USE defined Exceptions, RAISE- APPLICATION ERROR.

8) Programs development using creation of procedures, passing parameters IN and OUT of

PROCEDURES.

9) Program development using creation of stored functions, invoke functions in SQL Statements

and write complex functions.

10) Program development using creation of package specification, package bodies, private objects,

package variables and cursors and calling stored packages.

11) Develop programs using features parameters in a CURSOR, FOR UPDATE CURSOR, WHERE

CURRENT of clause and CURSOR variables.

12) Develop Programs using BEFORE and AFTER Triggers, Row and Statement Triggers and

INSTEAD OF Triggers

If you want a copy , Follow the below link:
http://www.ziddu.com/download/13802288/dbms_lab.docx.html