Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What would the SQL code for these be in oracle? TEAM Table Primary key: T NUMBER Foreign keys: none T NAME GA Bulldogs Clemson Tigers

image text in transcribedimage text in transcribed

What would the SQL code for these be in oracle?

TEAM Table Primary key: T NUMBER Foreign keys: none T NAME GA Bulldogs Clemson Tigers Ohio State Buckeves OSU Cowboys Kentucky Wildcats Michigan Wolverines BIG TEN LSU Tigers BOWL SUBDIVISION SEC ACC BIG TEN BIG 12 SEC T NUMBER 5020 5050 5070 5090 5040 5080 5030 SEC PLAYER Table Primary key: PLAYER ID+ T NUMBERForeign keys: T_NUMBER (references the TEAM table) PLAYER IDPFNAME PLNAME DOB 01/01/1997 06/30/1996 04/12/1997 10/10/1998 02/28/1996 08/11/1995 06/30/1996 12/17/1997 T NUMBER TOUCHDOWNS YARDS 5050 5020 5070 5030 5070 5020 5080 5020 3890 2560 1300 3300 2280 1590 2000 1100 12 63 Dwavne Haskins Jake Kyler Taylor Will Cole Preston Gordon 50 42 12 32 63 01 Fromm Murray Cornelius Grier McDonald Williams Love 12 24 18 21 15 30 Contd

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

1 2 3 Data Base Techniques

Authors: Dick Andersen

1st Edition

0880223464, 978-0880223461

Students also viewed these Databases questions