EC3010 DATABASE MANAGEMENT SYSTEM SYLLABUS | ANNA UNIVERSITY BE MECHATRONICS ENGINEERING 8TH SEMESTER SYLLABUS REGULATION 2008 2011 2012-2013 BELOW IS THE ANNA UNIVERSITY 8TH SEMESTER B.E MECHATRONICS ENGINEERING DEPARTMENT SYLLABUS, TEXTBOOKS, REFERENCE BOOKS,EXAM PORTIONS,QUESTION BANK,PREVIOUS YEAR QUESTION PAPERS,MODEL QUESTION PAPERS, CLASS NOTES, IMPORTANT 2 MARKS, 8 MARKS, 16 MARKS TOPICS. 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
EC3010 DATABASE MANAGEMENT SYSTEM L T P C
3 0 0 3
UNIT I INTRODUCTION 9
Introduction to data file and database environment – Database administration – Data dictionary
– Basic data modeling concepts.
UNIT II PHYSICAL STORAGE ORGANIZATION 9
Database design – Conceptual model – Logical model – Data storage and access methods –
Physical Organization – Physical database design – Searching and reporting.
UNIT III PROGRAMMING 9
Programming in the database environment – Programming languages – programming language
interfaces – Front-end tools – Querying languages – Security and Integrity factors.
UNIT IV RECORD BASE MODELS 9
Relational Model: system R architecture, data structure – external level, data manipulation –
Hierarchical model: IMS architecture, data structure, external and internal levels – data
manipulation – Network model: DBTG architecture, data structure, external level, data
manipulation.
UNIT V RECENT TRENDS 9
Introduction to distributed databases – Recent trends in database systems – case studies using
existing systems – Comparative study of existing commercial systems.
TOTAL = 45 PERIODS
70
REFERENCES
1. Abraham Silberschatz, Henry F Korth, S.Sudharshan, “Database System Concepts”,
McGraw- Hill 1997.
2. Date C.J., “An Introduction to Database Systems”, III edition, Vol. I, Narosa Publishing
House, 1995.
3. James Martin, “Computer Database Organization” PHI Pvt. Ltd., 2002
4. Gerry M Litton, “Introduction to Database Management – A Practical Approach”, S. Chand &
Co Ltd., New Delhi, 1992
5. Atre S., “Database: Structured Techniques for design, performance and management”,
Wiley Interscience Publication, John Wiley and Sons, 1991
EC3010 DATABASE MANAGEMENT SYSTEM L T P C
3 0 0 3
UNIT I INTRODUCTION 9
Introduction to data file and database environment – Database administration – Data dictionary
– Basic data modeling concepts.
UNIT II PHYSICAL STORAGE ORGANIZATION 9
Database design – Conceptual model – Logical model – Data storage and access methods –
Physical Organization – Physical database design – Searching and reporting.
UNIT III PROGRAMMING 9
Programming in the database environment – Programming languages – programming language
interfaces – Front-end tools – Querying languages – Security and Integrity factors.
UNIT IV RECORD BASE MODELS 9
Relational Model: system R architecture, data structure – external level, data manipulation –
Hierarchical model: IMS architecture, data structure, external and internal levels – data
manipulation – Network model: DBTG architecture, data structure, external level, data
manipulation.
UNIT V RECENT TRENDS 9
Introduction to distributed databases – Recent trends in database systems – case studies using
existing systems – Comparative study of existing commercial systems.
TOTAL = 45 PERIODS
70
REFERENCES
1. Abraham Silberschatz, Henry F Korth, S.Sudharshan, “Database System Concepts”,
McGraw- Hill 1997.
2. Date C.J., “An Introduction to Database Systems”, III edition, Vol. I, Narosa Publishing
House, 1995.
3. James Martin, “Computer Database Organization” PHI Pvt. Ltd., 2002
4. Gerry M Litton, “Introduction to Database Management – A Practical Approach”, S. Chand &
Co Ltd., New Delhi, 1992
5. Atre S., “Database: Structured Techniques for design, performance and management”,
Wiley Interscience Publication, John Wiley and Sons, 1991
No comments:
Post a Comment
Any doubt ??? Just throw it Here...