Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2010
    Posts
    5

    Unanswered: Object Relational

    I was wondering if anyone could help me where to start on this?

    Consider the following schema containing data for a particular air base:

    Pilots
    {PID, Name, HomeTown, HomeState, Rank}
    AirCraftTypes {Model, Aname, MachSpeed}
    Aircraft
    {AID, Model, DateInService, HID}
    FlightSkills {PID, Model, HoursLogged}

    Data for this schema can be found on the department Database server in the Airbase
    schema.

    Required:

    Implement the schema above as a series of user defined types and object tables. Make
    sure to use references instead of foreign keys. Insert the same test data that is found in
    the airbase1 schema.

    Include the following member functions in the pilot type:

    totalFlightHours()
    - returns the total hours logged by that pilot in all aircraft.
    totalFlightHours(model)
    - returns the total hours logged by that pilot in a particular aircraft. The function
    should return 0 if they have not flight hours in that model.
    addFlightHours(model,hours)
    - adds additional flight hours for a pilot for a particular model. If there is not
    already a flightskills row for that pilot/model combination it should be added.

    Answer the following queries. Use your member functions and referencing following to
    avoid joins.

    1) The name, F-15E flight hours logged, and total flight hours logged of all pilots.
    2) The name and rank of all pilots who can fly the plane with AID=1173
    3) The name, rank, and model for all pilots that can fly a supersonic jet. A
    supersonic jet is one with a MachSpeed of 1 or greater.

  2. #2
    Join Date
    Nov 2010
    Posts
    5
    here is what i have so far and not sure if it is right

    CREATE or REPLACE Type PilotsADT as object
    (PiloID Number(6,0),
    AirID Number(6,0),
    PName varchar2(20),
    ModelName Varchar2(20),
    Hours Number(8,0),
    member function totalFlightHours Return Number,
    member function totalFlightHours Return Number,
    member function addFlightHours Return Number);

    CREATE or REPLACE Type PilotsADT as
    member function totalFlightHours Return Number IS
    Begin
    SELECT sum(HoursLogged)
    INTO totalFlightHours
    FROM FlightSkills
    GROUP BY PID, Model;
    End;

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Be aware that I am very old-school.
    I contend that mixing relational with object oriented programming (OOP) is like mixing oil & water.
    I do not believe anything meaningful is gained by implementing OOP inside an Oracle RDBMS.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Nov 2010
    Posts
    5
    Thanks, but i really need some help with this problem because i am just not sure wehre to start i know i need four user defined types and four object tables. I am just stumped any help please.

Posting Permissions

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