Question: Make a SQL from below and the descriptions for each SQL using the tables given below 1. Show Referential Integrity has been establish. (Eg. Try

Make a SQL from below and the descriptions for each SQL using the tables given below
1. Show Referential Integrity has been establish. (Eg. Try deleting something that is
already ordered)
2. Join several tables together.
3. Show several layers of Nested Query.
4. Make a View (Eg. with new heading).
5. An SQL with several compounded conditions.
6. Using the functions such as (Sum, Count, Avg, Max, Min) together with a Group by
Clause.
7. Show the use of Having Clause.
8. Using Aliases.
9. Changing the output titles produce (maybe use || ).

MariaDB [yngah]> SELECT * FROM ITEM; || ITEMID | ITEMNAME + 5 rows in set (0.000 sec) 10101 | LOW FAT PIZZA |

Tables_in_yngah | | CUSTOMER | EMPLOYEE | ITEM | ORDERLINE | ORDERS 5 rows in set (0.000 sec) MariaDB [yngah]> SELECT * FROM CUSTOMER; | CUSTNUM | CUSTFNAME | CUSTLNAME | PHONE | 91810 | LEE |93010 | BILL 94410 | FULTON | 96410 I AL | 99710 JAMES | | | CARL | RAVEN | BROWN SMITH JAKE 5 rows in set (0.000 sec) -+ | 51010 | BRYCE DER I | 52020 | MACY DER I | 53030 | DANNA DER I || 54040 | FROST LIVERY I | 55050 | RAUL LIVERY | +-+ MariaDB [yngah]> SELECT FROM EMPLOYEE; | EMPID | EMPLNAME | EMPFNAME | EMPPHONE PTYPE I | PRESTON | TANNER I VO | KERR | YANG --+ 5 rows in set (0.000 sec) | EMAIL | 423-456-8564 | LEE @GMAIL.COM | 64 SAMSUNG STREET | 141-755-6438 | BILL@GMAIL.COM | 85 CART STREET | 633-123-6151 | FULTON@GMAIL.COM | 71 GROVE STREET | 643-123-9234 | AL@GMAIL.COM | 67 CRYSTAL STREET | 123-456-8888 | JAMES@GMAIL.COM | 12 JUMP STREET | DELIVERYSTREETADDR | STATE | CITY | MIAMI | 17412 | | SAN DIEGO | 73522 | NASHVILLE | 84324 | BUFFALO | 31340 | | MACON | 31610 | | EMPEMAIL | EMPSTREETADDR | EMPSTATE | EMPCITY | 233-473-4561 | BRYCE @GMAIL.COM | 92 MARY STREET | 546-123-6523 | MACY@GMAIL.COM | 82 DELLA STREET | 413-766-1345 | DANNA@GMAIL.COM | 17 KATE ROAD | 623-412-6218 | FROST@GMAIL.COM | 12 BOSTON STREET | NY | 723-464-6534 | RAUL@GMAIL.COM | 24 LENNON LANE | TN I GA | FL | FL | CA | TN | NY | GA | CA | MACON | MIAMI IZCODE I | EMPZCODE | EMPHOURRATE | EM | 31610 | 17412 | SAN DIEGO | 73522 | BUFFALO | 31340 | NASHVILLE | 84324 I I I |--- 31.00 | OR 34.00 | OR 33.00 | OR 29.50 | DE 32.50 | DE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

With the information and screenshots provided I can construct various SQL queries that perform the requested actions Here they are 1 Show Referential Integrity has been established sql DELETE FROM ITE... View full answer

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!

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

What are the appropriate uses for each type of SQL triggers, Data Manipulation Language and Data Definition Language. Describe a real life situation or scenario that would benefit from using a...

The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...

(a) Write an equation describing a sinusoidal transverse wave traveling on a cord in the positive direction of a y axis with an angular wave number of 60 cm-1, a period of 0.20 s, and an amplitude of...

Figure shows a very large non-conducting sheet that has a uniform surface charge density of ? = - 2.00?C/m 2 ; it also shows a particle of charge Q = 6.00?C, at distance d from the sheet. Both are...

A production manager in a manufacturing company would most likely receive a: (a) sales report. (b) income statement. (c) scrap report. (d) shipping department overhead report.AppendixLO1

2. If students have computers, provide lists of Internet help lines.

Shown below is an excerpt from a citys subsidiary ledger for the rst two months of its scal year. Missing is the column that explains or references each of the entries. 1. Prepare the journal entries...

using the 7 valuation criteria, perform a quick assessment of Ascend REIT's investment potential. (Only perform a quick assessment, no need for too much details only main points) 7 Valuation...

Assume the risk-free continuously compounded interest rate is $4 \%$ per annum. For an asset with today's price $A(0)=\$ 100$, you are told that its expected return is $10 \%$ per annum and...

K Miller's Hot Sauce uses a process costing system to determine its product's cost. The last of the three processes is Miller's Hot Sauce Packaging Department Month Ended July 31 Flow of Production...

. Consider the power transmission-line tower shown in the accompanying figure. The members have a cross-sectional area of 10 in and a modulus of elasticity of E = 29 106 lb/in. Using ANSYS, determine...

When Inga finds out that she is to be terminated at 3:00pm, she runs back to her cash drawer at 2:30pm and takes $700 that she suspects that she'll need to live on because the hotel does not give...

A light at the bottom of a fish tank sends two beams upwards to the surface as shown. (Use n = 1.00; n water = 1.33.) Air 45 Water 30 Calculate the path of the rays after they strike the water-air...

In today's world, many organisations are expanding rapidly, and each day, systems perform countless transactions and generate large quantities of new data, some of which are as simple as adding new...

A student, a minor both in fact and appearance, bought on credit and took delivery of a telescope from a 30-year-old seller for an agreed price of $100. Upon reaching her majority soon thereafter,...

1. If the direct method is used to prepare a statement of cash flows, credit sales may not automatically create a cash inflow because? A) some receivables may be uncollectible. B) sales from a prior...

Three forces with magnitudes of 70pounds, 40 pounds, and 60 pounds act on an object at angles of 30, 45, and 135, respectively, with the positive x-axis. Find the direction and magnitude of the...

In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21 through 1-25 in Chapter 1. (If you use a computer to complete these exercises, use a...

For the following exercises, you do not use the Solmaris Condominium database. 1. The DBA asks for your help in planning the data archive for the following Solmaris Condominium database: Location...

Using data from the TAL Distributors database, define a view named TopLevelCust. It consists of the number, name, address, balance, and credit limit of all customers with credit limits that are...

You are given the following set of data: y x1 x2 x3 33 9 192 40 44 11 397 47 34 10 235 37 60 13 345 61 20 11 245 23 30 7 235 35 y x1 x2 x3 45 12 296 52 25 9 235 27 53 10 295 57 45 13 335 50 37 11 243...

The National Association of Realtors Existing-Home Sales Series provides a measurement of the residential real estate market. One of the measurements it produces is the Housing Affordability Index...

You are given the following set of data: y x1 x2 x3 45 40 41 39 41 31 41 35 43 45 49 39 38 43 41 41 50 42 42 51 39 48 40 42 50 44 44 41 y x1 x2 x3 45 42 39 37 43 37 52 41 34 40 47 40 49 35 44 44 45...