Database Design and Implementation Assignment Example | Topics and Well Written Essays - 5000 words

Database Design and Implementation - Assignment ExampleA major downside of this site is that it is rattling slow. The seller is not required to pay any fee for posting an head for sale. The sites has strong measures and applications installed that ensures that it is prank proof and the sellers can list as many items as they want as opposed to nigh online purchasing sites.E-bay is one of the leading online shopping market place where buyers and sellers transact a wide mannikin of goods and services worldwide. It has become a multi-billion dollar company after it was founded back in 1995. It has included buy-it-now as a standard shopping, an expansion from its original auction format. A number of items, from cars to antiques, are listed by a seller who then chooses to only accept bids for the item thus enabling the buyer to purchase the item immediately. The first buyer eager to pay the sellers stated price gets the item on a buy-it-now option. exclusively the three sites have fiv e major entities that is the auction, yield, payment, seller and the buyer. Of the four entities only three are actively involved at any given time, mostly, the auction, convergence and the buyer. The three entities have major common attributes across the three sites most of which were identified as the generic attributes. The product id, seller/.buyer id and the product id alongside other attributes formed the major attributes across the three sites.The other attributes that were rejected were either irrelevant or slight important and could be retrieved through the major attributes such as the auction, seller/buyer or product ids. Normalizing the possible disconcerts consisting of the entities alongside their attributes led to the rejection or dropping off of some attributes to avoid data redundancy.The product name, product description, product prices and product image from the auction table can be compressed into a different table named product with a primary key being prod uct id. The auction table therefore will be normalized