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: ramya Member Level: Gold Posted Date: 12 Mar 2008
|
2007 Anna University M.B.A Business Administration BA 1740 Database Management Systems Question paper
|
|
|
Part A (20 marks)
1.What do you meam by cardinality?
2.Define the terms:
a)composite attributes.
b)multivalued attributes
3.Compare superkey with canditate key.
4.Give an account on Datadictionary.
5.What is meant by safe expression in relational calculus?
6.Define the term:
a)OOA
b)OOD.
7.Define the term:
a)metaclass
b)Parametrized class.
8.Define the term:
a)system log.
b)Database audit.
9.What are the advantages os distributed databases?
10.Provide example for Automicity.
Part - B(80 Marks)
11a.
1.Explain the advantages and disadvantages of database systems.
2.Explain DBMS architecture and its components with neat diagram.
or
11b.
1.compare logical data independence and physical data independence.
2.Explain the terms.
a.Entity Integrity.
b.domain integrity.
12a.
1.Explain about various constraints and characteristics of
Specialization and Generalization.
2.Explain about associations and relationships with neat diagram.
or
12b.
1.Explain Indexed sequential file organization technique with diagrams.
2.Explain OODBMS datamodel with neat necessary diagrams.
13a.
1.Explain about the nested queries and set comparisons with an example.
2.compare tuple relational calculus and domain ralational calculus.
3.give the similarities and differences between Relational calculus and Relational algebra.
or
13b.
1.consider the universal relation R={A,B,C,D,E,F,G,H,I,J} and the set of functional dependencies
F={{A,B}--> {C},{A}-->{D,E},{B}-->{F},{F}-->[G,H},{D}-->{I,J}.
What is the key for R?decompose R into 2NF,then 3NF relations.
2.design an ERDiagram for Hospital Management System.
14a.
1.Explain th eissue n buiding quality classes and objects.
2.Explain Object interaction modeling with necessary diagrams.
or
14b.
1.Explain the building blocks of UML.
2.Explain various kinds of UML relationships.
3.Explain the standard stereotype defined by UML that can be applied to packages.
15a.
1.What is the difference between the constrained write and the Unconstrained write assumptions?Which is more realistic?
2.Explain two phases locking protocol.
3.Explain the following deadlock prevention protocols in detail.
a.Wait-die.
b.Wound-wait
or
15b.Differentiate OLTP and OLAP servers.What is data warehousing?
Discuss the OLPA operation performed in data warehousing with suitable example.
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
Watch Asianet TV onlineKairali TV in InternetSurya TV onlineAmritha TV Channel
|