Scribd Logo
Upload

Welcome to Scribd!

  • 203 views

    EER Excercise

    Uploaded by

    Genesis Izon Gerodias
    The document describes the data requirements for an online auction database system. Members can be buyers or sellers and are identified by ID with additional profile information. Items are placed for sale by sellers with details like title, price, and dates. Buyers can place bids on items with a price and timestamp. After an auction ends, buyers and sellers can leave feedback ratings on transactions.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd

    EER Excercise

    Uploaded by

    Genesis Izon Gerodias
    203 views3 pages
    The document describes the data requirements for an online auction database system. Members can be buyers or sellers and are identified by ID with additional profile information. Items are placed for sale by sellers with details like title, price, and dates. Buyers can place bids on items with a price and timestamp. After an auction ends, buyers and sellers can leave feedback ratings on transactions.

    Original Title

    242473083-EER-Excercise.doc

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes the data requirements for an online auction database system. Members can be buyers or sellers and are identified by ID with additional profile information. Items are placed for sale by sellers with details like title, price, and dates. Buyers can place bids on items with a price and timestamp. After an auction ends, buyers and sellers can leave feedback ratings on transactions.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    203 views3 pages

    EER Excercise

    Uploaded by

    Genesis Izon Gerodias
    The document describes the data requirements for an online auction database system. Members can be buyers or sellers and are identified by ID with additional profile information. Items are placed for sale by sellers with details like title, price, and dates. Buyers can place bids on items with a price and timestamp. After an auction ends, buyers and sellers can leave feedback ratings on transactions.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    of 3

    Exercises

    1 1. Consider an online auction database system in which members (buyers and


    sellers) participate in the sale of items. The data requirements for this
    system are summarized as follows:
    The online site has members who are identified by a unique member id
    and are described by an email address, their name, a password, their
    home address, and a phone number.
    A member may be a buyer or a seller. A buyer has a shipping address
    recorded in the database. A seller has a bank account number and
    routing number recorded in the database.
    Items are placed by a seller for sale and are identified by a unique item
    number assigned by the system. Items are also described by an item
    title, an item description, a starting bid price, bidding increment, the
    start date of the auction, and the end date of the auction.
    Items are also categorized based on a fixed classification hierarchy
    (for example a modem may be classified as
    /COMPUTER/HARDWARE/MODEM).
    Buyers make bids for items they are interested in. A bidding price and
    time of bid placement is recorded. The person at the end of the
    auction with the highest bid price is declared the winner and a
    transaction between the buyer and the seller may proceed soon after.
    Buyers and sellers may place feedback ratings on the purchase or sale of
    an item. The feedback contains a rating between 1 and 10 and a
    comment. Note that the ratings are placed on a completed transaction
    by the buyer or seller of the item in the transaction.
    Design an Enhanced Entity-Relationship diagram for the auction database.
    After That Map your EER into a Relational Schema Model

    The Solution is on the following Pages


    The EER Model

    address Password

    email name
    N Members ID
    Phone

    Shipping O Account_
    Address No

    Routing
    Buyers Sellers Number

    M Bidding_Price
    Bidding_Date
    1
    Bids
    Rate
    N
    Comment
    Feedbac Increment
    k .Desc
    End_Date
    M
    Items M
    Start_Date Place

    Title Item_No

    Category
    Start_Price
    The Relational Schema Model

    Members
    Passwor
    ID Name Address Email Phone
    d

    Sellers
    Buyers

    Bids
    Account_ Shipping
    Rout_No
    ID IDNo Address

    Categor Start_Pric Start_Dat End_Dat Incremen Descriptio Seller_I


    Item-No Title
    y e e e t n D
    `

    Bidding- Bidding-
    BID Item-No
    Price Date

    Commen
    ID ItemNo Rate
    t
    Feedback

    You might also like