University of Pune 2009 PG Diploma PGDCM-DATABASE MANAGEMENT SYSTEM AND ORACLE (2008 Pattern) - Question Paper

Total No. of ques. : 8] [Total No. of Printed Pages : two [3689]-203
P. G. D. C. M. (Semester - II) exam - 2009 DATABASE MANAGEMENT SYSTEM AND ORACLE (2008 Pattern)
Time : three Hours] [Max. Marks : 70

Instructions :
(1) In part I, Q. one is compulsory. ans any two ques. from Q. two to 4.
(2) In part II, Q. five is compulsory. ans any two ques. from Q. six to 8.

part - I
Q.1) What is Normalisation ? [15]
Normalize subsequent data up to 3NF with proper example. (SalesOrderNo, SalesOrderdate, CustomerNo, CustomerName, CustomerAddress, CustomerPhone, ItemNo, ItemName, Qty, Price,
Amount, TotalAmount)

Q.2) describe DBMS. discuss advantages and disadvantages of DBMS. [10]

Q.3) State and discuss E.F. Codd's Rules. (Any Ten) [10]

Q.4) Write short notes : (Any Two) [10]
(a) Cardinality
(b) Data kinds of MS-Access
(c) Parametric Cursor

part - II
Q.5)
(A) discuss Self Join with proper example. [05]
(B) ans the subsequent SQL queries using the subsequent tables :
(Any Ten) [10]
Project (ProjectNo, Title, Platform, Duration) Student(StudentNo, SName, ProjectStart_date, ProjectCompletion_date, ProjectNo)
Note : Duration is in months.
(1) Display students working on the Sales Management System.
(2) Display students who are late in completing the project.
(3) Display learner details having projects with less than six months duration.
(4) Display total no. of students for every project.
(5) Create learner table with improper constraints.
(6) Display students who have started working on their Project in the month of April.
(7) Add a new column contract_no to the learner table.
(8) Delete record of students who have completed their project.
(9) Display details of projects where the project platform may be Java or Visual Basic.
(10) Display students name having R as the 3nd character in their names.
(11) Insert 1 record in the project and learner table.

Q.6) discuss date functions of Oracle with proper example. [10]

Q.7) discuss the subsequent with proper example : (Any Two) [10]
(a) Round and Truncate
(b) User and Uid
(c) Union and Intersect

Q.8) discuss in brief background processes in Oracle. [10]

Earning:   Approval pending.