Database Lab 6

Due October 24

Purpose

The purpose of this lab is to give students experience recognizing and understanding functional dependency.

Problem

Consider a database that is to be designed to keep track of various information about people working for different companies. In particular, each person (P-NAME) lives on a particular street (P-STREET) in a particular city (P-CITY). That person may work for several companies (C-NAME) earning a salary (SALARY) at each company. Each company, in turn, is located in one city (C-CITY). Finally there is a certain status (STATUS) associated with salaries. If two salaries are the same, they will have the same status. That is, a status is associated with a specific salary. Finally we can assume that no two people or companies have the same name.

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

B. For each dependancy found, write a compete english explaination of what the dependancy means, and why it is a dependancy.

Write your dependancies like this:

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

Teams

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

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

Wheel-O-team selector

Joshua A
Kaleb
Brandon
Trenton
Joseph
David
Aaron
Logan
Nicholas
Trent
Jason
Joshua
Luke
Topic revision: r3 - 2013-10-18 - 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