Hello There, Guest! RegisterLogin with Facebook
Login with Facebook

>>> Anna University Sixth Semester Question Bank Collection (R2013) ECE,MECH,CSE,IT,EEE,CIVIL,EIE
>>> Anna University Study Materials for all Departments
>>> Anna University Question Papers : April May June 2015 Question Papers | Nov Dec 2014 and Jan 2015 Question Papers

Register or Login to Submit Study Materials , Shoutbox and also to access Many Features !!

Vidyarthiplus Shop :: Handwritten Premium Lecture Notes
Share your Study Materials with us
Share your Study Materials with us : Click Here

IT6312 Database Management Systems Lab Manual


Anna University , Chennai

Department of Information Technology

Third Semester

Regulation 2013

IT6312 Database Management Systems Lab Manual

IT6312 – DBMS Lab Manual 
1. Creation of a database and writing SQL queries to retrieve information from the database. 
2. Performing Insertion, Deletion, Modifying, Altering, Updating and Viewing records based on 
3. Creation of Views, Synonyms, Sequence, Indexes, Save point. 
4. Creating an Employee database to set various constraints. 
5. Creating relationship between the databases. 
6. Study of PL/SQL block. 
7. Write a PL/SQL block to satisfy some conditions by accepting input from the user. 
8. Write a PL/SQL block that handles all types of exceptions. 
9. Creation of Procedures. 
10. Creation of database triggers and functions 
11. Mini project (Application Development using Oracle/ Mysql )  
a) Inventory Control System. 
b) Material Requirement Processing.  
c) Hospital Management System. 
d) Railway Reservation System. 
e) Personal Information System. 
f) Web Based User Identification System. 
g) Timetable Management System. 
h) Hotel Management System

Attachment :

.pdf   it6312_dbms_manual.pdf (Size: 730.58 KB / Downloads: 3,806)

New Share your Study Materials with us : Click Here



Recommend on Google