CS 5200 Introduction to Database Management Homework #1

Part 1

A tectonic plate is a contiguous part of the surface of the earth. A tectonic plate has a unique name, moves in a direction and at a speed on the surface, and has a boundary consisting of segments on the earth's surface. Each segment has two endpoints. The segments of a plate form a closed polygon (i.e., the second endpoint of one segment is the first endpoint of the next segment). Each boundary segment is part of the boundary of exactly two plates. A plate must be oceanic, continental or both. A volcano is a point on the earth's surface. A volcano may have names and is located on at least one plate. A volcano can be classified as cinder, composite, shield, lava, mud, super, submarine, and/or subglacial. Volcanos can have eruptions which occur for a period of time and produce a quantity of various kinds of material, such as magma and ash.

Develop a UML class diagram for geology. Develop the diagram using any UML tool but submit your diagram as an image file.

Part 2

Translate the following UML class diagram into a relational schema expressed in SQL:

UML class diagram

Using comments, explain what each table and column in your SQL schema represents in the UML diagram. When there are alternative strategies for translating an element in your diagram, explain which one you have used.