[DM1-3] Relational Databases, Database Managements Systems and Database principles

Relational databases and database management systems are essential for GIS in consequence the important issues have to be treated here: - General aspects, basic architecture of a DB, advantages, features - DBMS concepts and functionalites (transactions, locks, multiuser access etc.) - Database design, techniques - Database administration - Normalization (1NF - 3NF) - Example of a database design

External resources

• Dietrich, S. (2011). Fundamentals of object databases: Object-oriented and object-relational design (Synthesis lectures on data management, # 12). San Rafael, Calif. (1537 Fourth Street, San Rafael, CA 94901 USA): Morgan & Claypool.
• Sumathi, S. (2007). Fundamentals of Relational Database Management Systems (Studies in Computational Intelligence, 47). Berlin, Heidelberg: Springer Berlin Heidelberg.

Learning outcomes

• 2285 - Design relational databases

  Design relational databases

Self assessment

Outgoing relations

• [DM1-3] Relational Databases, Database Managements Systems and Database principles subclassof [DM1] Foundations for Data Modelling Storage and Exploitation