CS 3200 Database Design 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 an area in square kilometers. 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.