Database Management System - BBA/BBA(TTM) 108 - 2nd sem - end term - 2005

Time : 3 Hours Maximum Marks : 75
Note: Attempt any five questions

Q.1 (a) Compare and contrast File based data management systems Write SQL constructs to perform the following: -
and DBMS. (5)
(a) Insert the information that Part X with Part_no 23 is supplied
(b) Describe briefly the structure (block level) of a DBMS. (5)
by the Supplier named “Ms. XYZ Co.”; you may assume that
(c) Describe the functions performed by the different classes of
the Supplier information 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 5 types of vehicles and within each type of vehicles it has three different

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

Q.4 Define the 1s t , 2nd and 3rd normal forms and illustrate with example their usage in database design. (15)

Q.5 (a) What are the data types supported by MS -Access. (6)
(b)Describe the difference between designing a database table in the design view, using the wizard and by entering values. (9)

Q.6 Given the following 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 following SQL constructs: - (15)
variants. A vehicle is characterized by its seating capacity, its
(a) Select
(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 between entity, attribute and relationships
number.