Question: 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

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

4G: : D SQL_Mini Project... px se ji zkusis > Choose any database of your choice except the one used in the course. If you choose any of these, you will get zero marks. Consider the following...

I am currently working on a program that i pretty much have done except for formatting and comments and stuff like that. However im stuck on how i would output the incorrect answer with the...

Design a Java class named Guitar that contains: A private int data field named numStrings that defines the number of strings on the guitar. The default value should be 6. A private double data field...

Final Paper Instructions Here is the assignment, so you can get started formulating your ideas. As you read the various chapters in the book, think of how the situation you choose to write about was...

Instructions: No summary need For each cases 1-Give 3 issues from the article the issues must be state as a marketing focus they must be state as question. One marketing concepts for each issue...

Inuence of Patients' Socioeconomic Status on Clinical Management Decisions: A Qualitative Study Susannah M. Bernheim, MD, MHS1,2 Joseph S. Ross MD, MHS3,4 Harlan M. Krumholz, MD, SM2,5,6,7 Elizabeth...

Chapter 10 - Separating and Retaining Employees Chapter Ten: Separating and Retaining Employees . 1 Chapter 10 - Separating and Retaining Employees ROADMAP: THE LECTURE SEPARATING AND RETAINING...

Give me another example with the same method of solution Goal and objectives 1 1. Database design process flowchart 2 2. Data model 3 3. Phases of database design 3 i. Requirements collection and...

Ranger Sportswear planned to produce 40,000 fleece jackets in its Metairie, Louisiana factory. Fixed overhead costs for the factory were budgeted to be $500,000. The company actually spent $485,000...

Let G be an undirected graph with vertex set V. Define the relation R on V by v R w if v = w or if there is a path from v to w (or from w to v since G is undirected), (a) Prove that is an equivalence...

h canvas.providence.edu 0 1 : 1 9 : 0 5 Time Renaining 4 4 Multiple Choice 5 points [ FIN 3 A ] Which of the following would indicate an improvement in a company's financial position, holding other...

Which statement is true regarding an international business? Multiple Choice An international business can be managed in the same way that a domestic business is managed. An international business...

Read the source of spotlight on the law 9.8 and compare their decisions over reasonable adjustment with more recent cases. Has the position changed as more decisions have been made at higher courts?

Annualised hours (see case study 7.1 and focus on research 7.1) appear to have considerable advantages for the employer. Read the article and book chapter on which these extracts are based and...

Specify which techniques of training are best suited to the following: Learning to drive a car Students needing a basic understanding of the business cycle Teaching teenagers about personal...