Get premium membership and access revision papers, questions with answers as well as video lessons.

Database Systems Design And Development Question Paper

Database Systems Design And Development

Course:Bachelor Of Science In Information Technology

Institution: Masinde Muliro University Of Science And Technology question papers

Exam Year:2010

EXAMINATION FOR THE DEGREE OF BACHELOR OF
SCIENCE IN INFORMATION TECHNOLOGY
BIT 2104: DATABASE SYSTEMS DESIGN AND DEVELOPMENT
DATE: APRIL 2010 TIME: 2 HOURS
INSTRUCTIONS: Answer question ONE and any other TWO questions
QUESTION ONE
a) Define the following terms
i) Candidate key (2 Marks)
ii)Primary key (2 Marks)
iii) Function model (2 Marks)
iv)Data mining (2 Marks)
b) Object oriented technology is considered to be a major boost in software and database
development. Analyze the following concepts using appropriate examples indicating their
contribution to database development.
i) Classification (2 Marks)
ii)Inheritance (2 Marks)
iii)Specialization (2 Marks)
iv)Generalization (2 Marks)
c) Elaborate on the following rules as explained under Codd's Twelve Rules of relational databases
i) Information Rule (2 Marks)
ii) Guaranteed Access Rule (2 Marks)
iii) Physical Data Independence (2 Marks)
iv) Logical Data Independence (2 Marks)
d) Rewrite the following object query language into the standard SQL (4 Marks)
Query q = new Query (
Employee.class, “manager.salary < salary”);
Collection result = q.select(employees);
e) Outline the two areas of the Object Database Manifesto (2 Marks)
QUESTION TWO
a) Object modeling plays a vital role in analysis and design of databases. As a consultant in databases,
which models would you recommend to apply in the following functions?
i) User Interaction with the database system (2 Marks)
ii) Object to object interaction in object oriented databases (2 Marks)
iii) State transition of objects (2 Marks)
iv) Physical architecture and the deployment of database systems (2 Marks)
b) The first step in implementing a database system is to find out what is required. What kind of a database is needed for the organization, what is the volume of the data that must be handled on a day-to-day basis and how much data is to be stored in the master files. As a database analyst,examine the objectives of the requirement phase in database development. (8 Marks)
c) Highlight the relationship between Data integrity and Database normalization (4 Marks)
QUESTION THREE
a) Using illustrations, describe the data mining process of a large organization of your own choice
(8 Marks)
b) Assuming that you have to work with an Oracle database, using a data model that somebody else
wrote. Maybe you're extending the data model or building an application that references it and there is only one major problem: whoever created the original data model left without writing documentation. Explain how you would reverse engineer the data model to unearth the following elements.
i) Table index (3 Marks)
ii)Table views (3 Marks)
c) Business processes can be analyzed and designed using functional models. Describe the role of
functional decomposition in a database environment. (6 Marks)
QUESTION FOUR
a) Write an object query that will find the titles of all publications by "Moira C. Norrie" with more
than one author that were published after 1995 , in tables named Authors a and a.authors p
(5 Marks)
b) Explain the three different types of relationships that are used in modeling relational databases
(6 Marks)
c) Describe the three types of database models highlighting on their advantages and disadvantages
(9 Marks)
QUESTION FIVE
a) OM Data Model is an extended Entity-Relationship model for object-oriented data management.
Outline the distinguishing features of this model (5 Marks)
b) Examine two advantages and three disadvantages of object relational databases (5 Marks)
c) In your own opinion which transparencies need to implemented in a distributed database to make it
appear as a single system (6 Marks)
d) Explain with good reasons the contribution of distributed database systems to organisations
(4 Marks)

Database Systems Design And Development Question Paper

More Question Papers

Popular Exams

Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams