Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Question design layout help

    Hi,

    I would appreciate any help and suggestions to the following;

    I have to build a simple relational database in oracle, its the first one we are doing at work so it has to be good. The idea is: organizations provide service(s) for overweight people. Here is the info I have

    - Organization info (address)
    - Type of Programs
    - targe audience
    - lanugages offered at each oranization
    - cost
    - level of obiesity change (losing weight? gaining weight?)
    - Obiesity level
    - # of clients at each organization
    - # of past clients

    Any suggestions of Entities, Tables, Relationships? or just to get me going?


    Thanks Janet

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171

    Re: design layout help

    The main nouns in your text are probably entities:
    Organization
    Program
    Language
    Level of obesity change (maybe?)
    Obesity level
    Client

    Relationships:
    Lanugage "offered at" Organization
    Client "at" Organization

    Those are the obvious ones!

Posting Permissions

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