Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004
    Posts
    4

    Please Review Database Design

    I'm really a Database design greenhorn. I only do it because we have no one on staff who can do it and the database will be the backend for a application I am writing. The target database is Oracle 9. I've attached a jpg of the ERD. I would appreciate any pointers, suggestions or corrections.

    Thanks,
    -Mark
    Attached Thumbnails Attached Thumbnails export.jpg  

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    is document_id unique? if so, i would not use a compound primary key in the document table, nor a compouind foreign key in the nasageneral table
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Dec 2004
    Posts
    4
    Yes, it is unique. Thanks. The idea is to be able to support any future additional document types in addition to the type represented by the nasageneral table. The database is basically a listing of documents (of a specific type) that have or will be imported into another system. I've updated the model and attached the changes.

    Thanks,
    -Mark
    Attached Thumbnails Attached Thumbnails export.jpg  

Posting Permissions

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