AN3301 DATA BASE MANGEMENT SYSTEMS SYLLABUS | ANNA UNIVERSITY BE MECHANICAL AND AUTOMATION ENGINEERING 5TH SEMESTER SYLLABUS REGULATION 2008 2011 2012-2013 BELOW IS THE ANNA UNIVERSITY FIFTH SEMESTER BE MECHANICAL AND AUTOMATION ENGINEERING DEPARTMENT SYLLABUS, TEXTBOOKS, REFERENCE BOOKS, IT IS APPLICABLE FOR ALL STUDENTS ADMITTED IN THE YEAR 2011 2012-2013 (ANNA UNIVERSITY CHENNAI,TRICHY,MADURAI,TIRUNELVELI,COIMBATORE), 2008 REGULATION OF ANNA UNIVERSITY CHENNAI AND STUDENTS ADMITTED IN ANNA UNIVERSITY CHENNAI DURING 2009
AN3301 DATA BASE MANGEMENT SYSTEMS L T P C
3 1 0 4
UNIT I 9
Introduction : Concept and goals of DBMS, Database Languages, Database Users, Database
Abstraction.
DBMS models: Basic Concepts of ER Model, Relationship sets, Keys, Mapping, Design of ER
Model
Hierarchical model: Concepts, Data definition, Data manipulation and implementation.
UNIT II 9
Relational Model: Relational database, Relational Algebra, Relational Calculus
UNIT III 9
Network Model: Network Data Model, DBTG Set Constructs, and Implementation.
Relational Database Design and Query Language : SQL, QUEL, QBE,
UNIT IV 9
Normalization using Functional Dependency, Multivalued dependency and Join dependency.
Concurrency Control: Lock Based Protocols, Time Stamped Based Protocols, Deadlock Handling
UNIT V:
Crash Recovery: New Applications: Distributed Database, Objective Oriented Database,
Multimedia Database, Data Mining, Digital Libraries.
TUTORIALS 15 TOTAL : 60 PERIODS
TEXT BOOKS:
1 .B.C. Desai, “Database Management”, Tata McGraw Hill Publication Ltd.
2. Elmasery Navathe, “Fundamentals of Database Management”, Pearson Education, 3rd edition.
3. T.J. Date, “Database Management”, Pearson Education, 7th edtion.
4. Raghuram Singh, “Database Management”, McGraw Hill International, 2nd edition.
REFERENCES:
1.Korth, “Database Management”, Tata McGraw Hill, 4th edition.
2.Alexis Leon, “Database Management”, Vikas Publication.
AN3301 DATA BASE MANGEMENT SYSTEMS L T P C
3 1 0 4
UNIT I 9
Introduction : Concept and goals of DBMS, Database Languages, Database Users, Database
Abstraction.
DBMS models: Basic Concepts of ER Model, Relationship sets, Keys, Mapping, Design of ER
Model
Hierarchical model: Concepts, Data definition, Data manipulation and implementation.
UNIT II 9
Relational Model: Relational database, Relational Algebra, Relational Calculus
UNIT III 9
Network Model: Network Data Model, DBTG Set Constructs, and Implementation.
Relational Database Design and Query Language : SQL, QUEL, QBE,
UNIT IV 9
Normalization using Functional Dependency, Multivalued dependency and Join dependency.
Concurrency Control: Lock Based Protocols, Time Stamped Based Protocols, Deadlock Handling
UNIT V:
Crash Recovery: New Applications: Distributed Database, Objective Oriented Database,
Multimedia Database, Data Mining, Digital Libraries.
TUTORIALS 15 TOTAL : 60 PERIODS
TEXT BOOKS:
1 .B.C. Desai, “Database Management”, Tata McGraw Hill Publication Ltd.
2. Elmasery Navathe, “Fundamentals of Database Management”, Pearson Education, 3rd edition.
3. T.J. Date, “Database Management”, Pearson Education, 7th edtion.
4. Raghuram Singh, “Database Management”, McGraw Hill International, 2nd edition.
REFERENCES:
1.Korth, “Database Management”, Tata McGraw Hill, 4th edition.
2.Alexis Leon, “Database Management”, Vikas Publication.
No comments:
Post a Comment
Any doubt ??? Just throw it Here...