Pretty Simple help needed

Discussion in 'Database Support' started by DOGHOODLUM, Feb 2, 2004.

  1. DOGHOODLUM

    DOGHOODLUM Guppy

    I have a pretty simple access database having to do with customers, invoices, stove, repair, and part which are the entities. I have almost finished it and everything is set up the only thing is messing up is my relationships. Can anyone just take a look at it and tell or show me what to fix to make it correct?
  2. DOGHOODLUM

    DOGHOODLUM Guppy

  3. CortoMaltese

    CortoMaltese Guppy

    Hi,

    The relationship between entities depends on what your business requirements are. Let me assume that your Invoice can have many Repair jobs and that in the one repair job you are going to work on 1 or an infinite number of stoves.

    So, if this is correct, then I would move the RepairID into the Stoves table and have one repair to many stoves relationship.

    Also I?m not sure how you are handling stove Parts but they can be completely independent (basically just linked to the invoice table), or you can have relationship between Stoves and Parts tables.

    There is also a possibility to link the Repair job to the Part with having RepairID inside of the Parts table.

    Take all this with reservation because the shape of your database depends on your business requirements, and I?m not familiar with them. :)

    Hope this helps.

    PS
    Your Repair table needs InvoiceID instead of CustomerID.

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services