Hello There, Guest! RegisterLogin with Facebook
Login with Facebook

New Anna University Nov / Dec 2016 Examination Important Questions
New Anna University (UG / PG) Nov/Dec 2016 and Jan 2017 Theory , Practical Exam Timetable
>>> Anna University Sixth Semester Question Bank Collection (R2013) ECE,MECH,CSE,IT,EEE,CIVIL,EIE
>>> Anna University November/December 2015 Examination Question Papers
>>> 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

CS6312 Database Management System Lab Manual - UCE Edition
#1
Thumbs Up 



Full Name :prakash kumar
College Name :university college of engineering,villupuram.
Department :information technology
Semester :3
Subject Code : cs6302
Subject Name : database management system
Study Material Description :

LIST OF EXPERIMENTS:

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
conditions.
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

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

Attachment :

.pdf   DBMS Lab Manual updated.pdf (Size: 319.38 KB / Downloads: 2,371)




Reply
#2

Good Start.. +2 Reputed

New Share your Study Materials with us : Click Here


Reply
#3


$$$$$$$$$$$$$kudos man$$$$$$$$$$$



Reply

Subscribe


Recommend on Google