Sikkim-Manipal University of Health Medical and Technological Sciences (SMUHMTS) 2008-1st Sem M.C.A Computer Assignment s - exam paper

Subject Code: MC0067
Subject Name: Database Management Systems
(DBMS and Oracle 9i)

Course Name: MCA Revamped
Semester: II Credits: 4
Marks: 40


[Book ID: B0716 & B0717] Answer All the ques.

1. discuss the concept of Relational Model with a real time example of a University System. [10 Marks]

2. define the subsequent with respect to Relational Databases:
• Database Creation [10 Marks]
• Sorting of Records within a table
• Built – in Functions
• Union

Note: All the above descriptions should be done by taking atleast 2 examples from outside (Other than the text book examples)

3. discuss the concept of ER to Relational Mapping taking a real time example with improper ER diagrams and corresponding tabular representations. [10 Marks]

4. discuss the following: [10 Marks]
• Concurrency Control Techniques
• Database Recovery Concepts

















Subject Code: MC0067
Subject Name: Database Management Systems
(DBMS and Oracle 9i)

Course Name: MCA Revamped
Semester: II Credits: 4
Marks: 40


[Book ID: B0716 & B0717] Answer All the ques.

1. Define the subsequent terms: [5 Marks]
• Indexing
• Clustered Index
• Non - Clustered Index
Also provide real world examples for every.

2. describe the subsequent terms: [5 Marks]
• Attributes
• Domains
• Relations
• Degree
• Cardinality
• Primary Key
• Tuples

3. discuss the following: [10 Marks]
• Three Level Architecture of a database system
• Services and Functions of Database Management System

4. define the subsequent with respect to database system environment: [10 Marks]
• DBMS Component Modules
• Database System Utilities
• Tools, Application Environments, and Communications Facilities

5. discuss the process of Mapping EER Model Constructs to Relations with a real time example. [Note: Do not use the SLM Examples] [10 Marks]

Earning:   Approval pending.