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 +-- | McFly Jennifer | Parker Lorraine | McFly Tannen | 1 | Marty | 2 | 45001 33647 33647 33647 | 07005 | 3 | | 4 | Biff | 5 | George | McFly 5 rows in set (0.01 sec) mysql> select from zip_code; | zip | city | state | 45001 New York | NY 07005 New Jersey | NJ FL 33647 Tampa | 33765 | Clearwater | FL 4 rows in set (0.01 sec) How many rows and columns will the result set from the following command have? SELECT zip FROM people UNION ALL SELECT zip FROM zip_code; (a) Number of rows: 4 rows foreign key references zip_code(zip) (b) Number of columns: 1 column How many rows and columns will the result set from the following command have? SELECT zip FROM people UNION SELECT state FROM zip_code; (c) Number of rows: 5 rows (d) Number of columns: 9 columns

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

See similar textbooks

Related questions

A: Here zip_code have total 6 lines of records. Created one view 'local_zip' with state condition and…

Q: Having this information. Students Attribute Name Data Type StudentID char(11) FirstName varchar(20)…

A: Structured Query Language, abbreviated as SQL, which refers to the one it is a domain-specific…

Q: List the order number and order date for every order that was placed by Mary Nelson and that…

A: SQL, or Structured Query Language, is a programming language designed for managing and manipulating…

Q: CARD_NO PLAYER_NO TEAM_CODE PRICE 44 BR 4.45 27 BR 3.5 54 BR vers cards

A: query SELECT team_code,COUNT(card_no) AS TOTAL_CARD_NO, to_char(SUM(price),'$99.99') as total_price…

Q: Having this information. Students Attribute Name Data Type StudentID char(11) FirstName varchar(20)…

A: 1. The MySQL code for the given problem is as follows: CREATE TABLE Students ( StudentID…

Q: Create a LARGE_PROPERTY table

A: Statements are written for MySQL database. Steps: 1. Create table LARGE_PROPERTY 2. Insert Values…

Q: MySql Workbench CREATE TABLE students ( id INT PRIMARY KEY, first_name VARCHAR(50), last_name…

A: As per Bartleby's rules, we can answer the first 3 subparts of a question I have answered Q 1, 2 3…

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
+--
| McFly
Jennifer | Parker
Lorraine | McFly
Tannen
| 1 | Marty
|
2 |
45001
33647
33647
33647
| 07005
| 3 |
| 4 |
Biff
| 5 | George
| McFly
5 rows in set (0.01 sec)
mysql> select from zip_code;
| zip | city
| state |
45001
New York | NY
07005
New Jersey | NJ
FL
33647 Tampa
| 33765 | Clearwater | FL
4 rows in set (0.01 sec)
How many rows and columns will the result set from the following command have?
SELECT zip FROM people UNION ALL SELECT zip FROM zip_code;
(a) Number of rows: 4 rows
foreign key references zip_code(zip)
(b) Number of columns: 1 column
How many rows and columns will the result set from the following command have?
SELECT zip FROM people UNION SELECT state FROM zip_code;
(c) Number of rows: 5 rows
(d) Number of columns: 9 columns

Expert Solution

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!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions

database programming
Update rows in Horse table Using MYSQL The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred Height - decimal number, must be ≥ 10.0 and ≤ 20.0 BirthDate - date, must be ≥ Jan 1, 2015 Make the following updates: Change the height to 15.6 for horse with ID 2. Change the registered name to Lady Luck and birth date to May 1, 2015 for horse with ID 4. Change every horse breed to NULL for horses born on or after December 22, 2016.
SQL Help The Car Maintenance team wants to learn how many times each car is used in every month and day to organize their maintenance schedules. The team wants a table with the following column names and information: Car ID Month Day Count You need to create a summary table using the WITH ROLLUP modifier and grouped by the specific column names, listed above, and send the data back to the team. Query the frequency of each car's use by month and day
SQL FOR THERES TABLES
How many times has each language been used in films? Return the value for all six languages. Display: language name and the number of films
question 6 use the picture below to answer the following question Add a ZIP field/column to the customer table.
Correct Query from table given.
Composite datatypes can only have multi row &multi column values in them Answers: Yes No
Apply the First Normal Form (1NF) and Second Normal Form (2NF) steps to the following two tables. ST_ID ST_Name ST_Major St_Phone ST_Email 100 Marla jen ACCT (703) 111-2222 mjen@gmail.com 110 Jan Bok MGMT (703) 222-3333 jbok@verizon.net 115 Lee Chan MIS (703) 333-4444 (703) 444-5555 lchan@cox.net Table 1 ID Name Courses 1 Ashely Key MIS 302, MIS 303 2 Katy Pery MIS 310 3 Mickey Zen MIS 303, MIS 350 Table 2
sql code sql code sql code
MySQL CREATE TABLE students ( id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), age INT, major VARCHAR(50), faculty VARCHAR(50)); CREATE TABLE location ( id INT PRIMARY KEY, name VARCHAR(50), rooms INT); CREATE TABLE faculty ( id INT PRIMARY KEY, name VARCHAR(50), department_id INT); 4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...6. Find the last name of all employees that were not hired on Tuesday *hint: (UseDATE_FORMAT() function amd the format you need is %W, also use UPPER()7. Find the number of employees in each department who have a manager.8. Find the number of employees for each manager whose employees' minimum salary is greaterthan 5000.9. Find the number of…