Re: Average
Posted by:
myst way
Date: November 26, 2012 05:41PM
Thanks for the reply , check this
T_Ticket T_Arena
--------- ----------
TicketId (primary key) ArenaId (primary key)
TicketPrice ArenaName
ArenaId (Foreign Key) ArenaAddress
CustomerId (Foreign Key) ArenaCapicity
EventId (Foreign Key) EventId (Foreign Key)
Payed ( boolean)
now a store procedur which returns a tabell having average for each arena !
Average = Sold tickets Divided by ArenaCapicity
Subject
Views
Written By
Posted
1927
November 26, 2012 03:11PM
1237
November 26, 2012 05:30PM
Re: Average
1320
November 26, 2012 05:41PM
1198
November 26, 2012 08:00PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.