DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: relationship s

  1. #1
    Join Date
    Dec 2003
    Posts
    1

    relationship s

    Hi everyone,

    This is my first time. Let me wish everyone a very happy new year.

    Now the reason I am here is can someone please help me with my database. I have a MS Access database with one table which hold the information about various organisations which deal with 1 or more disabilities and offer 1 or more types of employment (paid, skills, training......). Since it's not a good idea to link Access database to a web portal as there will be many users accessing the database at the same time, I have decided to convert the database into an sql database. Or I could just create a new database in oracle which has the following tables:
    1. organisation details (org_id, name, address, ......)
    2. Disability (dbl_id,type_of_disability)
    3. Employment(empl_id, type of employment)

    relationships between them could be as follows:
    organisation details -one-to-many----Disability
    organisation details -one-to-many-----employment
    disability-----many-to-many------employment

    and then the user queries the database by ticking one of the boxes on the disability form to search for organisations which deal with that particular disability(1 or more) and offer various types of employment.

    I t works fine in Access but am I on the right path to implement in oracle.

    regards

    sukhi

  2. #2
    Join Date
    May 2001
    Posts
    73
    Yes. Oracle is a good choice.
    OCP 7.3,8.0,8i,9i

  3. #3
    Join Date
    Jul 2000
    Posts
    521
    Before you really decide to go with Oracle, consider licensing costs for it. It may prove to be a deciding factor...
    svk

Posting Permissions

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


Click Here to Expand Forum to Full Width