Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For number 1 what would the data model look like? For number 2 and 3 I need help with what the SQL code would be
For number 1 what would the data model look like? For number 2 and 3 I need help with what the SQL code would be
TEAM Table Primary key: T NUMBER Foreign keys: none T NAME GA Bulldogs Clemson Tigers Ohio State Buckeyes 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 T NUMBER TOUCHDOWNS YARDS 3890 2560 1300 3300 2280 1590 2000 1100 12 63 Dwayne Haskins Jake Kyler Taylor Will Cole Preston Gordon 5050 5020 5070 5030 5070 5020 5080 5020 50 42 12 32 63 01 Fromm Murray Corneliu:s Grier McDonald 08/11/1995 Williams Love 12 24 18 21 15 30 06/30/1996 12/17/1997 Contd Q1. Draw the data model from which these tables are based. Q2.What are the specific bowl subdivisions represented in the database? Q3. Which players gained more than 2000 yardsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started