Sikkim-Manipal University of Health Medical and Technological Sciences (SMUHMTS) 2009-2nd Sem M.C.A - ister - MC0067 - Database Management System - Assignment forfall session - Question Paper

August 2009
Master of Computer Application (MCA) – Semester 2
MC0067 – Database Management System
(DBMS and Oracle 9i) – four Credits
(Book ID: B0716 & B0717)
Assignment Set – one (40 Marks)

ans all ques. Each ques. Carries TEN Marks

Book ID: B0716
1. define the following:
Clustering
Indexing
provide suitable examples to demonstrate the above concepts.

2. discuss the subsequent with suitable examples:
Access Protection, User Accounts, and Database Audits
Discretionary Access Control
Role Based Access Control



Book ID: B0717
3. explain the subsequent with relevant examples:
a. Attributes
b. Entities
c. Keys
d. Weak entity kinds

4. explain the following:
a. Data Models, Schemas, and instances
b. Centralized and Client/Server architecture for DBMSs


August 2009
Master of Computer Application (MCA) – Semester 2
MC0067 – Database Management System
(DBMS and Oracle 9i) – four Credits
(Book ID: B0716 & B0717)
Assignment Set – two (40 Marks)

ans all ques. Each ques. Carries TEN Marks

Book ID: B0716
1. discuss the subsequent with respect to SQL and provide suitable examples:
a. Database Creation
b. Sorting
c. Built-in Functions
d. Joining Tables
e. Union

2. define the subsequent Association Rules:
a. Market-Basket Model, Support, and Confidence
b. Additional Considerations for Association Rules
c. Classification
d. Clustering

Book ID: B0717
3. define the Mapping of EER Model Constructs to Relations.
4. define the subsequent concepts with respect to file organization:
Buffering of Blocks
Operations on files
Files of unordered records (heap files)

Earning:   Approval pending.