What is the SQL statement to create tables in oracles for the statements below?

$1.$ SCHOOL: a field that contains the name of the school. This is

an alphanumeric field consisting of $30$ characters.

$71$The Data Base

$2.$ CONFERENCE: a field that contains the name of the confer

ence that the school belongs to$.$ The $80$ schools in the data

base represent seven different conferences. This information is

necessary since the NCAA often needs reports broken down by

conference rather than by individual team. This is an alpha

numeric field consisting of $25$ characters.

$3.$ STADIUM$-$SIZE: a field that contains the seating capacity of

the stadium in which the team plays its home games. This is a

numeric field of up to $6$ digits.

$4.$ TICKET$-$PRICE: three numbers that represent the average cost

of a game ticket for each of the $3$ most recent years. Each of

the three numbers is a numeric field of the form $99$V$99($F$5\mathrm{.}2).$

$5.$ IN$-$STATE$-$PLAYERS: three numbers representing the number

of players that are from the state in which the school is located.

These data are for the three most recent years. This information

was deemed necessary in order to generate reports about pat

terns of recruiting by schools and$/$or in conferences. Each is a

numeric field consisting of $2$ digits.

$6.$ OUT$-$STATE$-$PLAYERS: three numbers representing the

number of players that are from out of state for the three most

recent years $($necessary for the reason cited above$).$ Each is a

numeric field of $2$ digits.

$7.$ SCHOLARSHIPS: three numbers representing the number of

scholarships the school offered in each of the three most

recent years. Each is a numeric field of $2$ digits.

$8.$ GRADUATES: three numbers representing the number of

players who graduated in each of the three most recent years.

This was vital information as far as the NCAA was concerned.

Many of the recent critical press reports pertained to athletes

who never finished school and possessed few or no skills to help

them get a job. Each is a numeric field of $2$ digits.

$9.$ RECRUITING$-$INCIDENTS: a list of entries for each of the

three most recent years that recorded the nature of any notice

able recruiting incident $($usually a violation or a near violation$)$

that had been brought to the attention of the NCAA. The

entry is a $5-$digit code that identifies the specific nature of the

incident under question. The codes were compiled after a

careful inspection of NCAA recruiting guidelines and rules.