Dear students, get latest Solved assignments by
professionals.
Mail us at: help.mbaassignments@gmail.com
Call us at: 08263069601
Xaviers Institute of
Business Management Studies
MARKS:
80
SUB : Data Management
PART – A
(5 x 4 = 20 Marks)
Attempt any
5 Questions
1. Distinguish between specialization and generalization.How
will you represent them in an ER diagram?
2. Give examples of different types of
JOIN statement in SQL.
3. What are clustered indexes? What
is the maximum number of clustered index allowed on one data file?
4. List the different types of
constraints that can be specified in a relational database.
5. Define functional dependency and state
the Normal Form based on this.
6. State the desirable properties of a
transaction.
7. What are temporal databases? Give an
example of a typical application where such databases will be required.
8. Explain inheritance property in
OODBMS.
9. Draw a block diagram showing the basic
steps in Query Processing.
10. Define: (a) Network transparency
(b) Fragmentation transparency
Dear students, get latest Solved assignments by
professionals.
Mail us at: help.mbaassignments@gmail.com
Call us at: 08263069601
PART – B
(3 X 20 = 60
Marks)
Attempt any
3 Questions
11. (i) Explain the 3 schema architecture in DBMS.
Highlight the difference between physical and logical data
independence.
(ii)
Define 3 NF and Boyce-Codd NF. Explain with suitable
examples.
12.
(i) Compare a file based system and an RDBMS system. When will you
develop a file based
system?
(ii) Construct an ER diagram for a company, which sells and services cars. The
company keeps information about customers who purchase one or more cars, the
sales person who is responsible for the sale and service details for each car
is maintained. (assume minimum of 4 attributes on each entity
type)
13. (i)
With a suitable diagram, explain the overall structure of a database
system.
(ii) Define primary key, super key and
candidate
key.
(iii) What are inference rules in a functional dependency? When
is a set of FD said to be a minimal
set?
14. (i) List the operations of the
relational algebra and explain with Suitable
example
15. (i) Explain the different types of
indexes. Which of these indexes are dense and which are not.
16. a) (i) Discuss why concurrency
control is needed in a
DBMS?
(ii) Explain any one method by which concurrency is achieved in a
DBMS.
17. (i) Explain with examples the
concept Record and SET data structures in a Network data
,model
(ii) Explain how a select operation is done in query
processing?
18. (i) Explain the concept of Object and
Object Identity in Object
Oriented data
model
(ii) Discuss the features of Distributed
database.
(iii) Explain the 2-phase commit protocol for distributed
database.
19. (i) Describe the association
rule and classification rules in data
mining?
(ii)
With a schematic diagram explain the architecture and features
Dear students, get latest Solved assignments by
professionals.
Mail us at: help.mbaassignments@gmail.com
Call us at: 08263069601
No comments:
Post a Comment
Note: only a member of this blog may post a comment.