[Year 12 IT Apps] Entity-Relationship Diagram - Unit 3 Outcome 2

[Peter Langham]

Hi guys,

I'm looking for some clarification on Entity-Relationship Diagrams.

I'm planning to develop a pet shop database as that will have a Customers
Table, Products Table and Orders Table.

When I complete my entity-relationship diagram I will use Customers,
Products and Orders (or Invoices) as my entities.

But I'm unsure if I'm doing the Relationships correctly.

Customer - BUYS - Product
Customer - PAYS - Order (or Invoice)
Order (or Invoice) - Displays/Outputs - Product (Information)

Is this correct?

Thanks for your time.

Peter Langham.
Narre Warren South P-12.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20110330/f5eaf83e/attachment.html