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