Advanced Database Management System - Tutorials and Notes: MC 7103 – DATABASE MANAGEMENT SYSTEMS January 2014 Question Paper

Saturday, 28 June 2014

MC 7103 – DATABASE MANAGEMENT SYSTEMS January 2014 Question Paper

MC 7103 – Database Management Systems - January 2014 Question Paper / Anna University MCA Exam January 2014 Question Paper / MC7103 DBMS January 2014 Question Paper / MC7103 Database Management Systems Previous Year Question Paper with Answers / Anna University Affiliated Colleges MCA Question Papers / Regulation 2013 MC7103 Question Paper

Question Paper Code : 80813
(Regulation 2013)
Time : Three Hours                                                         Maximum : 100 marks
Answer ALL Questions
PART A – (10 X 2 = 20 marks)

1. Differentiate file systems from a database system.
2. What is weak entity sets? Give examples.
3. Define the “integrity rules”
4. What is a view? How it is related to data independence?
5. What do you understand from Time stamping? Give examples.
6. What is shadow paging? When it is used?
7. What is the use of unstructured file? Give an example.
8. When do we need to do indexing and hashing?
9. What is persistent data? Give an example.
10. What are mobile databases? Give an example.

PART B – (5 X 16 = 80 marks)

11. (a) Explain the various levels of database schema based on the data abstraction. How does the schema support different type of data independence? (16)
(b) Scenario: A publishing company produces scientific books on various subjects. The books are written by authors who specialize in one particular subject. The company employs editors who, not necessarily being specialists in a particular area, each take sole responsibility for editing one or more publications. A publication covers essentially one of the specialist subjects and is normally written by a single author. When writing a particular book, each author works with one editor, but may submit another work for publication to be supervised by other editors. To improve their competitiveness, the company tries to employ a variety of authors, more than one author being a specialist in a particular subject.
Draw an ER diagram that represents the above scenario and also identify the thing like entities, attributes of entities, all keys, relationship among the entities, cardinality/connectivity between entities and any assumption you make. (16)

12. (a) Consider the following relational schema. An employee can work in more than one department; the pct_time field of the Works relation shows the percentage of time that a given employee works in a given department.
Emp(eid: integer, ename: string, age: integer, salary: real)
Works(eid: integer, did: integer, pct_time: integer)
Dept(did: integer, dname: string, budget: real, managerid: integer)
Write the following queries in SQL;
(i) Print the names and ages of each employee who works in both the Hardware department and the Software department.
(ii) Find the managerids of managers who manage only departments with budget greater than Rs. 1 lakhs.
(iii) Find the enames of managers who manage the departments with the largest budgets.
(iv)  If a manager manages more than one department, he or she controls the sum of all the budgets for those departments. Find the managerids of managers who control more than Rs. 5 lakhs.
(v) Find the managerids of managers who control the largest amounts.
(vi) Find the enames of managers who manages only departments with budgets larger than Rs. 1 lakhs, but at least one department with budget less than Rs. 5 lakhs. (16)
(b) (i) Why do we need normalization? Is normalization preferred in today’s scenario? (4)
(ii) Explain the different normal forms with an example. (12)

13. (a) (i) Explain about transaction properties. (8)
(ii) Explain the SQL commands that support transaction with an example. (8)
(b) (i) Describe about different types of recovery techniques. (10)
(ii) Describe about security of statistical databases. (6)

14. (a) Explain about different types of hashing and collision resolution techniques. (16)
(b) Write short notes on;
          (i) Sequential file operation. (8)
          (ii) B+ tree. (8)

15. (a) Write short notes on the following databases;
          (i) Temporal databases. (8)
          (ii) Spatial databases. (8)
(b) (i) Write a comparison between ODBMS and RDBMS. (8)
(ii) Write a short note on XML. (8)


Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents