W1-2-60-1-6
JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY
University Examinations 2016/2017
YEAR III SEMESTER II EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN GIS
EGS 2309: GIS DATABASE SYSTEMS
DATE: DECEMBER, 2016 TIME: 2 HOURS
INSTRUCTIONS: Answer Question ONE and Any Other TWO Questions.
Question One – 30 Marks
a) Define the following terminologies as used in GIS database. [3 marks]
i. Relation
ii. Attribute
iii. Domain
iv. Tuple
v. Degree
vi. Cardinality
b) Explain how database is said to be shared, description of data and logically related. [6 marks]
c) Describe the following acronyms. [6 marks]
d) Highlight, with example, GIS data. [6 marks]
e) Assuming you are mandated to set up a database for a private enterprise briefly highlight the levels which should
Question Two – 20 Marks
a) Define normalization . [2 marks]
b) Describe the process of normalization. [3 marks]
c) Highlight main normalization forms. [15 marks]
Question Three – 20 Marks
a) What is a model? [2 marks]
b) Briefly discuss principal types of data models. [18 marks]
Question Four – 20 Marks
a) Difference between relationship type and relationship. [2 marks]
b) What do you understand by the term constraint as used in RDBMS? [2 marks]
c) Briefly highlight two main types of constraints. [6 marks]
d) Describe main GIS data formats, giving examples where necessary. [10 marks]
Question Five – 20 Marks
a) What do you understand by DBMS? [2 marks]
b) Highlight functionalities, merits and demerits of DBMS. [18 marks]
