Download Advanced Database Management System Examinations and more Exams Software Engineering in PDF only on Docsity!
Page 1 of 5
Bsc(Hons) Software Engineering
Cohort: BSE/11/FT & BSE/10B/FT
Examinations for 2012 - 2013 / Semester 2
MODULE: ADVANCED DATABASE MANAGEMENT SYSTEM
MODULE CODE: DBT
Duration: 2 ½ Hours
Instructions to Candidates:
- Answer ALL questions.
- Questions may be answered in any order but your answers must show the question number clearly.
- Always start a new question on a fresh page.
- All questions carry equal marks.
- Total marks 100.
This question paper contains 5 questions and 5 pages.
Page 2 of 5
ANSWER ALL QUESTIONS
QUESTION 1: (20 MARKS)
(a) Differentiate between database security and database integrity (2 Marks)
(b) Database security involves measures to avoid loss of privacy and loss of confidentiality. Explain what is meant by the above terms. (4 Marks) (c) In the context of database security explain how the following database features help to enforce security in the database system: (i) Authorisation (2 Marks) (ii) Access Control (2 Marks) (iii) Views (2 Marks) (d) Differentiate between a Discretionary Access Control and a Mandatory Access Control. Which one is more rigid to the modification of the privilege assigned to users? (5 Marks) (e) Assuming that the following view exist in your database schema:
CREATE VIEW View1 AS
SELECT S_id, S_name, Status, City
FROM Suppliers WHERE City = ‘Paris’
Write an appropriate SQL Code to give access right to two users Mark and Spencer so that they can Insert, Update, Delete and Retrieve all the data in the above view. Put a control so that both Mark and Spencer can only update the supplier name and the status of the suppliers. (3 Marks)
Page 4 of 5
QUESTION 4: (20 MARKS)
(a) What are decision support systems, and what role do they play in the
business environment?
(2 Marks)
(b) Data mining is a knowledge discovery process of automated extraction of
hidden predictive information from large databases. Describe the FOUR main steps involved in the data mining process. (4 Marks)
(c) There are various data mining techniques dealing with different types of
problems. Give example of any THREE techniques that could be used in a supermarket. (6 Marks)
(d) To better exploit data mining what are the pre-requisites for a data warehouse?
(4 Marks)
(e) Data mining being relatively a new technology, what advantages would an Insurance company achieved for implementing such a technique? Provide relevant examples
(4 marks)
Page 5 of 5
QUESTION 5: (20 MARKS)
(a) Define the term Deductive Database System.
(2 Marks)
(b) Use the following example of a logical program containing 12 clauses, to
illustrate how additional information may be deduced by applying rules to the known facts:
provide answers (values for x, y where appropriate to the following queries. For each answer, clearly list all the clauses used in the deduction process. For this question, assume that every person’s name is unique. (i) ?:- parent(sanjay, vijay) (ii) ?:- x:father(x,y) (iii) ?:- mother(rubina,x),father(ravi,x) (iv) ?:-mother(rubina,x),father(ajay,x) (v) ?:-grandparent(x,vijay) (10 Marks)
(c) A deductive database system has strong links with first order logic, logic programming, theorem proving and relational database theory. Describe the difference between a Deductive Database Systems and Logic Programming. (4 Marks)
(d) Describe briefly the TWO approaches of developing deductive database systems. (4 Marks)
END OF QUESTION PAPER
grandparent(x,z) :- parent(x,y), parent(y,z) (1)
ancestor(x,z) :- ancestor (x,y) ,parent(y,z) (2) ancestor(x,y) :- parent(x,y) (3)
parent(x,y) :- mother(x,y) (4) parent(x,y) :- father(x,y) (5)
father(ravi, gemma) (6) father(sanjay,vijay) (7) father(ajay, sanjay) (8)
mother(rubina, sanjay) (9) mother(jane, rubina) (10) mother(liz, fred) (11) mother(rubina,vijay) (12)
