Database management System Teacher Coaching Tuition Tutor Tutoring Tutors Tution Online Tutor Online Tutoring Private Teacher Private Tuition Tutions Private Tutor Tuitions Tutoring Services Tutoring Service Home Tutor Tuition Teacher Private Tutoring Ho

Online | Offline Tuitions for Database management System

Visit http://www.learninggeeks.info for Registration.

Call us @ 9718322472, 9810333483

Mail us for any queries: learninggeeks@gmail.com

UNIT – I

Introduction: Characteristics of database approach, data models, DBMS architecture and data independence.

 

E-R Modeling: Entity types, entity set, attribute and key, relationships, relation types, roles and structural constraints, weak entities, enhanced E-R and object modeling, Sub Classes:, Super classes, inheritance, specialization and generalization,           

 

UNIT – II

File Organization: Indexed sequential access files, implementation using B++ trees, hashing, hashing functions, collision resolution, extendible hashing, dynamic hashing approach-implementation and performance.                                                              

 

UNIT – III

Relational Data Model: Relational model concepts, relational constraints, relational algebra.

SQL: SQL queries, programming using SQL

EER and ER to relational Mapping: Data base design using EER to relational language.

 

UNIT – IV

Data Normalization: Functional dependencies, Normal form up to 3^rd normal form.

Concurrency Control: Transaction processing, locking techniques and associated, database recovery, security and authorization.

Recovery Techniques, Database Security                                              

 

TEXT BOOKS:

1          R. Elmarsi and SB Navathe, “Fundamentals of Database Systems”, Addison Wesley, 4^th Ed., 2004

 

REFERENCE BOOKS:

1.            Abraham Silberschatz, Henry Korth, S. Sudarshan, “Database Systems Concepts”, 4^th Edition, McGraw Hill, 1997.

2.         Jim Melton, Alan Simon, “Understanding the new SQL: A complete Guide”, Morgan Kaufmann Publishers, 1993.

3.         A. K. Majumdar, P. Battacharya, “Data Base Management Systems’, TMH, 1996.

4.         Bipin Desai, “An Introduction to database Systems”, Galgotia Publications, 1991.

Posted via web from learninggeeks's posterous