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
M.C.A
DEGREE EXAMINATION, JANUARY 2014
MC
7103 – DATABASE MANAGEMENT SYSTEMS
(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)
Or
(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)
Or
(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)
Or
(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)
Or
(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)
Or
(b) (i) Write a
comparison between ODBMS and RDBMS. (8)
(ii) Write a short
note on XML. (8)
_____________________