Database Management Systems Laboratory detail syllabus for Mech & Auto (Mech & Auto), 2017 regulation is taken from Anna University official website and presented for students of Anna University. The details of the course are: course code (CS8481), Category (ES), Contact Periods/week (4), Teaching hours/week (0), Practical Hours/week (0). The total course credits are 4.
For all other mech & auto 5th sem syllabus for be 2017 regulation anna univ you can visit Mech & Auto 5th Sem syllabus for BE 2017 regulation Anna Univ Subjects. The detail syllabus for database management systems laboratory is as follows.”
Aims:
- The aim of this laboratory is to inculcate the abilities of applying the principles of the database management systems.
- This course aims to prepare the students for projects where a proper implementation of databases will be required.
Course Objective:
- To understand data definitions and data manipulation commands
- To learn the use of nested and join queries
- To understand functions, procedures and procedural extensions of data bases
- To be familiar with the use of a front end tool
- To understand design and implementation of typical database applications
List of Exercises:
- Data Definition Commands, Data Manipulation Commands for inserting, deleting, updating and retrieving Tables and Transaction Control statements
- Database Querying – Simple queries, Nested queries, Sub queries and Joins
- Views, Sequences, Synonyms
- Database Programming: Implicit and Explicit Cursors
- Procedures and Functions
- Triggers
- Exception Handling
- Database Design using ER modeling, normalization and Implementation for any application
- Database Connectivity with Front End Tools
- Case Study using real life database applications
Course Outcome:
Upon completion of the course, the students will be able to:
- Use typical data definitions and manipulation commands.
- Design applications to test Nested and Join Queries
- Implement simple applications that use Views
- Implement applications that require a Front-end Tool
- Critically analyze the use of Tables,Views, Functions and Procedures
For detail syllabus of all other subjects of BE Mech & Auto, 2017 regulation do visit Mech & Auto 5th Sem syllabus for 2017 Regulation.
Dont forget to download iStudy for latest syllabus and results, class timetable and more.