Database Lab 7

Due October 30

Purpose

The purpose of this lab is to give students experience recognizing and understanding functional dependency and possible update anomaly's.

Problem

A database for a football team would need to contain information about the players and coaches. In particular, the database would contain thename( P-NAME) and phone number ( P-PHONE) for each player and similarly the name ( C-NAME) and phone number ( C-PHONE) for each coach. IN addition each player is able to play one or more positions ( POS-NAME) and for each position played receives a rating ( RATING). Each position is designated as either defensive or offensive ( D-O). Finally each coach coaches one or more positions. However only one coach coaches any specific position.

A proposed table for this is:

TEAM (P-NAME, P-PHONE, C-NAME, C-PHONE, POS-NAME, RATING, D-O)

A. Propose what you believe the key should be for the table above. Why?

B. Find and list at least 5 functional dependancies. At least one dependancy will depend on more than one attribute.

Write your dependancies like this:

If B depends on A (A determines B) write: A -> B

C. Find and descripe clearly at least two examples of each the the following types of possible update anomaly's :

  1. Insertion anomalies
  2. Deletion anomalies
  3. Modification anomalies
For each explain why it is an anomaly, and what problem results.

Lab Solutions

Teams

Team 1
1. Brandon
2. Luke
Team 2
3. Logan
4. David
Team 3
5. Aaron
6. Jason
Team 4
7. Nicholas
8. Trenton
Team 5
9. Joshua
10. Joseph
Team 6
11. Joshua A
12. Trent

You will work together as teams. Take time to make sure EVERY student understands the problem.

Wheel-O-team selector

Joshua A
Kaleb
Brandon
Trenton
Joseph
David
Aaron
Logan
Nicholas
Trent
Jason
Joshua
Luke
Topic revision: r2 - 2013-11-27 - JimSkon
 
This site is powered by the TWiki collaboration platformCopyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback