Results 1 to 3 of 3
  1. #1
    derek123 is offline Member
    Join Date
    May 2010
    Posts
    1
    Rep Power
    0

    Default some sql and netbeans help

    hello i am having some trouble running queries in netbeans for the following questions and was looking for a bit of help

    Care Managers must be able to find out:
    1. The addresses of services that are available,
    2. The unit cost of all night sitting services,
    3. The number of their clients currently receiving services in each client group,
    4. The address of each service received by each of their clients (in client surname order),
    5. The weekly cost of the services each client currently receives (in decreasing cost order),
    6. The full details of a particular client.

    i have the sql data and create tables statements all complete/finished

    below are the create table statements

    CREATE TABLE care_manager
    (care_manager_id char(4) NOT NULL,
    surname varchar(20) NOT NULL,
    forename varchar(20) NOT NULL,
    team_id integer NOT NULL
    role char(2));

    CREATE TABLE client
    (client_id integer NOT NULL,
    surname varchar(20) NOT NULL,
    forename varchar(20) NOT NULL,
    sex char(1) NOT NULL,
    dob date,
    house_no integer,
    street varchar(30),
    referdate date
    closedate date,
    client_group integer,
    care_manager_id char(4));


    CREATE TABLE clientgroup
    (client_group integer,
    group_name varchar(30));

    CREATE TABLE gets_service
    (service_id integer NOT NULL,
    client_id integer NOT NULL,
    startdate date NOT NULL,
    enddate date,
    wkly_cost decimal);

    CREATE TABLE provider
    (p_id integer NOT NULL,
    p_name varchar(50) NOT NULL,
    house_no varchar(60),
    street varchar(60),
    contact_name varchar(40),
    contact_email varchar(40));

    CREATE TABLE service
    (service_id integer NOT NULL,
    capacity integer,
    address varchar(50),
    p_id integer,
    type_id integer,
    unit_cost decimal);

    CREATE TABLE service_type
    (type_id integer NOT NULL,
    type_name varchar(40) NOT NULL,
    charge_unit varchar(12));

    i was wondering if anyone could help with getting me started on running any of the queries listed above. any help greatly appreciated

  2. #2
    FacaNaCaveira is offline Member
    Join Date
    Jul 2010
    Location
    Rio de Janeiro, Brazil
    Posts
    8
    Rep Power
    0

    Default

    derek123, i don't understand your problem, Do you want help to create the querys to do these things???
    1. The addresses of services that are available,
    2. The unit cost of all night sitting services,
    3. The number of their clients currently receiving services in each client group,
    4. The address of each service received by each of their clients (in client surname order),
    5. The weekly cost of the services each client currently receives (in decreasing cost order),
    6. The full details of a particular client.

    Or you have problem to create the tables??

    Abração
    Max

  3. #3
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,009
    Rep Power
    20

    Default

    As with any programming question here you really need to show us what you've done and explain why it doesn't work.

    We don't simply write code.

Similar Threads

  1. Netbeans Help
    By MuslimCoder in forum New To Java
    Replies: 1
    Last Post: 11-07-2009, 02:23 AM
  2. Netbeans IDE 6.5
    By Manfizy in forum NetBeans
    Replies: 5
    Last Post: 06-07-2009, 02:24 AM
  3. cvs in netbeans
    By okabeer in forum NetBeans
    Replies: 3
    Last Post: 04-26-2009, 11:55 AM
  4. Hi Am New To Use Netbeans
    By arunkumarinfo in forum NetBeans
    Replies: 1
    Last Post: 01-23-2009, 04:18 AM
  5. About using netbeans
    By yuchuang in forum NetBeans
    Replies: 3
    Last Post: 05-27-2007, 08:06 PM

Posting Permissions

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