Instructions For each of the relations below, list the functional dependencies y
ID: 3887253 • Letter: I
Question
Instructions
For each of the relations below, list the functional dependencies you find. Remember to look past the sample data and think of all possibilities that may occur in a real-world application. If needed, list the assumptions required to make your functional dependencies valid. When listing functional dependencies, make sure to follow the correct notation as outline in the lecture slides.
Question 1
ItemID
ItemName
ItemUnitCost
ItemsSold
TransactionTime
CustomerID
CustomerEmail
1
Chocolate Bar - 10oz
4.99
4
9/5/2017 17:14:45
54
Dsmith@mail.com
5
Truffles - 4 piece
6.99
2
9/3/2017 9:40:46
40
Rmason@net.com
1
Chocolate Bar - 10oz
4.99
1
9/7/2017 12:03:05
54
Dsmith@mail.com
4
Mint Candies - 10 piece
5.99
5
9/1/2017 22:16:13
11
Bkhan@gmu.com
10
Peppermint - 10 piece
4.99
2
9/6/2017 18:21:32
15
Sadams@gmab.com
11
Chocolate Bar - 5oz
2.99
1
9/5/2017 10:33:29
101
Rsmith@mailnet.com
4
Mint Candies - 10 piece
5.99
2
9/4/2017 1:16:28
12
Adavis@mail.com
5
Truffles - 4 piece
6.99
3
9/1/2017 11:03:27
94
Broberts@net.com
Functional Dependencies:
ItemID
ItemName
ItemUnitCost
ItemsSold
TransactionTime
CustomerID
CustomerEmail
1
Chocolate Bar - 10oz
4.99
4
9/5/2017 17:14:45
54
Dsmith@mail.com
5
Truffles - 4 piece
6.99
2
9/3/2017 9:40:46
40
Rmason@net.com
1
Chocolate Bar - 10oz
4.99
1
9/7/2017 12:03:05
54
Dsmith@mail.com
4
Mint Candies - 10 piece
5.99
5
9/1/2017 22:16:13
11
Bkhan@gmu.com
10
Peppermint - 10 piece
4.99
2
9/6/2017 18:21:32
15
Sadams@gmab.com
11
Chocolate Bar - 5oz
2.99
1
9/5/2017 10:33:29
101
Rsmith@mailnet.com
4
Mint Candies - 10 piece
5.99
2
9/4/2017 1:16:28
12
Adavis@mail.com
5
Truffles - 4 piece
6.99
3
9/1/2017 11:03:27
94
Broberts@net.com
Explanation / Answer
Functional dependencies for given table are:
ItemID ---> ItemName,ItemUnitcost
ItemUnitCost---->ItemSold
ItemID,CustomerID ---> TransactionTime
CustomerID-----> CustomerEmail