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: kishore Member Level: Gold Posted Date: 25 May 2008
|
2007 Jawaharlal Nehru Technological University M.B.A DATABASE MANAGEMENT SYSTEMS Question paper
1. The table ticker(Symbol, Time, Price) given below is abbreviated to
K(S,T,P) is a slightly idealized representation of these tock market
ticker tape by a table. Please note that although the tuples of this
table are ordered by time, there is no significance of ordering. Any
reordering of the tuples would man the same thing. Construct a
relational algebra expression that computes all the upturns in this
table. An upturn is the first point at which the price of the stock
increases after it has been static or falling. Your query should
deliver the tuple that causes the upturn. No marks will be given for
simply writing down the answer. Intermediate tables should be
constructed and what they represent should be explained clearly.
S T P
ABC 1000 12.2
XYZ 1002 5.4
XYZ 1003 5.2
ABC 1007 12.0
XYZ 1009 5.0
ABC 1012 12.0
XYZ 1015 5.4
XYZ 1017 5.8
ABC 1019 12.4
XYZ 1022 5.3
ABC 1027 12.8
XYZ 1030 5.4
ABC 1037 12.8
XYZ 1040 5.3
2. A company database needs to store information about employees
(identified by ssn, with salary ad phone as attributes); departments
(identified by dno, with dname and budget as attributes); and
children of employees (with name and age as attributes).
Employees work in departments; each department is managed by
an employee; a child must be identified uniquely by name with the
parent (who is an employee; assume that only one parent works for
the company) is known. We are not interested in information about
a child once the parent leaves the company. Draw an Entity
relationship diagram that captures this information.
Contd….2
OR
Code No: OR-25/MBA -2-
3.a) Prove that every binary relation is in BCNF?
b) What is data independence? Discuss various levels of it with a neat
diagram.
4. What is meant by view? State the difference between simple view
and complex view. Give examples for each kind of view.
5.a) State the responsibilities of Database Administrator?
b) Discuss with examples various kinds of relationships that exist
between two entity sets.
6. Discuss the data retrieval features of Relational Calculus. Also
explain in what way it is different from Relational algebra?
7. Discuss briefly about the features of network data model.
8. Write short notes on:
a) IMS structure
b) Data security features in DBMS.
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
|