Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    36

    Lightbulb DB SCHEMA a live example for critical analysis.

    I have created a schema for a system and I'm not sure as to whether my choice of primary keys is correct. I have used 'soc_id' as the key and it relates to every table in my schema. I'm not sure where to add foreign keys and if its necessary.

    I have attached the diagram and wondered if anyone could comment on flaws it may have and whether its correct this way. I'm an app developer and its my responsibility to design the DB. Its being used in an ASP.NET application.

    Your comments would be greatly appreciated!
    THANKS!
    Attached Thumbnails Attached Thumbnails diagram.gif  

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Apparently it's intended for some sort of animal shelter? What is the intent of the application? without knowing what you are trying to accomplish, and an idea of the process flow, it's difficult to say whether a database schema is "correct"
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

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