GUG/W/18/11735 1 P.T.O
Post Graduate Diploma in Computer Commercial Applications (PGDCCA-CBCS)
Second Semester CBCS
PCCCAT201 Paper-I DBMS Concepts
P. Pages 2 GUG/W/18/11735
Time Three Hours Max. Marks 80

Notes 1. All questions are compulsory and carry equal marks.
2. Draw neat and labelled diagram and use supporting data wherever necessary.
3. Avoid vague answers and write specific answer related to questions.
1.
Either
What are the various cost and risk associated with database approach?
8
Explain DBMS Environment in detail.
8
OR
List the advantages and disadvantages of 3-tire architecture.
8
Explain the types of database in detail.
8
2.
Either
Draw an E-R diagram for Library Management system.
8
Explain First normal form with suitable example.
8
OR
Explain functional dependency in detail.
8
Explain Hierarchical database structure in detail.
8
3.
Either
Write and explain the characteristics and features of MS-Access in brief.
8
How to create a Database from a blank database? Explain creating a database from a template.
8
OR
Explain the concept of MACROS in brief.
8
Write a procedure to create a Table using calculated field data type.
8
*3857*
GUG/W/18/11735 2
4.
Either
What is the Purpose of Query? Explain in brief with suitable example.
8
Write and explain the steps to create Report by using Wizard.
8
OR
Write a note on
Specifying Criteria Queries
ii) Parameter Query
8
Write and explain the procedure to create form by using wizard with suitable example.
8
5.
Solve all the questions.
Write note on Database Approach.
4
Explain Relational Database structure.
4
What is the purpose of Yes/No field? Explain its importance with suitable example.
4
Write note on Relational operator.
4