zip_code (zip(pk), city, state) mysql> select * from people; | id | firstname | lastname | zip 1 1 | Marty | McFly | 45001 2 Jennifer | Parker 3 | Lorraine | McFly | | 4 | Biff | 5 | George Tannen | McFly 5 rows in set (0.01 sec) 33647 | | 33647 | | 33647 | | 45010 |
zip_code (zip(pk), city, state) mysql> select * from people; | id | firstname | lastname | zip 1 1 | Marty | McFly | 45001 2 Jennifer | Parker 3 | Lorraine | McFly | | 4 | Biff | 5 | George Tannen | McFly 5 rows in set (0.01 sec) 33647 | | 33647 | | 33647 | | 45010 |
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
![Refer to the sample tables and data below.
Tables:
people (id(pk), firstname, lastname, zip(fk))
zip_code (zip(pk), city, state)
mysql> select * from people;
+--
|id| firstname | lastname | zip
1 Marty
| 2 | Jennifer
3
Lorraine |
4
Biff
| 5 | George
5 rows in set (0.01 sec)
McFly
| Parker
McFly
45001 New York | NY
45010 | New Jersey | NJ
33647 Tampa
FL
33765 | Clearwater | FL
4 rows in set (0.01 sec)
O rows
mysql> select * from zip_code;
zip
| city
| state |
3 rows
Tannen
McFly
6 rows
9 rows
45001
| 33647
33647
How many rows will be returned by the following command?
SELECT firstname, city, state
FROM people LEFT JOIN zip_code
ON people.zip = zip_code.state;
| 33647
| 45010 |
foreign key references zip_code(zip)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ffd5c5bed-428f-4fc6-88a2-4182bb244de6%2F1e67342d-452c-44f0-9814-fe706b86d049%2F8noo1rs_processed.png&w=3840&q=75)
Transcribed Image Text:Refer to the sample tables and data below.
Tables:
people (id(pk), firstname, lastname, zip(fk))
zip_code (zip(pk), city, state)
mysql> select * from people;
+--
|id| firstname | lastname | zip
1 Marty
| 2 | Jennifer
3
Lorraine |
4
Biff
| 5 | George
5 rows in set (0.01 sec)
McFly
| Parker
McFly
45001 New York | NY
45010 | New Jersey | NJ
33647 Tampa
FL
33765 | Clearwater | FL
4 rows in set (0.01 sec)
O rows
mysql> select * from zip_code;
zip
| city
| state |
3 rows
Tannen
McFly
6 rows
9 rows
45001
| 33647
33647
How many rows will be returned by the following command?
SELECT firstname, city, state
FROM people LEFT JOIN zip_code
ON people.zip = zip_code.state;
| 33647
| 45010 |
foreign key references zip_code(zip)
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
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)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
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)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education