Re: Relationship/Normalizing

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


"cableguy47905 via AccessMonster.com" <u4349@uwe> wrote in message
news:73bef0c6f5376@xxxxxx
Thanks again Chris, I am learning so much and didn't realize I
didn't have
much of a grasp on this at all.

I wanted to define my relationships a little better. Because I have
another
question.

1. Each Company can have multiple contracts, but the contracts are
Unique to
just those Companies.
2. Each Contract can have multiple Locations, These locations are
Unique to
the Company.
3. Those locations are unique to each Company.

That wasn't a rule I realized, specifically.




Therefore
Company A (ComA) can have Contract 1 (C1), Contract 2 (C2), Contract
3 (C3)
There are Locations (L1), (L2), (L3) that are all specific to the
Company,
not the contract.

That's a major departure from what I knew previously.

If locations are specific to companies, and not contracts, then things
would be organized differently.

Except, I'm not sure exactly what new rule is, as the example below
still has contracts having locations.



Company B (ComB) can have (CB1), (CB2) and has no locations.

Wow!



This is correct:
Company Contract Location
ComA C1 L1
ComA C1 L2
ComA C1 L3
ComA C2
ComA C2
ComA C2
ComB CB1
ComB CB2


However,

It is allowing me to have L1, L2, L3 with CB1 or CB2. This is not
correct.
C2 can have L1,L2,L3, but may not always have this. I am confused
about this
relationship.

Can you help with this one?


Umm . . . think . . . think . . . think . . . <Jeopardy theme music />
.. . .


Companies have contracts.

Companies may have locations.

Locations may be associated with only one Company.

Contracts may have locations.

Contracts may have many locations.

Contracts may be associated with only one Company.


Before I go ahead and start the table designing route, why don't you
look over the list of rules above and add, delete, or edit as
necessary.


Sincerely,

Chris O.



.

Relevant Pages

  • Re: Relationship/Normalizing
    ... Thanks again Chris, I am learning so much and didn't realize I didn't have ... much of a grasp on this at all. ... Each Company can have multiple contracts, but the contracts are Unique to ...
    (microsoft.public.access.tablesdbdesign)
  • Finding records on secondary index - Rookie
    ... I'm using a form to manage customers and related contracts; ... By design each customer can have multiple contracts, ... I thought I could easily add some VBA code to query a secondary index based ...
    (microsoft.public.access.adp.sqlserver)