Punjab Technical University 2007-5th Sem M.B.A III/I DATABASE MANAGEMENT SYSTEM - Question Paper

DATABASE MANAGEMENT SYSTEM
M.B.A(MB-542),3rd/4th Semester (2096)

Time: three Hours Max Marks:75

Note: part A is compulsory. Attempt any 9 ques. from part B(marks five each).
SECTION A

1.
i. What is data and information?
ii. What is a database?
iii. What is a subschema?
iv. What is the difference ranging from entity and entity set?
v. What is a secondary key?
vi. Discuss the kind of relationships that exists ranging from entities.
vii. What is metadata?
viii. What is the purpose of drawing ER diagram?
ix. What is the difference ranging from attribute and a value set?
x. Discuss user described and predicate described subclasses.
xi. Why are the magnetic disks not the magnetic tapes used to store on-line database files?
xii. Does multilevel indexing improves efficiency of searching in index files? Justify your ans.
xiii. Why are duplicate tuples not allowed in a relation?
xiv. Why are many nulls in a relation considered bad?
xv. What is demoralization?
(2x15)
Section B

2. What are the responsibilities of a database administrator?
3. Discuss entity integrity and referential integrity constraints.
4. Explain with the help of a few example a key, a super key and a foreign key.
5. What are the main characteristics of database approach and how does it differ from traditional approach?
6. Discuss the categories of data models.
7. List the operations of relational algebra and write the purpose of every.
8. What is data independence? What is difference ranging from physical data independence and logical data independence?
9. What is file organization? elaborate difference file organizations? explain any 1 of them in detail?
10. What is functional dependency? discuss with the help of a few suitable example.
11. How are buffering and caching techniques used for recovery subsystem?
12. What are 1st 2nd and 3rd forms of normalization? provide a few example.
13. a. Write down the advantages and disadvantages of distributed databases.
b. What is meant by data allocation in distributed database design?

Earning:   Approval pending.