LECTURE 5 - BASIC FILE STRUCTURES

 
  • A. INTRODUCTION
  • B. CONCEPTS IN DATABASE SYSTEMS
  • C. DATABASE MANAGEMENT SYSTEMS
  • D. HIERARCHICAL MODEL
  • E. NETWORK MODEL
  • F. RELATIONAL MODEL
  • REFERENCES
  • EXAM AND DISCUSSION QUESTIONS
  • NOTES 



  • LECTURE 5 - BASIC FILE STRUCTURES

    A. INTRODUCTION

    Two ways to use DBMS within a GIS GIS as a database problem B. CONCEPTS IN DATABASE SYSTEMS

    Definition

    Advantages of a database approach Views of the database C. DATABASE MANAGEMENT SYSTEMS

    Components

    Types of database systems D. HIERARCHICAL MODEL Summary of features Advantages and disadvantages E. NETWORK MODEL Restrictions Summary F. RELATIONAL MODEL Terminology Examples of relations

    unary: COURSES(SUBJECT)
    binary: PERSONS(NAME,ADDRESS) OWNER(PERSON NAME,HOUSE ADDRESS)
    ternary: HOUSES(ADDRESS,PRICE,SIZE)

    Keys

    Normalization Advantages and disadvantages