SIST/GI/M.
TECH/SEM-II/PGGI-201/2023-24
TECHNOLOGY,WEST
MAULANAABUL KALAM AZAD UNIVERSITY OF
BENGAL (FORMERLY WBUT)
Schoolof Information Science and Technology
Sciences
Department of Geoinformatics and Spatial
ENDSEMESTER EXAMINATION
AUG -2024
PAPERCODE:PGGI 201
PAPER NAME: Spatial Data Modeling
SEMESTER: II
PROGRAM NAME: M.TECH. IN GEOINFORMATICS Full Marks : 70
Time:3 Hours ..****....
The figures in the margin indicate full marks.
practicable.
Candidates are required to give their answers in their own words as far as
GROUP A ......
(Multiple Choice Type Questions)
1 Choose the correct alternatives of the following 10 x1= 10
. .. ..... ..... . ....... .............. .
MARKS CO PO BL
3 1,2,3
i) The dimension of polygonal geometry types is
a. 6. 2
C. d.
Which one is an editable service? 1, 2,3
ii)
a. WFS b. WMS
** ****** * ***... ...
C. WCS d None of the above
The converts a user query into instructions the DBMS
ii) 1 1 l,2,3
can process efficiently
memory manager b. query processor .....
C. transaction manager. d none of the above
.....
iv) .shp is an example of 1,2,3 2
data model b. map
C. both a. and b. none
.. .........
V) The number identifies the spatial reference systemn of a geometry. 1 1,2,3
EPSG b. SRID ..........
C. SRS none
ldentity, Intersect, Symmetrical Difference, Union etc. are examples of
1 4
analysis. 12,3 4
a. extraction b. overlay
C. proximity d. statistical
Page 1 of4
S I S T / G I / M . T E C H . / S E M - I / P G G I - 2 0 1 / 2 0 2 3 - 2 4
architecture.
GIS compared to a single-tier
Write short notes on any two of
the following:
GeoJSON
2.5 *
Shapefile
1 1,2,3 3 4.a.
BIL
BIP
OR
spatial data.
4.b. Write a note on components of
associated figure?
topological error is depicted by the
What kind of b overshoot
GROUP-C
dangle none
C. sliver polygon (Long Answer Type Questions )
structures 2 1,2,3 5
command used to define data Answer the following
is a type of SQL MAI
vi) and modify data. 2
architecture in DBMS?
DML (Data Manipulation b DQL- Data Query Language S.a.i. What is a client -server
client-server architecture.
Language) DCL - Data Control ii. Explain the flow of processes in a 2
DDL (Data Definition What is a relational data model?
Language. ii. 3
relational data model with an example.
Language) iv. Explain the tuple and attribute in the 3
2 12,3 relationaldata model?
examples of
operators. V. What are the advantages of the
ix) Natural join and conditional join are OR
fundamental
b. 2
derived of client-server architecture?
What are the advantages and disadvantages
a
both a and b none 5.b.i. 5
NS, MS
Explain geospatial web client-server with an example.
C.
ii. 2
architecture of DBMSs is based on
a client/server 1 1,2,3 What is SQL?
The standard application iii. 6
X model. The statement is iv. : Explain DDL and DML with an example.
.. .......
b False
True
6.a.i. What is geospatial data modelling? environmental
modelling with an
Elaborate the workflow of geospatial data
GROUP-B ii
example.
(Short Answer Type Questions ) Describe any of the two vector analysis processes
in detail along with the
3x5= 15 different sub-processes with relevant examples:
Answer the following CO PO BL a) Extraction analysis 4*2
MARKS
3
2,3 1 b) Overlay analysis
2.a.i. What is normalisation in the database? 2,3 1 c) Proximity analysis
2 1
Why is it used in database management? d) Statistical analysis
OR
OR
computational model according
What is the entity-relationship model?
3 1
6.b.i. How do you convert a conceptualmodel to a
2.b.i. 2, 3 1 to EPA (2006) guidelines?
What is an attribute? Explain it with a geospatial example. 2
understand by ACID properties of a database? Elaborate
the 4
ii. What do you
properties with examples
with
Explain (any four) of the basic operators used in relational algebra
2 1,3
w3.a.i What is a Geoserver? /
3 5 1,3 examples:
ii. Describe the different services offered by a Geoserver.
a) Selection
OR
b Projection 4*2
Consider the following scenario: Acity government implements a iii. 9 Union
1,3
3hi geographic infornation system (GIS) to manage infrastructure assets, zoning Set difterence
data, and real-time traffic information. The GIS uses a client-server
architecture. e) Set intersection
f)
Rename
Explain the roles ofa web client, web server, and geospatial server in this
SCenar0.
g) Cartesian product
Describe two advantages of using a client-server architecture for the City's 2 1,3
Page 2 of4
S I S T / G I / M . T E C H . / S E M - 1 I / P G G I - 2 0 1 / 2 0 2 3 - 2 4
7.ai. What do you understand by geometry data type? Elaborate on the properties 4 3 12,3 1,6
and characteristics of geometry data types.
12,3 1
When do you use the geography datatypes in aspatial database? 3 3
5
i Explain spatial indexing with the help ofR-tree Hierarchy. 4 3 12, 3
v. Explain the difference between the primary and foreign keys in a relational 4 2 12.3 4
database table. Provide an example for each.
OR
7.b.i. What is UML in database
management? 1 3 12,3
Elaborate on any two UML relationships. 4 3 12,3
What are the linitations of using UML in creating a spatial database? 2 3 12,3
iv. What is indexing in the database? Why is it used? 4 2 12.3
Lsing the foliowing image explain how spatial indexing works?
4 3 12, 3
