Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    1

    DB Design + Relationships

    Hi

    As a relative newbie I need some advice on whether the following design and relationships are OK or if they need adjusting.

    Currently there is an excel spreadsheet (.xls) being used that has the following column headings and data types. Data in it at the mo is really meesy with mixed datatypes - my job = fix it!

    GPN Number (Unique)
    ENUM Number (repeated values)
    MAKE Text (repeated values)
    SYSTEM text (repeated values)
    SYSTYPE text (repeated values)
    DESCRIPTION text (repeated values)
    SERIALNO Number (unique)
    QUANTITY Number (repeated values)
    PRICE Currency (repeated values)
    REGION Text (repeated values)
    LOCATION Text (repeated values)
    CONFIRMED Date (repeated values)
    FIRSTNAME text (repeated values)
    LASTNAME text (repeated values)
    STOCKTAKE Date (repeated values)
    REMARKS text (repeated values)



    Here's some sample data to give an example of the types of info that is required.


    GPN [Unique]
    4556
    2033
    1815

    ENUM
    282
    282
    123

    MAKE
    Sony
    Motorola
    Nokia

    SYSTEM
    HF
    VHF
    SATCOM
    TRACKING

    SYSTYPE
    MOBILE
    HANDHELD
    WLAN
    WGAN
    THURAYA

    DESCRIPTION
    CABLE CAT5
    CHARGER
    MIKE
    EARPIECE

    SERIALNO
    54324
    45766
    43556
    54324
    45766
    1234
    1234

    QUANTITY
    1
    3
    1

    PRICE
    $110.85
    $250.25
    $215.62


    REGION
    London
    Kent
    Buckinghamshire
    Berkshire


    LOCATION
    H1
    Store 6
    Building2
    Team4

    CONFIRMATION
    12/04/05
    23/06/05

    FIRSTNAME
    Bob
    Cordelia
    Kim
    James
    Miles
    Jessica


    LASTNAME
    Curtis
    De Havilland
    Tong
    Mayfield
    pondwell



    STOCKTAKE
    21/05/05
    01/12/04


    REMARKS
    Nice bit of kit
    Blah blah zzzz......



    Here's an attempt to start afresh and create some tables with new fields and normalise them. I think I've got the relations right, but would appreciate some feedback to see if you pick up any obvious mistakes.


    ASSET
    GPN[PK], Description, SerialNo, RNum, DateAquired, StockTakeDate, Price, ConfirmDate, ContactNo, CatNo, MakeNo, RegionNo
    [FK's: CatNo, ContactNo, MakeNo]

    MAKE
    MakeNo[PK], MakeName
    [FK: CatNo]

    SYSTEM
    SysNo[PK], SysName
    [FK: CatNo]

    CATEGORY
    CatNo[PK], CatName, SysNo
    [FK: SysNo]

    REGION
    RegionNo[PK], RegionName, LocNo
    [FK: GPN, LocNo]

    LOCATION
    LocNo[PK], LocName

    CONTACT
    ContactNo[PK], FirstName, LastName

    Any help would be much appreciated.

  2. #2
    Join Date
    Nov 2005
    Posts
    3
    Hey guys how are you?
    I'm not a spamer so don't ban me please.
    Could you please tell me your opinion about these two sites:

    Best Portal
    and Great Site

    Thanks you very much.

Posting Permissions

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