Hi ,

I want to create an Entity relationship diagram for an online auction system. the requirements I have is

Buyers and sellers must register to access site. Buyers and sellers to register with a valid email address.

Requests name, address, phone number, country and password at time of registration.

Items sold via Auction

Each product category has a number and a description.

The seller adds the price and provides a description of the item.

When sellers register, they also need to nominate how they are to be paid whether by cash on delivery (COD), cheque, credit card or direct deposit into the sellers bank account, in which case they also need to nominate the account number and name, and the BSB number.

For payments, the system needs to record the item that was sold, the buyer, the seller, the payment method, incidental costs such as postage, and the date the payment was made.

If the item is not sold, the item can be reposted or removed at the discretion of the seller.

Please help. Thanks