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

$1.$PLAYER$-$NAME: the name of the athlete is represented using

a $30-$character alphanumeric field.

$2.$ SCHOOL: a field that contains the name of the school that the

player represents. This is a $30-$character alphanumeric field.

$3.$ YEAR$-$ENTERED: a $4-$digit numeric field that records the

month and year in which the player joined the team. This field

is entered using the format yy $/$mm$,$ where yy stands for the

last $2$ digits of the year and mm$,$ the month. For example, if

the player joined the team in September, $1979,$ the value for

this field would be entered as $7909.$

$4.$ HIGH$-$SCHOOL: a field that contains the name of the high

school from which the player graduated. This information is

something that many coaches would be interested in from a

recruiting perspective. The NCAA is peripherally interested in

this entry since it is beginning to address the question of what it

can do to encourage high schools to prepare potential athletes

for college careers. This is an alphanumeric field of $30$ characters.

$5.$ HIGH$-$SCHOOL$-$ATHLETES: a field that contains information

about the number of active collegiate athletes that graduated

from the same high school as the player in question. These

data are useful for the same reasons cited above. This is a

$3-$digit numeric field.

$74$ Case $6$: The NCAA Data Base

$6.$ SCHOLARSHIPS: a $2-$digit numeric field that records the num

ber of scholarships that the player was offered. This would

help the NCAA and coaches keep track of how players per

formed in college ball compared to what was expected of them

on graduating from high school.

$7.$ POSITION: a field that contains the name of the position that

the player predominantly plays. This is an alphanumeric field

of $25$ characters.

$8.$ RATING: a subjective rating of the player by his head coach

based on how he compares with other players in the data base.

This entry would be invaluable to the people involved in select

ing all$-$conference or all$-$star teams. This is a numeric field that

can take on a value between $1$ and $20.$

$9.$ INJURIES: a collection of fields that contain a list of injuries

sustained by the player since he joined the team. This informa

tion would allow the NCAA to keep track of whether or not

there was a pattern of injuries in college football. Each is a

$40-$character alphanumeric field.

$10.$ COURSES$/$GPA: a list of entries about each course that the

athlete had enrolled in and his performance in each course. This

would be useful to the NCAA to track the performance of indi

vidual players. Further, some conferences were talking about

instituting conferencewide academic standards, and this infor

mation would be useful $($and available$)$ to all conference mem

bers. The entry consists of a $30-$character alphanumeric field

for the name of the course and a $2-$character alphanumeric

field to record the athlete's grade in the course.

As in the case of school information, a number of on$-$line appli

cation programs are to be used to store player information in the

data base. At the beginning of each year a player display program

would allow verification of a number of player$-$related data and the

addition of new data as new players enter the data base. Figure $6-4$

shows a sample listing of this display.

At the end of each year a course display would allow data per

taining to courses taken by the players to be entered along with the

grades the players obtained in their courses. This display would also

allow the correction of previously entered data $($for example,

removal of an incomplete grade$).$ Figure $6-5$ shows a display to be

used for this purpose