Download Model question papers & previous years question papers

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

2015 Decision support system third Semester exam 2015 Question paper

Course:   University/board:

Are you looking for the old question paper of MCA third semester degree examination of Decision support system? Here is the previous year question paper from Kerala university. This is the original question paper from the MCA third semester examination conducted in the year 2015. Feel free to download the question paper from here and it to prepare for your upcoming exam.


Time : 3 Hours
Max. Marks : 100


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]


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

Module I

(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

(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.

(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: TEE June 2015 Paper of MECE-004: Financial Institutions and Markets in Specialization of (Economics) from IGNOU

Previous Question Paper: Internet technology fifth semester BCA Examination conducted at Kerala university

Related Question Papers:


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.

Top Contributors
TodayLast 7 Daysmore...

Awards & Gifts

Online Members

Sanjeev Gupta
SpiderWorks Technologies Pvt Ltd, Kochi - India. © All Rights Reserved.