Page 1 of 2 12 LastLast
Results 1 to 15 of 30
  1. #1
    Join Date
    Apr 2007
    Location
    Sialkot
    Posts
    9

    Relational Algebra Please solve(urgent)

    Consider the following relations and specify relational algebra statements.

    FLIGHT (FlightCode, AirlineName, FromAirport, DestAirport, Date, DepartureTime, NoOfAvailSeats)
    PRICES (FlightCode, EconomyFare, BusinessFare)
    PASSENGER (PassengerCode, Name, Address, Telephone)
    BOOKING (BookingRefNo, PassengerCode, FlightCode, Deposit, TotalFare)

    a. Find the codes and names of the flights coming from Lahore.
    b. Find the names and telephone numbers of the passengers who have booked any ticket.
    c. Find the code, airline name and departure time of the flight with the economy fare.
    d. Find the booking reference number along with airline names, date and number of available seats.

    Please give the solutions with symbols.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    no, we do not give homework answers

    especially if it's urgent

    show us what you've done and you might get someone to comment on it, if you ask the right questions

    "please give the solutions" is not the right question
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Apr 2007
    Location
    Sialkot
    Posts
    9
    Dear please give a single example for it.

    So that i can get the concept and do it my self.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    ask your teacher for an example
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Apr 2007
    Location
    Sialkot
    Posts
    9
    Now check it

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Quote Originally Posted by perochak
    Now check it
    Check what?
    George
    Home | Blog

  7. #7
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i think that was a bump
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  8. #8
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Oh, I assumed (s)he forgot to post their answer
    George
    Home | Blog

  9. #9
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    hey, whaddya know....

    http://answers.yahoo.com/question/in...0105909AAhQvk1



    i wonder what would happen if his teachers found out he was doing this

    this actually happened in another forum i participate in

    buddy sent a panicky note to all forum moderators (yes in was in all caps) PLEASE REMOVE ALL MY POSTINGS MY TEACHER FOUND OUT MY USERNAME IN THIS FORUM AND IF HE SEES ME GETTING THESE ANSWERS I WILL BE EXPELLED
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  10. #10
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Really?!
    HAHAHAHAHAHAHAHAHAHAHAHHAHAHAHAHAH!
    EDIT: Oooh post #1111
    George
    Home | Blog

  11. #11
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I'll bet there was a lot of bloodshed as the mods battled each other to have the honour of cleaning the board of all buddy's posts. Poor, poor buddy!
    Testimonial:
    pootle flump
    ur codings are working excelent.

  12. #12
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    we left them in place
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  13. #13
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    That just goes to show kids, don't cheat
    Or is it "don't get caught" ?








    .... I think it's the first one
    George
    Home | Blog

  14. #14
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Wow. A whole website for cheaters:
    http://answerboard.cramster.com/comp...5-67166-0.aspx
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  15. #15
    Join Date
    Apr 2007
    Location
    Sialkot
    Posts
    9
    Dear i have just jok and want to get your responce.

    I have done it.

    And Submited to the teacher.
    Asked you to get the same but you could not provide me.
    So,
    Have here


    FLIGHT (FlightCode, AirlineName, FromAirport, DestAirport, Date, DepartureTime, NoOfAvailSeats)
    PRICES (FlightCode, EconomyFare, BusinessFare)
    PASSENGER (PassengerCode, Name, Address, Telephone)
    BOOKING (BookingRefNo, PassengerCode, FlightCode, Deposit, TotalFare)

    a. Find the codes and names of the flights coming from Lahore.

     FlightCode, AirlineName (σ FromAirport = ‘Lahore’ (FLIGHT))


    b. Find the names and telephone numbers of the passengers who have booked any ticket.

    σ Name, Telephone (PASSENGER BookingRefNo, PassengerCode (BOOKING))


    c. Find the code, airline name and departure time of the flight with the economy fare.

     FlightCode, AirlineName, DepartureTime(FLIGHT σ EconomyFare (PRICES))



    d. Find the booking reference number along with airline names, date and number of available seats

     BookingRefNo (BOOKING σ AirlineName, Date, NoOfAvailSeats (FLIGHT))

Posting Permissions

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