Write a description of what each of the following queries does: a. SELECT ** FROM Member LEFT OUTER JOIN Tournament ON memberID = tournamentWinner; b. UPDATE Member SET member Name = "Devon Chance" WHERE memberID = 100154; c. SELECT memberID, gamelD FROM Member NATURAL JOIN MemberGame NATURAL JOIN Game WHERE joinDate < "2021-01-01" AND gameDate >= "2021-01-01"" 3. Write two functionally different relational algebra statements equivalent to the query in 2c.
Write a description of what each of the following queries does: a. SELECT ** FROM Member LEFT OUTER JOIN Tournament ON memberID = tournamentWinner; b. UPDATE Member SET member Name = "Devon Chance" WHERE memberID = 100154; c. SELECT memberID, gamelD FROM Member NATURAL JOIN MemberGame NATURAL JOIN Game WHERE joinDate < "2021-01-01" AND gameDate >= "2021-01-01"" 3. Write two functionally different relational algebra statements equivalent to the query in 2c.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Can I have expaination for 4.
Transcribed Image Text:Part 1: Use the following schema to answer the questions 1-3 below. This schema refers to a gaming
organization. There can be any number of players per game. Each game and each tournament has one
winner; if the game or tournament is ongoing, the winner is null. The gameWinner and
tournamentWinner attributes are foreign keys for memberID.
Member(memberID, member Name.joinDate)
GamelgamelD, gameType, gameDate, gameWinner, tournamentName)-
MemberGamel(memberID, gamelD)-
Tournament(tournamentName, tournamentWinner)
ww
Transcribed Image Text:2. Write a description of what each of the following queries does:
a. SELECT *
FROM Member LEFT OUTER JOIN Tournament ON memberID = tournamentWinner;e
%3D
b. UPDATE Member
SET memberName = "Devon Chance""
WHERE memberID = 100154;
c. SELECT memberID, gamelD
FROM Member NATURAL JOIN MemberGame NATURAL JOIN Game
WHERE joinDate < "2021-01-01" AND gameDate >="2021-01-01"
3. Write two functionally different relational algebra statements equivalent to the query in 2c.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 6 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education