Question: given the following requirements for a simple database for the football League (FL) Write the needed SQL Statements to create the database: the FL has

given the following requirements for a simple database for the football League (FL) 

Write the needed SQL Statements to create the database:

the FL has many teams:,

each team has a name, a city, a coach, a captain, and a set of players; 24 players,

each player belongs to only one team,

each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records,  a team captain is also a player,

a game is played between two teams (host team and guest team) and has a date (such as May 11th, 2020) and a score (such as 4 to 2).

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!

Q:

Could you explain the relationship among the real interest rate, nominal interest rate, and inflation rate? How can we get the approximate value of the real interest rate (show the formula)? Could...

Q:

Rose Stone Capital Inc. Balance Sheet Notes Payable Long-term Debt $ 150 $ 350 Cash $ 50 Inventory $ 125 Other Net Current Assets $ 75 Net Fixed Assets $ 650 Equity $ 400 Total Assets $ 900 Total...

Q:

Jason has been able to break even the last two years, but cannot turn a profit. He must earn $9,000 in operating income next year. Selling price per unit=$7.50 Cost for paper per unit=$.75 Cost for...

Q:

ERD - Hockey - League.webp Practice ER Diagram Suppose you are given the following requirements for a simple database for the National Hockey League ( NHL ) : the NHL has many teams, each team has a...

Q:

Please create the relational database schema as well 12. Suppose you are given the following requirements for a simple database for the National Hockey League (NHL) . The NHL has many teams, . Each...

Q:

Please do it. I will definitely upvote. You are hired by a Railway Company, you are asked to design a system which provides information to passengers about the trains available on the bases of source...

Q:

Suppose you are given the following requirements for a simple database for the National Hockey League ( NHL ) :the NHL has many teams,each team has a name, a city, a coach, a captain, and a set of...

Q:

IT-111 Database Design and SQL 1 FINAL PROJECT Instructions: You are to create a database, primary keys, foreign keys, indexes, inserts, updates, views, and other SQL Select statements based on the...

Q:

IT-111 Database Design and SQL 1 FINAL PROJECT Instructions: You are to create a database, primary keys, foreign keys, indexes, inserts, updates, views, and other SQL Select statements based on the...

Q:

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

Q:

What behavioral tendency do people often exhibit with regard to opportunity costs?

Q:

Given the condensed financial statement data (in $ millions) for KRJ Enterprises presented below, calculate the Altman Z- score. Present your answer rounded to two decimal places, e.g., 2.45. Total...

Q:

Let vec ( r ) ( t ) = ( : t 5 - 4 , 2 e 4 t , - 4 s i n ( 3 t ) : ) Find the unit tangent vector vec ( T ) ( t ) a t the point t = 0 vec ( T ) ( 0 ) =

Q:

Selected accounts of Homestead Bakery Inc. show the following: Required For each account, identify the item or items that should appear on a cash flow statement prepared by the direct method. Also,...

Q:

List the major parts of a multi-step corporate income statement for Star Pilates Trainers Inc. for the year ended December 31, 2020. Include all the major parts of the income statement, starting with...

Q:

FG specializes in the manufacture of tablets, laptops and desktop PCs. FG currently operates a standard absorption costing system. Budgeted information for next year is given below: Fixed production...

Q:

What private sector company epitomizes the concept of a global company with a well managed global supply chain? Provide a rationale for your response.

Q:

Given an n-element array X of integers, AlgorithmC executes an O(n)-time computation for each even number in X, and an O(logn)-time computation for each odd number in X. What are the best-case and...

Q:

The return of goods to the supplier will affect the purchase account. Question 27Answer True False

Q:

Demonstrate your understanding of data, metadata, and information using an example.

Q:

What is a primary key? How do the properties of a primary key differ from those of a candidate key?

Q:

What is the difference between a Cross Join, an Inner Join, and an Outer Join?

Q:

FIGURE EX5.9 shows an acceleration-versus-force graph for three objects pulled by rubber bands. The mass of object 2 is 0.20 kg. What are the masses of objects 1 and 3? Explain your reasoning. Figure...

Q:

FIGURE EX5.8 shows acceleration-versus-force graphs for two objects pulled by rubber bands. What is the mass ratio m 1 / m 2 ? Figure Ex 5.8

Q:

An arrow has just been shot from a bow and is now traveling horizontally. Air resistance is not negligible. Identify the forces on the arrow?