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

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

GI3208 DATABASE SYSTEMS LABORATORY 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

GI3208 DATABASE SYSTEMS LABORATORY L T P C 0 0 4 2
OBJECTIVE:
To get practical experience on the server – client setup on the database
management
1. Server / client operations
The server / client – Starting / Shutdown of server - Configuring client over network
2. Data Definition of Tables and Views
Exercises on Creation, Deletion and Modification of definition
3. Data Manipulation of Tables and views
Exercises on queries and to insert, delete and modify rows
4. Data Control of Tables and Views
Exercises on control of tables and views
5. Database triggers
Use of queries on complex integrity constraints
6. Forms designing
Designing of forms for input/output
7. Menu designing
Designing of user menus for database interactions
8. Report preparations
Generating formatted reports
9. Front end tool – applications
Designing of database application with any front end tool
TOTAL: 60 PERIODS