5. List all the network names and the show names in one single column in the result set. Sort alphabetically. Take a screenshot now and paste it here.

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts
Section: Chapter Questions
Problem 3.7CP
Question

USE UNION TO COMBINE

15. List all the network names and the show names in one single column in the result set. Sort alphabetically.

❖ *Take a screenshot now and paste it here.*
Transcribed Image Text:15. List all the network names and the show names in one single column in the result set. Sort alphabetically. ❖ *Take a screenshot now and paste it here.*
# MySQL Database Structure and Data

Below is a detailed description and data retrieval example from a MySQL database containing information about television networks and shows.

## Table Descriptions

### `NETWORKS` Table
- **Fields**:
  - `id`: Integer, not null, primary key, auto-increment.
  - `name`: Variable character (20), unique names of networks.

```plaintext
| Field | Type         | Null | Key | Default | Extra          |
|-------|--------------|------|-----|---------|----------------|
| id    | int(11)      | NO   | PRI | NULL    | auto_increment |
| name  | varchar(20)  | YES  | UNI | NULL    |                |
```

### `SHOWS` Table
- **Fields**:
  - `ID`: Integer, not null, primary key, auto-increment.
  - `Title`: Variable character (80), title of the show.
  - `Num_episodes`: Integer, number of episodes.
  - `Country`: Variable character (60), country of origin.
  - `Start`: Integer, start year.
  - `End`: Integer, end year (null if still ongoing).

```plaintext
| Field        | Type         | Null | Key | Default | Extra          |
|--------------|--------------|------|-----|---------|----------------|
| ID           | int(11)      | NO   | PRI | NULL    | auto_increment |
| Title        | varchar(80)  | NO   |     | NULL    |                |
| Num_episodes | int(11)      | NO   |     | NULL    |                |
| Country      | varchar(60)  | NO   |     | NULL    |                |
| Start        | int(11)      | NO   |     | NULL    |                |
| End          | int(11)      | YES  |     | NULL    |                |
```

### `SHOW_NETWORK` Table
- **Fields**:
  - `SHOW_ID`: Integer, not null, primary key.
  - `NET_ID`: Integer, not null, primary key, linking shows to networks.

```plaintext
| Field   | Type    | Null | Key | Default | Extra |
|---------|---------|------|-----|---------|-------|
| SHOW_ID | int(11) | NO   | PRI | NULL    |       |
Transcribed Image Text:# MySQL Database Structure and Data Below is a detailed description and data retrieval example from a MySQL database containing information about television networks and shows. ## Table Descriptions ### `NETWORKS` Table - **Fields**: - `id`: Integer, not null, primary key, auto-increment. - `name`: Variable character (20), unique names of networks. ```plaintext | Field | Type | Null | Key | Default | Extra | |-------|--------------|------|-----|---------|----------------| | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(20) | YES | UNI | NULL | | ``` ### `SHOWS` Table - **Fields**: - `ID`: Integer, not null, primary key, auto-increment. - `Title`: Variable character (80), title of the show. - `Num_episodes`: Integer, number of episodes. - `Country`: Variable character (60), country of origin. - `Start`: Integer, start year. - `End`: Integer, end year (null if still ongoing). ```plaintext | Field | Type | Null | Key | Default | Extra | |--------------|--------------|------|-----|---------|----------------| | ID | int(11) | NO | PRI | NULL | auto_increment | | Title | varchar(80) | NO | | NULL | | | Num_episodes | int(11) | NO | | NULL | | | Country | varchar(60) | NO | | NULL | | | Start | int(11) | NO | | NULL | | | End | int(11) | YES | | NULL | | ``` ### `SHOW_NETWORK` Table - **Fields**: - `SHOW_ID`: Integer, not null, primary key. - `NET_ID`: Integer, not null, primary key, linking shows to networks. ```plaintext | Field | Type | Null | Key | Default | Extra | |---------|---------|------|-----|---------|-------| | SHOW_ID | int(11) | NO | PRI | NULL | |
Expert Solution
Table SHOWS:

Computer Science homework question answer, step 1, image 1

Table NETWORKS:

Computer Science homework question answer, step 2, image 1

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
LUP Decomposition
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
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
CMPTR
CMPTR
Computer Science
ISBN:
9781337681872
Author:
PINARD
Publisher:
Cengage