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.

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

Dear please give a single example for it.

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

ask your teacher for an example

Now check it

Check what?

i think that was a bump

Oh, I assumed (s)he forgot to post their answer

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

Really?!
HAHAHAHAHAHAHAHAHAHAHAHHAHAHAHAHAH!
EDIT: Oooh post #1111

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!

pootle flump ur codings are working excelent.

we left them in place

That just goes to show kids, don't cheat
Or is it "don't get caught" ?








.... I think it's the first one

Wow. A whole website for cheaters:
http://answerboard.cramster.com/comp...5-67166-0.aspx

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))