Twitter Facebook Delicious Digg Stumbleupon Favorites More

Monday, 10 April 2017

IPU MCA Semester 2 - Database Management System - End Term Paper (2016)

END TERM EXAMINATION

SECOND SEMESTER |MCA| MAY- JUNE 2016

Paper Code: MCA-108

Subject: Database Management System

IPU MCA Semester 2 - Database Management System - End Term Paper (2016)

Time: 3 Hours Maximum Marks: 75

Note: Attempt any five questions.


Q1:
(a) Define database. What are the characteristics of a modern DBMS? What are the categories of a modern DBMS?

(b) 'Design of DBMS depends on its architecture.' Justify your answer. Which is the most widely used architecture to design DBMS? Write about 3-tier architecture of DBMS and its different levels?


Q2:
(a) On which notation ER model is based on? Explain ER model with examples. What are various types of attributes?

(b) What are the main highlights of relational model? What are tables and views in a relation?




Q3:
(a) Differentiate between physical and logical database schema.

(b) What is data independence? Differentiate between logical and physical data independence?


Q4:
(a) Write briefly about:
Super key,
Candidate key,
Primary key,
Cardinality,
Degree of relationship.

(b) Differentiate between
Generalization and Specialization
Domain constraint and Referential Integrity constraint


Q5:
(a) Write 12 rules of Dr E.F. Codd for relational DBMS.

(b) Write the various fundamental operations of relational algebra and calculus.


Q6:
(a) What are the steps in mapping process? Explain mapping weak entity sets and mapping hierarchical entities.

(b) Write the various set of SQL commands to define database schema.


Q7:
(a) Define functional dependency. What are Armstrong's axioms that when applied repeatedly, generates a closure of functional dependencies.

(b) Differentiate between 1NF and 2NF. What are the partial and transitive dependency?


Q8: Write a short note on (any two)
(a) Oracle architecture

(b) Cursors and Triggers

(c) Concurrency control and recovery.



Share:

0 comments:

Post a Comment

BCE-Hacks Notes

BCE-Hacks Notes
Chemical Engineering Notes

Maths Resources

Maths Resources
Maths Resources

Buy Books

Buy Books
Buy Books

Geography Quiz

Geography Quiz
Geography Quiz

NodeJS Tutorial

NodeJS Tutorial
Developer-Bytes

History MCQs

History MCQs
History Quiz For Competitive exams

Categories

Popular Posts

GooglePlus

Recent Posts

Unordered List

Express Print Zone

Eduvictors Quizzes

Online Quizzes, Study notes for CBSE Class 6 - 12

Text Widget

Compete4Exams

Study notes for Competitive Exams

Developer Bytes

Developer Bytes
Developer Bytes
Powered by Blogger.

Blogger Tutorials

Blogger Templates

Sample Text

Copyright © IP University Musings BCA, MCA, BBA, MBA, BTech Question Papers and Study Notes | Powered by Blogger
Design by SimpleWpThemes | Blogger Theme by NewBloggerThemes.com