Go Back   2021-2022 StudyChaCha > StudyChaCha Discussion Forum > General Topics

  #1  
Old June 2nd, 2014, 11:45 AM
Unregistered
Guest
 
Default Gujarat University, PGDCA, 2nd Semester previous years question papers

Can you please give me the Gujarat University, PGDCA, 2nd Semester previous years question papers as I am having my exams?
Reply With Quote
Other Discussions related to this topic
Thread
B.Sc Physics 1st and 2nd semester question papers of previous years of University of
Question papers of previous years of Calicut University 5th Semester B.Tech Civil
Gujarat Board Class X Social Studies Previous Years Question Papers
PTU BBA 2nd Semester Exam Previous Years Question Papers
GTU B.Tech 5th Semester Previous Years Question Papers
Anna University Chennai question papers for ECE 5th semester of past years
MU BE in ET, 4th Semester, Applied Mathematics-IV Exam Previous Years Question Papers
Anna University Chennai previous years question papers for CS 5th semester
Delhi University - B.Sc. (H) Computer Science - 2nd Semester previous years question
University Of Kerala, MCA, 4th Semester previous years question papers
Marketing Management Papers of previous years of Gujarat Technological University
B.E Anna University Computer Science (6th Semester) previous year question papers
IGNOU MCA Semester II previous years question papers
Punjab Technical University, Jalandhar MCA 1st Semester previous years question paper
Gujarat University, Bachelor of Physical Education previous years question papers
Punjab Technical University BBA 4th Semester previous years question papers
Gujarat University, Diploma in Yoga previous years question papers
Anna University BE 4th semester ECE previous year question papers
BBA, 2nd Semester University of Pune Previous Years Question Papers
6th Semester Previous Years Question Papers of Digital Signal Processing






  #2  
Old June 2nd, 2014, 05:52 PM
Super Moderator
 
Join Date: May 2011
Default Re: Gujarat University, PGDCA, 2nd Semester previous years question papers

As you want to get the Gujarat University, PGDCA, 2nd Semester previous years question papers so here is the information of the same for you:

Some content of the file has been given here:

1 (a) List four significant differences between file 9
processing system and a DBMS.
(b) What are the main functions of DBA ?
(c) What are the roles and duties of a DBMS.
2 (a) Define aggregation. Give example where this 8
concept can be used ?
(b) Explain how tables are derived from E-R diagram.
OR
2 Consider an on-line bookstore where a customer can 8
select books of his liking from the web-site and place them
in the shopping cart. The bookstore maintains a database
of all books it has along with information such as author
and publisher. The stock of multiple copies of books are kept
in various store houses located at different locations. The
online bookstore also provides audio cassettes and books on
CD which the customer can purchase. List down the various
entities, attributes associated with each entity and draw the
E-R diagram modelling the online bookstore.
XX-1000] 2 [Contd...
3 Explain the following : (any two) 8
(i) 1 NF, 2 NF, 3 NF
(ii) Weak Entities and Strong entities
(iii) Closure set of Functional dependencies.
SECTION - II
4 Consider the following tables : 9
Category
Cat_code cat_desc
01 super_deluxe
02 deluxe
03 super fast
04 normal

(i) Update the capacity of all buses terminating at Chennai
to 60.
(ii) Find the average fare for each category.
(iii) Display all buses which terminate in Madurai, Banglore
and Chennai.
(iv) Display the date 30 days from today and the day on
which it falls.
(v) Find the total fare of all buses starting from Chennai.
(vi) Display distinct origin and distinct destination where
the buses ply.
(vii) Convert the origin and destination to capital letters.
(viii) Display all the destinations right justified padded with
spaces.
(ix) Insert a new category into category table.
5 Answer the following : 8
(a) What are the three concurrency problems ?
(b) What is two phase commit ? How does it help in
recovery ?
OR
5 (a) List down the various operators of relational 8
algebra and discuss each one of them.
(b) Explain the relational model.
6 Attempt any two : 8
(a) What is three level ANSI/SPARC architecture ?
(b) How can the problem of concurrency be controlled ?
(c) Explain functional dependencies and trivial functional
dependencies using proper example.

For more detailed information I am uploading PDF files which are free to download:

Contact Details:[/B]
Gujarat University
120 Circular Road,
Navrangpura,
Ahmedabad,
Gujarat 380009 ‎
079 2630 1341
India

Map Location:
__________________
Answered By StudyChaCha Member
Reply With Quote
Reply


Reply to this Question / Ask Another Question
Your Username: Click here to log in

Message:
Options



All times are GMT +6.5. The time now is 01:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0 PL2

1 2 3 4 5 6 7 8