Guru Gobind Singh Indraprastha Vishwavidyalaya 2005 B.B.A Database Management System - Question Paper

END-TERM exam
SECOND SEMESTER [BBA] - MAY 2005
Paper Code:BBA/BBA(TTM)108 Subject: Database Management System
Time : three Hours Maximum Marks : 75
Note: Attemp t any 5 ques.
Q.1 (a) Compare and contrast File based data management systems
Write SQL constructs to perform the following: -
and DBMS. (5)
(a) Insert the info that Part X with Part_no 23 is supplied
(b) define briefly the structure (block level) of a DBMS. (5)
by the Supplier named “Ms. XYZ Co.”; you may presume that
(c) define the functions performed by the various classes of
the Supplier info exists in the Supplier table.
users that may interact w ith a database system. (5)

Q.2 A firm is a manufacturer of Automobiles. It produces five kinds of

vehicles and within every kind of vehicles it has 3 various


Q.3 describe the subsequent terms: - (15)
(a) Super key
(b) Candidate key set
(c) Primary key
(d) Conceptual schema
(e) Tables and Views

Q.4 describe the 1s t , second and third normal forms and illustrate with example
their usage in database design. (15)

Q.5 (a) elaborate the data kinds supported by MS -Access. (6)
(b)Describe the difference ranging from designing a database table in the design view, using the wizard and by entering values. (9)

Q.6 provided the subsequent tables: - (15)
Site (Site_No, Address)
Project (Project_no, Description, Site_no)
Supplier (Supplier_id, Supplier_address, Supplier_name)
Parts(Supplier_id, Part_no, Part_name)
Project_Part(Project_id, Part_no)

Q.7 Illustrate the usage of the subsequent SQL constructs: - (15)
variants. A vehicle is characterized by its seating capacity, its
(a) choose
(b) Aggregate queries
(c) Nested queries
(d) Union
(e) Intersect

Q.8 Write short notes on any three: - (15)
may make and state the assumptions made while doing
(a) Mail merge the design
b) Functional dependency
(c) Indexes and their utility in query processing
(d) Difference ranging from entity, attribute and relationships
number.

Earning:   Approval pending.