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

Database Design and Implementation - Assignment Example A major downside of this site is that it is very slow. The seller is not required to pay any fee for posting an item for sale. The sites has strong measures and applications installed that ensures that it is fraud proof and the sellers can list as many items as they want as opposed to most online purchasing sites. E-bay is one of the leading online shopping market place where buyers and sellers transact a wide variety 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. All the three sites have five major entities that is; the auction, product, payment, seller and the buyer. Of the four entities only three are actively involved at any given time, mostly, the auction, product 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 less important and could be retrieved through the major attributes such as the auction, seller/buyer or product ids. Normalizing the possible tables 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 product id. The auction table therefore will be normalized