Skip to content

HenryChen-CH/cs144-2017winter

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

73 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

The design of table is as following:

	1) Items(ItemID, Name, Currently, Buy_Price, First_Bid, Location, Latitude, Longitude, Country, Started, Ends, SellerID, Description), primary key(ItemID), foreign key: SellerID->Sellers.UserID

	2) Bids(ItemId, UserID, BidTime, Amount), primary key(ItemId, UserID, BidTime), foreign key: ItemID->Items.ItemID, UserID->Bidders.UserID

	3) Categories(ItemID, Category), primary key(ItemID, Category), foreign key: ItemID->Items.ItemID

	4) Sellers(UserID, Rating), primary key(UserID)

	5) Bidders(UserID, Rating, Address, Country), primary key(UserID)

The functional dependences:

Items.ItemID -> Name, Currently, Buy_Price, First_Bid, Location, Latitude, Longitude, Country, Started, Ends, SellerID, Description
(ItemId, UserID, Time)-> Amount
Sellers.UserID -> Rating
Bidders.Bidders -> Rating, Address, Country

BCNF:
	Since the left side of all function dependencies are superkey of corresponding table, it satisfies BCNF constraints.


Satisfy Fourth Normal Form (4NF)

About

UCLA cs144, Web Application 2017 Winter

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors