Kit712_Assignment1_final.docx - KIT 712 Data management...

This preview shows page 1 - 5 out of 10 pages.

KIT 712 Data management Technology Assignment one
1. Ebay Business rule ...................................................................................................................... 1 1.1 Buyer ................................................................................................................................ 1 1.2 order .................................................................................................................................. 1 1.3 Product .............................................................................................................................. 2 1.4 Auction ............................................................................................................................. 3 1.5 Seller ................................................................................................................................. 3 1.6 Feedback ........................................................................................................................... 4 2. ER diagram ................................................................................................................................. 5 3. Relation Model ........................................................................................................................... 6 4. Conversion to Relational Model ................................................................................................. 7
1. Ebay Business rule 1.1 Buyer The buyer could choose the product and order the product. Each buyer has a unique account name, and contain much different information such as account number, login password, name, email address, delivery address, telephone number. Each buyer may have one or more personal account, and each account contains personal information, addresses, communication preferences, site preference, seller preferences, seller dashboard, feedback, paypal account, subscriptions, resolution centre, advertisement preference. Each buyer may have one or more order. However, each order only has one buyer. The order detail includes the order number, order date, order total, item price, estimated delivery date, tracking number. Each buyer may have many purchase history detail. Each purchase history only has one buyer. 1.2 order Each buyer may have one or more transactions, and each transaction only has one. Each transaction contains the order number, order date, payment type. Each order number only has one transaction. Each order has a unique number and may have one or more products, and each 1
product only has only one order number. Each order contains the quantity, price, postage type, and each order could be removed or save for later. Only when the buyer pays the product, the product will be delivered. Each order has its own logistic, each logistic contain much different information, which is a logistic company, tracking number, post statue. If the order is completed, the ordering information will send the email to the buyer automatically. Each buyer may have many options to select different categories. Each category contains one or more subcategories. Each subcategory only belongs to one category. 1.3 Product Each category has a unique name and may contain one or more products, and each product involves one category.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture