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

Ins 211: Database Construction And Management Question Paper

Ins 211: Database Construction And Management

Course:Bachelor Of Science In Information Sciences

Institution: Moi University question papers

Exam Year:2014

MOI UNIVERSITY
OFFICE OF THE CHIEF ACADEMIC OFFICER
UNIVERSITY EXAMINATIONS
2013/2014 ACADEMIC YEAR
SECOND YEAR SECOND SEMESTER EXAMINATION
FOR THE DEGREE OF
BACHELOR OF SCIENCE
IN
INFORMATION SCIENCES
COURSE CODE: INS 211
COURSE TITLE: DATABASE CONSTRUCTION AND MANAGEMENT
DATE: 12TH SEPTEMBER, 2014 TIME: 9.00 A.M. – 11.15 A.M.

INSTRUCTION TO CANDIDATES
• SEE INSIDE

THIS PAPER CONSISTS OF (2) PRINTED PAGES PLEASE TURN OVER
MOI UNIVERSITY
SCHOOL OF INFORMATION SCIENCES
DEPARTMENT OF INFORMATION TECHNOLOGY
SECOND SEMESTER 2013/2014 ACADEMIC YEAR EXAMINATIONS
COURSE CODE: INS 211
COURSE TITLE: DATABASE CONSTRUCTION AND MANAGEMENT TIME: 2 Hrs 15 Mins
==============================================================================
INSTRUCTIONS TO CANDIDATES:
• Answer question 1 and any other TWO questions

1.
a. Explain why you would chose a database system instead of simply storing data in operating system files? When would it make sense not to use a database system? [10 marks]
b. What is the difference between logical and physical data independence? Why is it important? [5 marks]
c. Give reasons on when and why to use databases. [5 marks]
d. Explain the difference between external, internal and conceptual schemas. [6 marks]
e. Describe the difference in meaning between the terms relation and relation schema. [4 marks]
2. Please define the following Database Management Concepts:
a. Attribute [20 marks]
b. Entity
c. Primary key
d. Foreign key
e. Multi-valued attribute
f. Relationship
g. Cardinality
h. Data definition language
i. Binary
j. Normalization
3.
a. What is the Cardinality Ratio, as it relates to relations? [4 marks]
b. Using specific examples, clearly explain the meaning of the following Cardinality Ratios:
i. One-to-One
ii. One-to-Many
iii. Many-to-Many [6 marks]
c. Discuss the importance of participation construction in a database. [10 marks]
4. The three main database models (hierarchical, network and relational) provide structural layout for data. In this context:
a. Clearly explain the limitations of the relational database model. [6 marks]
b. Compare and contrast the Network and Hierarchical models. [6 marks]
c. Discuss the role and selection of a key in a relation. [8 marks]
5.
a. Describe FIVE main functions of a database administrator. [15 marks]
b. Consider a bank that has a collection of sites, each running a database system. Suppose the only way the databases interact is by electronic transfer of money between one another, would such a system qualify as a distributed database? Why? [5 marks]

Ins 211: Database Construction And Management Question Paper

More Question Papers

Popular Exams

Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams