EXERCISE 4
Introduction
UNIVERSITY OF CALGARY
DEPARTMENT OF GEOMATICS ENGINEERING ENGO 351: INTRODUCTION TO GIS
This Assignment is to get the students acquainted with the database design process. A simplified Cadastre Scenario was presented in the class, and the steps of the database design process to the actual implementation of the system were discussed: (a) application domain requirements (mini- world); (b) conceptual design (ER diagram); (c) logical design (relational schema); and (d) physical design and implementation (using SQL and a relational DBMS).
Tasks
This project will be carried out in Groups of 2-3 students. Each Group must perform the following steps:
1. Imagine and describe a simplified application scenario (your mini-world) in text form. [1 page]
2. Map the application requirements into an ER Model Diagram. Include at least five entity types and the corresponding relationship types. [one diagram]
3. Map the ER-diagram into the Relational Schema. Show the key attributes and the associations between the relations (tables). [one schema]
4. Implement the Relational Schema into PostgreSQL DBMS on GAIA server using SQL. [SQL commands in text]
5. Insert a few tuples into the tables (Database Instance). [Sample SQL commands in text]
6. Retrieve data from the database instance (Step 5) using appropriate SQL statements. [SQL commands & results in text]
Deliverables:
a. Documents as described above [in brackets].
b. The database on GAIA server. (use one database account per team; to be provided by the
instructor)
Upload documents on D2L > Assignments > Dropbox > Exercise_4
To be carried out in groups of 2-3 students with one deliverable per group. Handed out: Feb. 15. Due: March 6, 2019.
E.Stefanakis, 2019.