Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Location
    UK - Teesside
    Posts
    2

    data model problem

    Hi there everyone, happy new year.

    Okay I am in the process of crerating a database using the standard database design method.

    I have created a model but as this is the first time I have tried this im unsure if it is okay.

    I know a model changes throughout the design process, but I need some expert advice to see if it is okay or any suggestions as how it can be improved.

    I have attatced the model and also a brief scenario of the problem

    Any help greatley appreciated

    Best Regards
    Richard Howells

    HTML Code:
    <img src="http://www.richard-howells.co.uk/model.gif">
    Attached Thumbnails Attached Thumbnails model.gif  
    Attached Files Attached Files
    Last edited by weewizard; 01-04-05 at 15:50. Reason: title change

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you are apparently assigning surrogate keys customer_product_id and customer_interest_id

    i wouldn't, i'd make the PK consist of the composite FKs to each respective parent entity

    also, there's an extra table between customer and product_type, one o' them has to go

    customer-product_type is many-to-many, so there would be only the one relationship table between them
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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