EGS 2309: GIS DATABASE SYSTEMS Past Paper

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]

(Visited 186 times, 1 visits today)
Share this:

Written by