Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed

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 yards

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

Step: 3

blur-text-image

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

Database Driven Web Sites

Authors: Joline Morrison, Mike Morrison

2nd Edition

? 061906448X, 978-0619064488

More Books

Students also viewed these Databases questions