Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Location
    Melbourne
    Posts
    92

    Unanswered: am I normal(ised)

    I attempting to create simple DB for a Service repairs.

    The idea is that customers would bring in equipment for repairs. The quipement gets registered for repairs and then is sent of to repairers to be fixed. There a several repairs according to what needs to be fixed and these repairer may use more than one contact details.

    Should I have separate table for Customer No and Repairer No. So that user can select which one the want. Should I base the Primary Key using the CustNumber and RepNumber.

    Any help to ensure that Im on the right track would be appreciate because I want make sure that I have things normalised now before start on any fancy stuff.

    I was think along these lines:

    tblCustomers
    CustomerID PK
    CustNumber (eg C0001) searches are based on this No.
    CustSurname
    CustGName
    Address
    etc

    tblRepairers
    RepID (PK)
    RepNumer (eg R001)
    RepName
    RepAddress
    etc

    tblCust_Repairer (linking this table to the other confuses me)
    CustRepID (PK)
    CustID (FK)
    RepID(FK)
    SerialNo
    CustName
    CustNum
    RepairName (lookup)
    FaultDescription
    ElbexCharge
    etc





    tbl

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    if CustNumber (eg C0001) has some special purpose and will always be assigned, then you don't need a separate CustomerID PK

    same for RepID (PK)

    nor does tblCust_Repairer need CustRepID (PK) because its PK will be the combination CustNumber RepNumber

    tblCust_Repairer should not carry any data from either the customer or the repairer, rather, just fields specific to the repair of the equipment

    rudy

  3. #3
    Join Date
    Nov 2002
    Location
    Melbourne
    Posts
    92
    Thanks Rudy!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •