BACHELOR OF COMPUTER APPLICATIONS

 
 COOLB.C.A QUESTION  PAPER  PATTERNCOOL
  

 	PAPER MODEL IS SAME FOR 1st , 2nd AND 3rd YEAR OF B.C.A. HERE EACH
PAPER WILL BE OF 100 MARKS.IN EXAMINATION TOTALLY THERE WILL BE 2 SECTIONS.
IN THIS SECTION-1 HOLDS 20 MARKS AND SECTION-2  80 MARKS . IN SECTION-1 
THERE WILL BE 10 QUESTIONS OF 2 MARKS EACH AND IN SECTION-2 5 QUESTIONS OF
16 MARKS EACH WITH INTERNAL CHOICE.

EXAMPLE MODEL PAPER:-



THREE YEAR BACHELOR OF COMPUTER APLLICATIONS DEGREE
EXAMINATION,SEPTEMBER-1999
(FIRST YEAR EXAMINATION)
PAPER 5 - INFORMATION TECHNOLOGY
(WITH EFFECT FROM SEPTEMBER 1999)
[ENGLISH VERSION ONLY] 

TIME : THREE HOURS					MAXIMUM : 100 MARKS


SECTION - A
QUESTION 1  IS COMPULSORY
EACH QUESTION CARRIES 2 MARKS(10*2=20)


1.	a. DEFINE DATA BASE ?
	b. GIVE ANY FOUR EXAMPLES OF HIERARCHICAL DATA MODELS ?
	c. DEFINE THIRD NORMAL FORM ?
	d. DEFINE INTEGRITY ?
	e. DEFINE TRANSACION STATE ?
	f. WHAT IS ATOMICITY ?
	g. WHAT IS RELATIONAL ALGEBRA ?
	h. DEFINE MANY TO MANY ASSOCIATION ?
	i. WHAT IS A DATA BASE TRIGGER ?
	j. GIVE DIFFERENT FORMATS OF USING UNDOING ACTIONS IN SQL?



SECTION - B
ANSWER ONE FULL QUESTION FROM EACH UNIT
EACH QUESTION CARRIES 16 MARKS(16*5=80)

UNIT - I

2. WHAT ARE THE TYPES OF DATA MODEL ?
   EXPLAIN THEM WITH SUITABLE EXAMPLES ?			(16)
		OR
3.	a. EXPLAIN THE KEY FEATURES OF DATA MANIPULATION ?
	   LANGUAGE OF IDMS TO ACCESS NETWORK DATA MODEL ?	(8)
   	b. DISCUSS THE RESPONSIBILITIES OF DBA ?		(8)


UNIT - II

4. ASSUME ANY TWO REPORTS OF A TICKET BOOKING SYSTEM		(16)
   OF A TRANSPORT CORPORATION ?
	a. NORMALIZE EACH OF THEM UPTO THIRD NORMAL FORM ?
	b. DESIGN A CONSEPTUAL DATA MODEL USING THESE 3 NFS ?
		OR
5.	a. DISCUSS THE MEASURES OF QUERY COST ?		(16)
	b. EXPLAIN DIFFERENT INTEGRITY CONSTRAINTS ?


UNIT - III

6.	a. WHAT IS DEAD LOCK ? HOW WILL YOU RESOLVE IT ?	(10)
	b. EXPLAIN DATA BASE RECOVERY SYSTEM ?		(6)
		OR
7.	a. EXPLAIN THE CONCEPT OF PARALLEL DATABASE ?		(6)
	b. LIST AND EXPLAIN THE COMPONENTS OF DISTRIBUTED DATA
	   PROCESSING WITH A SUITABLE DIAGRAM ?		(10)


UNIT - IV

8. LIST AND EXPLAIN DIFFERENT COMMANDS OF RELATIONAL ALGEBRA ?	(16)
		OR
9. DEVELOP A FOXPRO PROGRAM TO PRINT A TYPICAL MARKS SHEETS
   OF STUDENTS OF A PROGRAMME ?				(16)


UNIT - V

10. REDUCE THE ORDER FORM 0(O#,C#,C-NAME,ADDRESS,P#,
   DES,UP,QTY)TO MORE DESIRABLE STRUCTURE .
   WHERE
   O#  -  ORDER NUMBER
   C#  -  CUSTOMER NUMBER
   C-NAME   -  CUSTOMER NAME
   ADDRESS  -  CUSTOMER ADDRESS
   P#       -  PRODUCT NUMBER
   DES      -  PRODUCT DESCRIPTION
   UP       -  UNIT PRICE OF A PRODUCT
   QTY      -  QUANTY OF ORDER
   WRITE SQL QUERAIN TO ANSWER THE FOLLOWING -
	a. LIST ALL PRODUCTS WITH QTY > 500 ?
	b. LIST ALL PRODUCTS FOR A GIVEN CUSTOMER ?		(16)
		OR
11. WHAT ARE THE TYPES OF REPORTS THAT ARE POSSIBLE IN SQL ?
    ILLUSTRATE THEM WITH EXAMPLES ? 				(16)


home page