Question: TAL SQL Views - 1 (Games) Using the TAL database, create a SQL view based on the following scenario: Francesca is interested in the item

TAL SQL Views - 1 (Games) Using the TAL database, create a SQL view based on the following scenario: Francesca is interested in the item number, description, units of hand, and unit price for TAL Distributors items that are in category GME. Name the View Games. Create a SQL View in MySQL. Submit a screenshot of your statement. Make sure I can see the view listed in the Navigator Pane in the TAL Views subfolder.

TAL SQL Views - 2 (RepCust) Using the TAL database, create a SQL view based on the following scenario: Francesca needs to know the number and name of each rep, along with the number and name of the customer represented by each rep. Create a singe table that contains the rep number, rep name, customer number and customer name. Name the view RepCust. Create a SQL View in MySQL. Submit a screenshot of your statement. Make sure I can see the view listed in the Navigator Pane in the TAL Views subfolder.

TAL SQL - Query View 2A (RepCust) Create a query based on the REPCUST view and the following scenario. Suppose, Megan wants to know the name of the rep for customer 260. Submit a screenshot of your statement. Make sure I can see the query statement and table output in the result grid.

TAL SQL - Query View 2B (RepCust) Create a query based on the REPCUST view and the following scenario. Suppose, Megan wants to create a list of reps by customer names alphabetically. Submit a screenshot of your statement. Make sure I can see the query statement and table output in the result grid.

TAL SQL - Query View 1 (Games) Create a query based on the GAMES view and the following scenario. Suppose, Francesca wants to know which games have a quantity of 25 or less in stock. Submit a screenshot of your statement. Make sure I can see the query statement and table output in the result grid.

TAL SQL Views - 1 (Games) Using the TAL database, create a

Repo RepNurm Last Name First Name Street City State PostalCode Commission Rate Rafael 724 Vinca Dr. Grove CA 900092 $23,457.50 0.06 $41,317.00 0.08 15 Gradey Megan 632 Liatris St. Fulton CA 90085 30 Tian 1785 Tyler Ave. Northfield CA 90098 $27,789.25 0.06 45 Janet 267 Oakley St. CA $0.00 60 90097 0.06 Customer CustomerNum CustomerName Street City State PostalCode Balance Creditlimit RepN Toys Galore 28 Laketon St. Fulton $1,210.25 $7,500.00 15 126 Brookings Direct 452 Columbus Dr. Grove CA 90092 $575.00 $10,000.00 30 260 The Everything 342 Magee St. Congaree CA 90097 $2,345.75 $7,500.00 45 Shop 124 Main St. Northfield CA 90098 386 $879.25 $7,500.00 30 Store 3456 Central Ave. Fullton 90085 S345.00 $5,000.00 45 440 Historical Museum Store Cards and More 167 Hale St. 90104 $5,025.75 $5,000.00 15 Almondton Devon A General Store 3345 $3,456.75 $15,000.00 45 586 Cricket Gift Shop 372 Oxford St. Grove CA 90092 665 $678.90 $7,500.00 30 Cross Store 12 Rising Sun Ave. Congaroe $4,234.60 $10,000.00 15 Unique Gifts 786 Passmore St. Northfield CA 90098 S124,75 $7500.00 45 796 Kline's 945 Gilham St. Mesa $2,475.99 $15,000.00 30 90104 All Season Gifts 382 Wildwood Ave. Fullton $935.75 $7,500.00 15 893 90085 Orders Orderline Order Num Order Date Customer Num Order Nunn Henn Num NumOrdered QuotedPrice 1012/2015 51608 CD33 $86.99 51608 126 1012/2015 KL78 $10.95 51610 334 51610 1013/2015 386 TR40 $13.99 51613 51610 10 1013/2015 DL51 S104.95 51614 2600 51613 1015/2015 S124.95 51617 586 FD11 51614 S115.99 1015/2015 126 51619 51617 1015/2015 586 S116.95 TW35 51623 51617 1016/2015 796 S121.95 51625 FD11 51619 S29.95 DR67 51623 112 S36.95 FH24. 51623 10 $13.10 KD34. 51623 51625 MT03 8 SH5179 tem Item Num Description OnHand Category Storehouse Price AH74. Patience 9 GME $22.99 BR23 Skittles 21 GME $29.99 36 To CD33 Wood Block Set (48 piece) $89.49 12 To I $107.95 DL51 Classic Railway Set 24 PZL DR67 Giant Star Brain Teaser $31.95 I DW23 Mancala 40 GME $50.00 FD11 Rocking Horse 8 TOY $124.95 1 FH24, Puzzle Gift Set 65 PZL $38.95 KA12 Set 56 GME $75.00 KD34 Pentominoes, Brain T 60 PZL $14.95 KL78 Pick Up Sticks 110 GME $10.95 MTo3 Zauberkast Brain Teaser en 45 PZL $45.79 NL89 Wood Block Set (62 piece) 32 TOY $119.75 TR40 Tic Tac Toe 75 GME $13.99 TW35 Fire Engine 30 TOY $118.95 Repo RepNurm Last Name First Name Street City State PostalCode Commission Rate Rafael 724 Vinca Dr. Grove CA 900092 $23,457.50 0.06 $41,317.00 0.08 15 Gradey Megan 632 Liatris St. Fulton CA 90085 30 Tian 1785 Tyler Ave. Northfield CA 90098 $27,789.25 0.06 45 Janet 267 Oakley St. CA $0.00 60 90097 0.06 Customer CustomerNum CustomerName Street City State PostalCode Balance Creditlimit RepN Toys Galore 28 Laketon St. Fulton $1,210.25 $7,500.00 15 126 Brookings Direct 452 Columbus Dr. Grove CA 90092 $575.00 $10,000.00 30 260 The Everything 342 Magee St. Congaree CA 90097 $2,345.75 $7,500.00 45 Shop 124 Main St. Northfield CA 90098 386 $879.25 $7,500.00 30 Store 3456 Central Ave. Fullton 90085 S345.00 $5,000.00 45 440 Historical Museum Store Cards and More 167 Hale St. 90104 $5,025.75 $5,000.00 15 Almondton Devon A General Store 3345 $3,456.75 $15,000.00 45 586 Cricket Gift Shop 372 Oxford St. Grove CA 90092 665 $678.90 $7,500.00 30 Cross Store 12 Rising Sun Ave. Congaroe $4,234.60 $10,000.00 15 Unique Gifts 786 Passmore St. Northfield CA 90098 S124,75 $7500.00 45 796 Kline's 945 Gilham St. Mesa $2,475.99 $15,000.00 30 90104 All Season Gifts 382 Wildwood Ave. Fullton $935.75 $7,500.00 15 893 90085 Orders Orderline Order Num Order Date Customer Num Order Nunn Henn Num NumOrdered QuotedPrice 1012/2015 51608 CD33 $86.99 51608 126 1012/2015 KL78 $10.95 51610 334 51610 1013/2015 386 TR40 $13.99 51613 51610 10 1013/2015 DL51 S104.95 51614 2600 51613 1015/2015 S124.95 51617 586 FD11 51614 S115.99 1015/2015 126 51619 51617 1015/2015 586 S116.95 TW35 51623 51617 1016/2015 796 S121.95 51625 FD11 51619 S29.95 DR67 51623 112 S36.95 FH24. 51623 10 $13.10 KD34. 51623 51625 MT03 8 SH5179 tem Item Num Description OnHand Category Storehouse Price AH74. Patience 9 GME $22.99 BR23 Skittles 21 GME $29.99 36 To CD33 Wood Block Set (48 piece) $89.49 12 To I $107.95 DL51 Classic Railway Set 24 PZL DR67 Giant Star Brain Teaser $31.95 I DW23 Mancala 40 GME $50.00 FD11 Rocking Horse 8 TOY $124.95 1 FH24, Puzzle Gift Set 65 PZL $38.95 KA12 Set 56 GME $75.00 KD34 Pentominoes, Brain T 60 PZL $14.95 KL78 Pick Up Sticks 110 GME $10.95 MTo3 Zauberkast Brain Teaser en 45 PZL $45.79 NL89 Wood Block Set (62 piece) 32 TOY $119.75 TR40 Tic Tac Toe 75 GME $13.99 TW35 Fire Engine 30 TOY $118.95

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

TAL SQL Views - 1 (Games) Using the TAL database, create a SQL view based on the following scenario: Francesca is interested in the item number, description, units of hand, and unit price for TAL...

DUE Fri Feb 10th SQL script at bottom (teacher changed it) Use SQL to make the following changes to the TAL Distributors database (See Figure 1-2, Chapter 1). After each change, execute an...

Due Sunday Feb 12 Details Overview: Use SQL to make the following changes to the TAL Distributors database (See Figure 12, Chapter 1). After each change, execute an appropriate query to sow that the...

We are using, Oracle Database 11g Express Edition, Using SQL. Thank you. Use SQL to make the following changes to the TAL Distributors database (see Figure 1-2 in Chapter 1). After each change,...

In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original TAL...

You must use Oracle for this part. Please show the complete question, query used, and print the query results. Use the TAL Distributors database only. Only odd numbered questions (17,19,21). TAL...

Students will review examples and evaluate them. Review these documents and evaluate them (click on the link): https://1drv.ms/w/s!AoYu6G3CLyuakjVCGipkRkNSBVUB?e=jrPXX6...

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

Needing help with this project anything is appreciated. The model with the relationships is throwing me through a loop. Thanks Database Project Part 1: 150 points Due: See Canvas for Due Dates...

You must use Oracle for this part. Please show the complete question, query used, and print the query results. Use the TAL Distributors database only. Only answer odd numbered questions: 1,3,5,7,9,11...

Describe the comparison of different edge detection algorithms

Annual reports provide significant information about an organizations capital budget and capital budgeting process. Intel Corporation provides financial reports for several years at www.intel.com...

Rhea receives a text informing her that her credit card might have been compromised. The text ? T T k s s her to confirm whether she made a purchase 1 5 minutes ago at a store that is over 2 , 0 0 0...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Are there local events that have been particularly influential in your life?

1. Write down two or three of your greatest strengths.

In 1960, McGregor stated that management does not know enough about how to create the conditions for individual growth and integrity in the group situation. To what degree have theory and practice...