My Profile
Active Members
TodayLast 7 Days
more...
Awards & Gifts
Online Exams
Fresher Jobs
Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian
cities including Bangalore, Chennai, Hyderabad, Pune or Kochi
Resources
Find educational articles, blogs, discussion threads and other resources.
Colleges
Find details about any college in India or search for courses.
|
Download Model question papers & previous years question papers
|
Posted By: sac Member Level: Diamond Posted Date: 30 Apr 2008
|
2007 Alagappa University M.C.A Lab V : RDBMS Question paper
|
|
|
DISTANCE EDUCATION
M.C.A. (S) DEGREE EXAMINATION, DECEMBER 2007.
Third Semester
Lab V : RDBMS
(2005 onwards)
Time : Three hours Maximum : 100 marks
One question is to be given by the examiner to each candidate by lot systm.
1. Consider the following relations for a database that keeps track of business trips of sales persons in a sales office :
SALES PERSON (SSN, Name, Start-year, Dept-No)
TRIP (SSN, From-City, To-City, Dep-Date, Rep-Date, Trip- ID)
Expense (Trip-ID . Account #, Amount)
Create tables in oracle for the above schema specify the foreign keys. Write SQL for the following :
(a) Print the SSN of sales person who tools trips to ‘‘Bangalore’’.
(b) Print the total trip expenses incurred by sales man with SSN = ‘‘234 – 56 – 7890’’.
2. Consider the following relations for a database that keeps track of auto sales in a car dealership. Option refers to zone optional equipment installed on an auto.
Car (Serial – no., Model, Manufactures, price)
Options (Serial – no., Option – name, Price)
Sales (Sales person – id, Serial – no., Date, Sales price)
Sales person (Sales person – Id, Name, Phone)
Create tables in oracle for the above scheme
Specify the foreign keys. Next populate the relations with a few example tuples and then show an example of an in section in the SALES and SALES PERSON relations that violates the referential integrity constraints. Specify the following queries in SQL.
(a) For the sales person named ‘ram’, list the following information for all the cars he sold : Serial no., manufacturers, sale-price.
(b) List the serial no and model of cars that have no options.
3. Consider the following relations for a database that keeps fresh and student enrollment in courses and the books adopted for each course.
Student (SSN, Name, Major, Bdate)
Course (Course No., Course Name, Dept)
Enroll (SSN, Course No., Quarter Grade)
Book – Adoption (Course No., Quarter, Book-ISBN)
Text (Book-ISBN, Book-Title, Publisher, Author)
Create table by Specifying the foreign keys for the above schema stating any assumptions you make.
(a) List the number of courses taken by all students named ‘‘John’’ in 1999.
(b) List the books from particular author, borrowed by a student.
4. Consider the following six relations for an order processing database applications in a company :
Customer (customer id, cname, city)
Order (order no, order date, customer id, order amt)
Order – item (order no, item no, qty)
Item (item no., unit-price)
Shipment (order no., ware house no, ship-date)
Warehouse (ware house no, city).
Here order amt refers to total doller amount of an order. Order date is the date the order was placed. Ship-date is the date an order is shipped from the warehouse. Create tables for the above schema and specify foreign keys specify the following SQL queries :
(a) List the order no, shipment date, for all orders shipped from warehouse number = ‘‘w3’’.
(b) List the warehouse information from which the customer named ‘‘John’’ was supplied his orders. Produce a listing order no, warehouse no.
5. Write a PL/SQL program to implement the following exceptions :
(a) Too_Many_Rows
(b) DVD_VAL_ON_INDEX
(c) INVALID_NUMBER.
6. Write a PL/SQL program to implement the following exceptions :
(a) NO_DATA_FOUND
(b) VALUE_ERROR
(c) Other was defined exceptions.
7. A relational database is given with the following
relations :
EMPLOYEE (Emp¬-Name, Street, City)
WORKS (Emp-Name, Company-Name, Salary)
COMPANY (Company-Name, City)
MANAGES (Emp-Name, Manager-Name)
Construct tables for the above relations. Write SQL for the following :
(a) Find the company with most employees
(b) Find the company with smallest payroll
(c) Find the names of all employees who work for ABC company
(d) Find the names of all employees who do not work for ABC company.
8. Consider the following relations :
SUPPLIER (S-ID : integer, S-name : string, Address :
String)
PARTS (P-ID : integer, P-Name : string, colour : string)
CATALOGUES (S-ID : integer, P-ID : integer, COST :
real)
Create tables for the above relations. Write SQL for the following :
(a) Find the name of suppliers who supply same red part
(b) Find the P-IDs of parts that are supplied by atleast two different suppliers.
(c) Find the S-IDs of suppliers who supply same red part and green parts
(d) Find the S-IDs of suppliers who supply every part.
9. Let us assume that a database system has the following relations :
STUDENTS (Name, Roll-no., Address, Main)
ADMISSION (Roll-no., Course, Semester)
FACULTY (Course, Faculty, Semester)
OFFERING (Branch, Course)
Write SQL to generate outputs for the following queries.
(a) All courses taken by a given student
(b) All faculty that at same time taught a given student
(c) The names of students admitted in a particular course in a given semester
(d) Students who have taken all course offered by a given faculty.
10. Construct an E-R diagram for a hospital management system with a set of doctors and a set of patients. With each patient, a series of various tests and examinations are conducted. On the basis of preliminary report patients are admitted to a particular speciality ward. Construct appropriate tables for the above E-R diagram.
Return to question paper search
|
|
|
Submit Previous Years University Question Papers and make money from adsense revenue sharing program
Are you preparing for a university examination? Download model question papers
and practise before you write the exam.
|
Watch TV Channels
|