Databases and FileMaker Pro--Chris Skiba guest lecture
This will be the assignment for Wednesday and Friday's Lectures:
LAB ASSIGNMENT
Computers in Geology
Claris Filemaker Pro 3.0
The objective of this lab is to learn to identify data relationships,
create a file structure for those identified relationships and create a
data entry layout in a master database file linking all related files.
These data come from
Penny King's research on Granites. Thanks Penny!
here is a tip from Chris:
Clue:
If you are having trouble identifing the master file, look at each database file
carefully. The master database file already has the data entry layout partially
created for you. Remember, in order to view layouts, you must be in the layout mode.
Good Luck!
Here is a link to an
explanation of how to assemble an ER diagram applied
to the well database.
Exercises
Part One
You are provided five data sheets that are reporting pertinent information
about rock samples. Please review the data sheets and provide the
following:
Sketch or draft/draw the following (Recall the style of file structure
diagram from lecture):
1. Identify the entities and create a simple E-R diagram
2. Create a file structure for each file and list a least four
attributes per entity.
3. Using the relationship symbols, identify the relationship to each
entity. Remember, make sure you have a master file.
Part Two
In part two of this lab assignment, you will be provided the data files for
each data sheet (Look in the glg490 folder on Caliente public access in the
PSF appleshare zone).
Using your file structure diagram, create a data entry layout in the master
file display all related files using Filemaker Pro. Try and design a data
entry layout that is informative.
Note: It is not necessary to show all geochem fields.
Please turn in the file structure sketch, and submit the FMK Pro files to
glg490@asu.edu
by the beginning of class on Friday 10/24/97.
Pages maintained by
Prof. Ramón Arrowsmith
Pages last modified on Wed Oct 15 1997.