-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathREADME.txt
59 lines (42 loc) · 983 Bytes
/
README.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
Name: Paul Rodriguez
sid: 303675125
project 2
tables:
Users(
UserID PRIMARY KEY,
Rating,
Location,
Country
)
Items(
ItemID PRIMARY KEY,
Name,
Currently,
Buy_Price,
First_Bid,
Number_of_Bids,
Started,
Ends,
Seller,
Description,
)
Categories(
ItemID,
Category,
PRIMARY KEY (ItemID, Category)
)
Bids(
ItemID,
UserID,
BidTime,
Amount,
PRIMARY KEY (ItemID, UserID, BidTime),
)
non-trivial functional dependencies:
UserID -> Rating, Location, Country
Category -> Items
Items -> Category
ItemID, Bidder, BidTime -> Amount
ItemID -> Name, Currently, Buy_Price, First_Bid, Number_of_Bids, Started, Ends, Seller, Description
this relation design should be in BCNF because each item and user is stored only once and the categories relation have all its attributes combined as keys.
the Bids relation should be in BCNF since there should be no redundancy of information as a bidder can bid on the same item multiple times but the acutal time that they bid must be different.