Download Model question papers & previous years question papers

Posted Date: 25 Nov 2016      Posted By:: panchami    Member Level: Gold  Points: 3 (Rs. 2)

2016 University of Kerala Politics B.B.A Decision support system third semester BBA examination Question paper



Course:   University/board:

Are you looking for the old question paper from BBA. Here is the previous year question papers from BBA. This is the original question paper of decision support system third semester BBA examination conducted at Kerala university. Feel free to download the question papers from here and use it to prepare for your upcoming exams.



THIRD SEMESTER BBA DEGREE EXAMINATION, OCTOBER 2016
06.205: DECISION SUPPORT SYSTEM

Time : 3 Hours
Max. Marks : 100

PART A

Answer all questions. Each carries 4 marks.

1. What is data model? What are the classifications of data models?

2. What is DML? Give example.

3. Differentiate between weak and strong entity with an example.

4. What are the fundamental operations in relational algebra? Give example.

5. How is a relation defined in SQL? Give an example.

6. Define 3 NF with the help of an example.

7. Explain the use of views.

8. What are the properties of transaction?

9. Explain the different locking methods.

10. What is the difference between data security and integrity?

[10 x 4 = 40 Marks]

PART B

Answer any two questions from each Module. Each question carries equal marks.

Module I

11.
(a) Differentiate between B tree and B+ tree with an example.
(b) Example various classifications of database users.

12. (a) Construct the E-R diagram to represent a super market with the following entities:
i) customer
ii) product
iii) bill
iv) stock
v) purchase
(b) Explain briefly the three levels of architecture of DBMS.


13. (a) Explain the distinction among the terms primary key, candidate key and super key with example.
(b) Explain the reduction of an E-R schema to tables considering the example of an examination database.

Module II

14.
(a) Write down the following queries in SQL.
A database consists of tables
Book (bno, btitle, ano, price, dno)
Author (ano, aname, address)
Dept (dno, dname)

i) How many books are there in Mathematics department?
ii) Who is the author of 'Database System Concept'?
iii) Which is the costly book?
iv) How many books are written by 'Korth'?

(b) Explain the entity rules in relational model with the help of an example.

15.
(a) A table with the following field was created for billing of customers in a hotel. Customer's name, address, date of arrival, room number, room type, room rent, number of local calls made, date of call, rate per calls (for each date), cloths given for laundry, date, charge per cloth(for each date).
What is wrong with this design? Identify errors and correct the design using normalization process.
(b) Differentiate between GRANT and REVOKE.


16. (a) What is dependency preservation property of decomposition? Why is it important?
(b) Explain multi value dependencies and 4NF. Give example.
Module III

17. (a) Explain how a transaction is managed in SQL..
(b) Explain the difference between serial schedule and serializable schedule.

18. (a) Assume that the Airline reservation system is implemented using RDBMS. What concurrency control measures would you take in order to avoid concurrency related problems in the above system? Also suggest two measures to avoid deadlock in this systems.
(b) Explain time stamp ordering protocol with an example.
19. (a) Explain the concept of distributed database. Give an example.

(b) How check points help in database recovery?

[6 x 10 = 60 Marks]





Return to question paper search

Next Question Paper: Mahatma Gandhi University Commerce B.Com B.Sc. (computer science) degree: client/server computing

Previous Question Paper: The Directorate of Distance Education Previous Year Master of Science Examination September and October, 2015 Mathematics, Physics, Mathematical Methods and Classical Mechanics

Related Question Papers:


Categories


Submit Previous Years University Question Papers and make money from adsense revenue sharing program

Are you preparing for a university examination? Download model question papers and practise before you write the exam.


Awards & Gifts
Top Contributors
TodayLast 7 Daysmore...

 
ISC Technologies, Kochi - India. © All Rights Reserved.