GUG/W/18/10762 1 P.T.O
Master of Computer Management (M.C.M.- (CBCS Pattern) Second Semester CBCS
PCMCMT201 Paper-I DBMS Concept
P. Pages 2 GUG/W/18/10762
Time Three Hours Max. Marks 80

Notes 1. All questions are compulsory and carry equal marks.
2. Draw neat and labelled diagram wherever necessary.
3. Avoid vague answers and write answers relevant and specific to questions.
1.
EITHER.

What is Database? Explain database approach in detail?
8

Write a detail note on Data processing?
OR
8

What is data Independence? Explain levels of Data Independence?
8

Give the differences between traditional and DBMS Environment.
8
2.
EITHER.

Explain E-R model in detail.
8

Discuss various Relational Algebra operations.
OR
8

Write a detail note on functional dependency.
8

Explain third normal form with suitable example.
8
3.
EITHER.

What is primary key? Write a steps to add and remove primary key. Discuss editing table in MS-Access.
8

Explain Elements of MS-Access database.
OR
8

Write a note on
FORM ii) REFORTS.
8

Write a note on MS-Access. Explain designing and creation of Database in MS-Access.
8
*2918*
GUG/W/18/10762 2
4.
EITHER.

How to create simple query. Write a procedure to create and non query in design view.
8

Explain various calculation function in MS-Access. How to perform calculation in MS-Access.
OR
8

Explain Relational and logical operators for filtering data in MS-Access.
8

What do you mean by Report? Write a procedure to create Report in MS-Access.
8
5.
Solve on the questions.
What are the Role of DBA.
4
Explain types of Relationship.
4
Differentiate between DBMS and RDBMS.
4
Explain aggregate functions in MS-Access.
4