Hi Peter<br>When I think of ERDs for databases, I'm seeing a picture of the database's tables with their related key fields connected by relationship lines. These lines usually have "1" on one end and a "many" symbol on the other... <br>
<br>Are we thinking of the same thing?<br><br><div class="gmail_quote">On 30 March 2011 16:54, Peter Langham <span dir="ltr"><<a href="mailto:peterlangham1983@gmail.com">peterlangham1983@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div>Hi guys, </div>
<div> </div>
<div>I'm looking for some clarification on Entity-Relationship Diagrams. </div>
<div> </div>
<div>I'm planning to develop a pet shop database as that will have a Customers Table, Products Table and Orders Table.</div>
<div> </div>
<div>When I complete my entity-relationship diagram I will use Customers, Products and Orders (or Invoices) as my entities.</div>
<div> </div>
<div>But I'm unsure if I'm doing the Relationships correctly.</div>
<div> </div>
<div>Customer - BUYS - Product</div>
<div>Customer - PAYS - Order (or Invoice)</div>
<div>Order (or Invoice) - Displays/Outputs - Product (Information)</div>
<div> </div>
<div>Is this correct?</div>
<div> </div>
<div>Thanks for your time.</div>
<div> </div><font color="#888888">
<div>Peter Langham.</div>
<div>Narre Warren South P-12.</div>
</font><br>_<br clear="all"></blockquote></div><br>-- <br>Mark Kelly<br>Manager of ICT, Reporting, IT Learning Area<br>McKinnon Secondary College<br>McKinnon Rd McKinnon 3204, Victoria, Australia<br>Direct line / Voicemail: +613 8520 9085, Fax +613 9578 9253<br>
<a href="mailto:kel@mckinnonsc.vic.edu.au" target="_blank">kel@mckinnonsc.vic.edu.au</a><br>VCE IT Lecture Notes: <a href="http://vceit.com" target="_blank">http://vceit.com</a><br>Moderator: IT Applications Edulist<br><font>All generalisations are false, except this one.</font><br>
<br>