Database Management Systems Laboratory Syllabus for B.Tech 3rd sem is covered here. This gives the details about credits, number of hours and other details along with reference books for the course.
The detailed syllabus for Database Management Systems Laboratory B.Tech (R13) thirdsem is as follows
OBJECTIVES: The student should be made to:
- Learn to create and use a database
- Be familiarized with a query language
- Have hands on experience on DDL Commands
- Have a good understanding of DML Commands and DCL commands
- Familiarize advanced SQL queries.
- Be Exposed to different applications
LIST OF EXPERIMENTS:
- Creation of a database and writing SQL queries to retrieve information from the database.
- Performing Insertion, Deletion, Modifying, Altering, Updating and Viewing records based on conditions.
- Creation of Views, Synonyms, Sequence, Indexes, Save point.
- Creating an Employee database to set various constraints.
- Creating relationship between the databases.
- Study of PL/SQL block.
- Write a PL/SQL block to satisfy some conditions by accepting input from the user.
- Write a PL/SQL block that handles all types of exceptions.
- Creation of Procedures.
- Creation of database triggers and functions
- Mini project (Application Development using Oracle/ Mysql )
- Inventory Control System.
- Material Requirement Processing.
- Hospital Management System.
- Railway Reservation System.
- Personal Information System.
- Web Based User Identification System.
- Timetable Management System.
- Hotel Management System
REFERENCE:
spoken-tutorial.org
[TOTAL: 45 PERIODS]
Download iStudy Android App for complete Anna University syllabus, results, timetables and all other updates. There are no ads and no pdfs and will make your life way easier.
OUTCOMES: At the end of the course, the student should be able to:
- Design and implement a database schema for a given problem-domain
- Populate and query a database
- Create and maintain tables using PL/SQL.
- Prepare reports.
LIST OF EQUIPMENT FOR A BATCH OF 30 STUDENTS HARDWARE:
Standalone desktops 30 Nos.
(or)
Server supporting 30 terminals or more.
SOFTWARE:
Front end: VB/VC ++/JAVA or Equivalent
Back end: Oracle / SQL / MySQL/ PostGress / DB2 or Equivalent
For all other B.Tech IT 3rd sem syllabus go to Anna University B.Tech Information Technology (IT) 3rd Sem Course Structure for (R13) Batch. All details and yearly new syllabus will be updated here time to time. Subscribe, like us on facebook and follow us on google plus for all updates.
Do share with friends and in case of questions please feel free drop a comment.