Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SQL POSTGRES you got the following tables: 1. Players (ID, name, gender, height) 2 PK-Primary key Z FR-Foreign key 2. Scores (player ID, competitions, sport

image text in transcribed
image text in transcribed
image text in transcribed
SQL POSTGRES you got the following tables: 1. Players (ID, name, gender, height) 2 PK-Primary key Z FR-Foreign key 2. Scores (player ID, competitions, sport b, result) -Pk , and players is also a Fk that references to Players fable (ID), while sportid is also a FK that references to sports table (ID) - see table 3 below: 3. Sports (10, name, record) Note: name is UNIQUE. Based on these 3 giren tables, write a single query (as simple as you possibly can) in order to retrieve the following info: - Select the ID and name of all players who have not set any recorols

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

The Database Management Systems

Authors: Patricia Ward, George A Dafoulas

1st Edition

1844804526, 978-1844804528

More Books

Students also viewed these Databases questions

Question

What are the HRM implications of this type of merger?

Answered: 1 week ago

Question

2. Develop a persuasive topic and thesis

Answered: 1 week ago

Question

1. Define the goals of persuasive speaking

Answered: 1 week ago