Task A survey of over 1000 database users in 2004 found that 77% used MS Access, 50% MS SQLServer, 42% Oracle and 13% MySQL. 23% of them were using flat-file systems. Your task is to identify the different ways of storing data and explain the role of database management systems. Use the lecture and tutorials to do this.
Storing Spatial Data
[ ppt ]
Source: Trodd N, 2005. Storing spatial data, GeoImaging and GeoInformatics.
Data and Data Management
[ pdf ]
Source: Petch J, 2002. Data and data management. Manchester: UNIGIS.
Basic File Structures and Tabular Databases
[ URL ]
Source: UNESCO, 1999. Cartographic and GIS data structures, in Module D in GIS Training Modules. IOC International Oceanographic Data and Information Exchange Programme. URL last accessed 21-11-2006.
Task Almost all GIS projects should begin with careful analyses of how data are to be entered. It is good practice to design your database to meet the requirements of a given task(s). It is certainly the case that the data model and its related structuring must be independent of the chosen software and hardware... but, experience shows that the data model is (too) often selected to suit the software and hardware rather than the task. Your task is to identify good practice as set out in these these guidelines.
Data Modelling
[ URL ]
Source: UNESCO, 1999. Cartographic and GIS data structures, in Module E in GIS Training Modules. IOC International Oceanographic Data and Information Exchange Programme. URL last accessed 21-11-2006.
Logical Data Structures
[ URL ]
Source: Drewery T, 2003. Logical Data Structures - Getting Started. Bristol: University of the West of England. URL last accessed 14-11-2006.
Task The short ESRI training course introduces the geodatabase model as used in ArcGIS. It has emerged as the core technology and your task is to understand how it has been designed.
Getting Started with the Geodatabase (for ArcGIS 10)
[ URL ]
Source: ESRI, 2010. Getting started with the geodatabase (for ArcGIS 10). ESRI Virtual Campus.<http://training.esri.com/gateway/index.cfm?fa=catalog.webCourseDetail&courseid=2026> URL last accessed 6-11-2011.

Or If you are working with ArcGIS 9.3
Geodatabase Data Model
[ URL ]
Source: ESRI, 2005. Basics of the geodatabase data model. ESRI Virtual Campus. <http://training.esri.com/acb2000/showdetl.cfm?DID=6&Product_ID =726> URL last accessed 20-11-2006.
Task Your objective is to appreciate the role of querying, then you should identify different queries on raster and vector data and finally learn how SQL is used. 
Structured Query Language, Queries and Reasoning
[ pdf ]

Source: Modified from Longley PA, Goodchild MF, Maguire DJ and Rhind DW, 2001. Sections 11.4 and 13.2, in Geographic Information Systems & Science. New York: Wiley. pp. 231 - 2, 282 - 6.

Updated version of source: Longley PA, Goodchild MF, Maguire DJ and Rhind DW, 2005. Sections 10.4 and 14.2 in Geographic Information Systems & Science. New York: Wiley. 2nd edtion. pp. 225 - 6 and pp. 320 - 3.