DBMS (15cs53) Module1 Question Bank for 5th semester Students

DATA BASE MANAGEMENT SYSTEM

QUESTION BANK

Sl.No.	Question Module-1
1	Design an ER Diagram for Company Database
2	Design an ER Diagram for Banking Database
3	Design an ER Diagram for any real world application
4	Classify and compare the advantages of DBMS which will overcome disadvantages of traditional file processing.
5	Determine the various level of abstraction in DBMS.Compare and Contrast physical data independence and logical data independence
6	Determine the role of component module in database architecture.
7	Inspect and identify different categories of data model
8	Identify and list out the characteristics of data base approach.
9	List out and analyse the importance in main phases of Database Design
10	Elaborate with example the role of structural constraints in Relationship type.
11	List out ER Notation and interpret the role of each notation
12	Classify and categories the role of different actor on scene.
13.	Demonstrate and classify different types of DBMS.
14	Demonstrate and classify different types of DBMS Languages.
15.	Analyze ,Is it necessary to use role names in description of Relationship type if yes/no Justify?
16	Define a) Entity type b)Entity set c)Relationship type d)Relationship instance e)Degree of Relationship f)Relationship set g)weak entity type h)partial key i)Regular Entity type j)Schema  i) Data Abstraction ii)Data model iii) Data Base snap shot iv) Instances v)schema vi)Valid State vii)Intension of schema viii)Extension of schema

UNIT 1: INTRODUCTION

Q1. Define Data Base Management system? Explain briefly various characteristics of Data Base Approach?

Q2.What is Data Base? Explain briefly differences between traditional file processing  and Data Base Management?

Q3.Explain briefly various roles of Actor on Scene for Data Base approach? Also Explain various categories for worker behind scenes?

Q4.Explain briefly advantages of Data Base Approach?

Q5.Write a short note on i)Providing persistant storage for program object?

                                        ii)Providing storage structure for Efficient query processing?

                                   

Q6.Explain various additional implication of using Data Base Approach that can help most of organization?

Q7.Explain various application of DBMS ? OR

    Write a short note on Extending Database capability for New Application?

  Also Explain when not to use DBMS?

Q8.Define Data model, Also explain briefly various categories of Data model?

Q9.Define i) Data Abstraction ii)Data model iii) Data Base snap shot iv) Instances v)schema

                  vi)Valid State vii)Intension of schema viii)Extension of schema

Q10.Explain briefly various levels of abstraction for DBMS?

 OR

Explain three schema Architecture and Data Independence?

Q11. Explain briefly Various Data Base Language?

Q12.Explain briefly interfaces provided by DBMS?

Q13.Explain Briefly typical component module of DBMS Environment?

OR

Explain briefly Architecture of DBMS?

Q14.Explain briefly classification of DBMS?

UNIT 2 QUESTION BANK

Q1.Define Entities and Attributes? Explain various types of Attribute with Examples?

Q2.Explain i)Key Attributes of an Entity Type with examples

                   ii)Values Set of Attributes  with examples

Q3.Define a) Entity type b)Entity set c)Relationship type d)Relationship instance e)Degree of Relationship f)Relationship set g)weak entity type h)partial key i)Regular Entity type

j)Schema

(Note :Define and provide examples for each of defination)

Q4.Explain i) Relationship as attribute with example

                   ii)Role name and Recursive Relationship with example

Q5.Explain constraints on Relationship type

                                  OR

      Explain structural constraints on Relationship?

Q6.Explain main phases of Data Base Design?

             OR

     Explain the role of a high model data model in database design?

Q7.List out notation used for ER Diagram ?Explain Refining of ER Design by providing ER      Diagram for company Data Base?

Q8.What is participation Role?Why it is necessary to use role names in description of Relationship type?

Q9.Draw an ER Diagram with minimum five entities for following

     1)University Data Base

     2)Air Line Data Base

     3)Hospital Data Base Management System

     4)Library Data Base Management System

     5)Bank Data Base Management System

     6)Movie Data Base Management System

     7)Shipping Movement Data Base Management System

     8)Company Data Base Management System

Q10.Explain in brief Relation Type of Degree Higher than Two.

Q11.Explain in brief specialisation and generalisation.