N A L A N D A O P E N U N I V E R S I T Y
Master of Computer Application Part-II
PAPER-XVIII
(Database Management Systems)
Annual Examination, 2016
Time 3 Hours. Full Marks 80
Answer any Five Questions.
All questions carry equal marks.
1. List the data models, used to structure the data in Database systems.
2. Compare the following
File-based system and DBMS
Logical and Physical Levels of DBMS
GROUP BY clause and HAVING clause in SQL.
3. Discuss the different process of authorisation permitted on database items with the help of
examples? Define Super key, Alternate key, and Primary key.
4. Define foreign key. Explain its significance. Using operators of relational algebra/SQL, perform
Queries for the relations given below
Supplier S_name, status, city)
Parts P_name, color, weight)
Supply Quantity)
Find the part code of the parts which are supplied by a supplier.
Find the part name of all the parts that are supplied by suppliers who are in "Mumbai".
5. Compare sequential file organization with Heap files organization. Discuss the advantages and
disadvantages of sequential file organization. What are the differences between BST-Tree and
B tree Indexes.
6. What is transaction in DBMS? Explain the ACID properties of transactions in Database system
with an example..
7. Explain Normalization. What are the rules of normalization? Justify "Any relation which is in
BCNF is in 3NF but converse is not true".
8. In SQL, what is the need of VIEW mechanism? How views differs from tables? Give an
example and the syntax required to create a view.
9. Explain Generalization and Specialization in an E-R diagram with the help of an example?
How would you map the following ER constructs into relations? Give suitable example.
Weak Entity
Generalization
Ternary Relationship.
10. Explain the following terms with proper examples
Equi Join
Data Replication
Entity Integrity Constraints.