ESSE 3600 Lecture Notes - Lecture 10: Third Normal Form, Unique Key, Master Boot Record

• School: York University
• Department: Earth, Space Science and Engineering
• Course: ESSE 3600
• Professor: Sohn

Document Summary

These questions are taken straight from the chapter textbook review: spatial databases provide structures for storage and analysis of spatial data, and are a type of database. A database is a collection of files, whereas a dbms is a software package for storage, manipulation, and retrieval of data from a database. Spatial data is comprised of objects in multi- dimensional space, and storing spatial data in a standard database would require excessive amounts of space. Spatial database management is necessary for managing spatial databases. It cam work with an underlying dbms, supports spatial data models, spatial operations, and spatial indexing and query optimization over large spatial datasets. Some examples are oracle spatial and esri: hierarchical databases, network databases, and relational databases are types of classical database structures, which are methods of organizing data and its relationships inside a database. The hierarchical database model was created by rockwell & ibm in the 60s/early 70s, and it is a tree-like structure.