GUG/W/18/836 1 P.T.O
Bachelor of Commerce (Computer Application)-II Third Semester Old
BCCA234 Database Management System Concepts Paper-IV
P. Pages 2 GUG/W/18/836
Time Three Hours Max. Marks 80

Notes 1. All questions are compulsory and carry equal marks.
2. Draw neat and labeled diagram and use supporting data wherever necessary.
3. Avoid vague answers and write specific answers related to questions.
1.
Either
What is Database? Explain the basic terminology of Data processing.
8
Explain different components of DBMS in detail.
8
OR
Explain three tire Architecture of DBMS in detail.
8
Who is Database Administrator? Explain responsibilities of DBA.
8
2.
Either
What is Relation? Explain Relational Database structure in detail.
8
Explain following:
Functional Dependency.
ii) Normal forms.
8
OR
What is Relational Algebra? Explain in detail.
8
Why Normalization is important? Explain it's importance in detail.
8
3.
Either
Explain following in detail:
MS-Access forms
ii) MS-Access Macros
8
Write a procedure to create employee table using MS-Access Wizard.
8
OR
*0646*
GUG/W/18/836 2
Explain following in detail:
Auto number field type
Date Time
8
What do you mean by editing table? Give the procedure to edit Records (Use Sample table) 8
4.
Either
What do you mean by Data Filtering? Explain different types of Queries.
8
Explain how to specify criteria in Queries in detail.
8
OR
Explain the procedure to create Reports in detail by giving suitable example.
8
Write a procedure to filter the Database using multiple criteria.
8
5.
Solve all the questions.
Write note on Data Abstraction.
4
Write note on Data Model.
4
Discuss in short about Hyperlink.
4
Write a note about macros.
4