Please send the SQL queries to create the tables in the proposed documents below

Question

Please send the SQL queries to create the tables in the proposed documents below. Use the DESCRIBE command to see the structure of the tables you created in order to make sure that they are created as planned.

1. Purpose - To search football players and their positions 2. Target audience - Sports fans (mostly football), and fantasy football fans 3. Structure Database search engine- MS-SQL a. i. Create new database named "Football 101" b. Tables &Columns; Player (PK Plavetl Player_name Team (PK) Positioning (PK) Position I Team Name

Explanation / Answer

Tables are defined

4. Query for search button

Select Player_name ,Team_Name,Field_position,Positioning.Position_ID from Player inner join Team on Players.Team_ID = Team.Team_ID inner join Positioning on Players.Position_ID = Positioning.Position_ID ;

inner join on 3 tables is required to extract data from the tables based on common fields

Positioning.Position_ID is used to avoid ambiguity as Position_ID column is present both in Player and Positioning tables.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.