Ch. Charan Singh University 2008 B.C.A Computer Application Database Mangement Systems - Question Paper

(2068) Roll. No. ………………..
BCA (II Sem.)

3101
B.C.A Examination, Feb-2008
Database Management Systems
(BCA-203)

Time: Thre Maximum Marks: 75

Note: Attempt any 5 ques.. All ques. carry equal marks


1. (a)Discuss in brief jobs of Database Administrator.
(B)What is SQL? Which data models implement this language?

2. (a)Mention purpose of different symbols used in Entity-Relationship data models and explain different categories of attributes with example.
(b)Draw an E-R diagram to show relationship ranging from strong and weak entity sets and decrease this diagram into equivalent tables.

3. (a)State and example the entity and integrity rules.
(b)A relation 1st is defined as follows:
FIRST (S#, STATUS, CITY, P#, QTY),
Primary Key is (S#, P#),
STATUS is Functionally Dependent on CITY.
In which normal form is the relation. explain update anomalies and solution, so that, it can be put into more desirable normal form. Draw FD diagram for every stage.

4. Explain the DBMS. What is the main function of DBMS/ define its major components.

5. Write a SQL Query for the following:
(a)Find out if any client has ordered “Floppies 1.44 Drive” and print the client number, name to whom it was sold.
(b)Find out all the products that are not being sold from the product_master table, based on the products truly sold as shown in the sales_order_details table.

Table: - client_master product_master sales_order sales_order_details
Fields: - client_no pro_no order_no order_no
Name Item client_no pro_no
Sell_price

6. (a)What is distributed database? explain its advantages and various structures to implement it?
(b)What is constraint? Mention different kinds of constraints given ny Oracle and where these should be described i.e in applications or at server and why?

7. (a)Show that if a relation is in BCNF it is also in 3NF with the help of example.
(b)Explain why 1NF is acceptable for data processing applications?

8. Discuss in detail any 2 of the following:
(i)Physical and logical data independence (ii)Data Dictionary (iii)DATA Abstraction (iv)Integrity

9. Write short notes on any 3 of the following:
(i)Relational Model
(ii)Defense Mechanism
(iii)Network Model
(iv)Index File Organization
(v)BCNF

10. (a)Write a SQL Program that 1st insert a record in a’EMP’ table. Update the salaries of ‘Ram Kumar’ and ‘Raj Kumar’ to Rs. 3000 and Rs 3500. Then check to see that the total salary does not exceed 50,000/-. If the total salary is greater than 50,000/- then undo the updates made to the salaries of ‘Ram Kumar’ and ‘Raj Kumar’.
(b)The HRD Manager has decided to raise the salary for all employees in the department number 101 by 20%. Whenever any such raise is provided to employees, a record for the identical is maintains in the emp_raisr table. It includes the employee number, the date when the raise was provided and the true raise. Write a SQL Program to update the salary of every employee and insert a record in the emp_raise table.

EMP Table: Emp_no, Salary
Emp_Raise Table: Emp_no. Raise_Data.Actual_Raise_Amount

Earning:   Approval pending.