Karnataka State Open University (KSOU) 2011 B.C.A Computer Application- Dbms Lab - Question Paper
Ill Semester B.C.A. Examination, August 2011 DBMS LAB
Time : 3 Hours Max. Marks : 75
Answer both two questions. (1x35=35)
1. Consider the Insurance database given below. The primary keys are underlined and the data types are specified. PERSON (DRIVER - ID # : string, name : string, address : strong) CAR (Regno : string, model : string, year : int) ACCIDENT (repcrt-number: int, date : date, location: string) OWNS (driver-id# : string, Regno: string) PARTICIPATED (driver - id # : string, Regno: string, report - number : int, damage amount: int)
i) Create the above tables by properly specifying the primary keys and the foreign keys.
ii) Enter atleast five tuples for each relation.
iii) Demonstrate how you
a) Update the damage amount for the car with a specific Regno in the accident with report number 12 to 25000.
b) Add a new accident to the database.
iv) Find the total number of people who owned cars that were involved in accidents in 2002.'
v) Find the number of accidents in which cars belonging to a specific model were involved,
vi) Generation of suitable reports.
vii) Create suitable front end for querying and displaying the results.
2. Consider the following relations for an order processing database application in
a company. (1x40=40)
a) Create the above tables by properly specifying the primary keys and the foreign keys.
b) Enter atleast five tupels for each relation.
c) Product a listing : CUSTNAME, tfoforders, AVG_ORDER_AMT, where the middle column is the total average order amount for that customer.
d) List the order # for orders that were shipped from all the warehouses that the company has in a specific city.
e) Demonstrate how the delete item# 10 from the ITEM table and make that field null in the ORDERJTEM table.
f) Generation of suitable reports.
g) Create suitable front end for querying and displaying the results.
|
Attachment: |
| Earning: Approval pending. |
