GI3204 DATABASE SYSTEMS SYLLABUS | ANNA UNIVERSITY BE GEOINFORMATICS ENGINEERING 3RD SEMESTER SYLLABUS REGULATION 2008 2011-2012

Latest: TNEA 2014 Engineering Application Status, Counselling Date, Rank List

GI3204 DATABASE SYSTEMS SYLLABUS | ANNA UNIVERSITY BE GEOINFORMATICS ENGINEERING 3RD SEMESTER SYLLABUS REGULATION 2008 2011-2012 BELOW IS THE ANNA UNIVERSITY THIRD SEMESTER BE GEOINFORMATICS ENGINEERING DEPARTMENT SYLLABUS IT IS APPLICABLE FOR ALL STUDENTS ADMITTED IN THE YEAR 2011-2012 (ANNA UNIVERSITY CHENNAI,TRICHY,MADURAI,TIRUNELVELI,COIMBATORE), 2008 REGULATION OF ANNA UNIVERSITY CHENNAI AND STUDENTS ADMITTED IN ANNA UNIVERSITY CHENNAI DURING 2009

GI3204 DATABASE SYSTEMS L T P C
3 0 0 3
OBJECTIVE:
The objective of this course is to introduce the students to basic concepts of
database, file systems and organization, Database Management System (DBMS) and
.Net for database.
UNIT I INTRODUCTION 7
Data – Information - File system vs DBMS – Data models – Hardware and software
requirements – Database Management Systems – Database languages, Database
Architecture, users and administrators – Classification of Database Management
Systems
UNIT II RELATIONAL DATA MODEL 9
Relational model – Data Structure – Constraints – Keys – Codd’s Rule – Relational
Algebra – Fundamental operations - Additional operations – Extended operations – Null
values
26
UNIT III SQL 9
SQL – Data Definition - Basic structure of SQL queries – Set operations – Aggregate
Functions – Null values – Nested sub queries – Complex queries – Views –
Embedded SQL – Dynamic SQL – Triggers
UNIT IV DATABASE DESIGN AND MANAGEMENT 10
Design process – Entity Relationship Model – Constraints – EER – Diagrams –
Atomic domain and First Normal Form - Functional Dependency – Decomposition using
Functional dependencies – Normalization using Multi-Valued Dependencies and Join
Dependencies – Basic concepts of file organizations, indexing and hashing - Database
recovery techniques – Database Security – Handling Spatial Database
UNIT V ACCESSING DATA USING ADO.NET AND VB.NET 10
ADO.Net Object Model using OLE DB managed provider – Other data providers –
Accessing XML data – Building Windows application using VB.Net – Programming web
applications with web form
TOTAL : 45 PERIODS
TEXT BOOKS:
1. Abraham Silberschatz, Henry F. Korth and S.Sudharshan, “Database System
Concepts”, Fifth edition, Tata McGraw Hill, 2005
2. Ramez Elmasri and Shamkant B.Navathe, “Fundamentals of Database Systems”
Fourth edition, Pearson Education (Singapore) Pvt. Ltd. 1st Indian Reprint, 2004
REFERENCES:
1. Raghu Ramakrishnan and Johannes Gehrke, “Database Management
Systems”, 3nd Edition, , McGraw Hill Publishers, 2003
2. Paul J. Deitel and Harvey M. Deital “Visual Basic 2005 for Programmers”, 2nd
Edition, Pearson Education, 2007.