Get premium membership and access revision papers, questions with answers as well as video lessons.
Got a question or eager to learn? Discover limitless learning on WhatsApp now -
Start Now!
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]
More Question Papers
Popular Exams
Return to Question Papers