1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Volgvan
3 years ago
15

James River Jewelry is a small jewelry shop. While James River Jewelry does sell typical jewelry purchased form jewelry vendors,

including such items as rings, necklaces, earrings, and watches, it specializes in hard-to-find Asian jewelry. Although some Asian jewelry is manufactured jewelry purchased from vendors in the same manner as the standard jewelry is obtained, many of the Asian jewelry pieces are often unique single items purchased directly from the artisan who created the piece (the term "manufactured" would be an inappropriate description of these pieces). It has a small but loyal clientele, and it wants to further increase customer loyalty by creating a frequent buyer program. In this program, after every 10 purchases, a customer will receive a credit equal to 50 percent of the sum of his or her 10 most recent purchases. This credit must be applied to the next (or "11th") purchase. Assume that James River designs a database with the following tables. CUSTOMER (CustomerID, LastName, FirstName, Phone, Email) PURCHASE (InvoiceNumber, InvoiceDate, PreTaxAmount, CustomerID) PURCHASE_ITEM (InvoiceNumber, ItemNumber, RetailPrice) ITEM (ItemNumber, Description, Cost, ArtistName) The referential integrity constraints are: CustomerID in PURCHASE must exist in CustomerID in CUSTOMER InvoiceNumber in PURCHASE_ITEM must exist in InvoiceNumber in PURCHASE ItemNumber in PURCHASE_ITEM must exist in ItemNumber in ITEM Assume that CustomerID of CUSTOMER, ItemNumber of ITEM, InvoiceNumber of PURCHASE, and ItemNumber of PURCHASE_ITEM are all surrogate keys with values as follows: CustomerID Start at 1 Increment by 1 InvoiceNumber Start at 1 Increment by 1 ItemNumber Start at 1 Increment by 1 Write SQL statements and answer questions for this database as follows: A. Write SQL CREATE TABLE statements for each of these tables. B. Write foreign key constraints for the relationships in each of these tables. Make your own assumptions regarding cascading deletions and justify those assumptions. (Hint: You can combine the SQL for your answers to parts A and B.) C. Write SQL statements to insert at least three rows of data into each of these tables. Assume that surrogate key column values will be supplied by the DBMS. D. Write SQL statements to list all columns for all tables. E. Write an SQL statement to list ItemNumber and Description for all items that cost more than $100. F. Write an SQL statement to list ItemNumber and Description for all items that cost more than $100 and were produced by an artist with a last name ending with the letters son. G. Write an SQL statement to list LastName and FirstName of customers who have made at least one purchase with PreTaxAmount greater than $200. Use a subquery. H. Answer part G but use a join using JOIN…ON syntax. I. Write an SQL statement to list LastName and FirstName of customers who have purchased an item that costs more than $50. Use a subquery. J. Answer part I but use a join using JOIN…ON syntax K. Write an SQL statement to list LastName and FirstName of customers who have purchased an item that was created by an artist with a last name that begins with the letter J. Use a subquery. L. Answer part K but use a join using JOIN…ON syntax M. Write an SQL statement to show the Name and sum of PreTaxAmount for each customer using JOIN…ON syntax. N. Write an SQL statement to show the sum of PreTaxAmount for each artist (hint: the result will have only one line per each artist). Use a join using JOIN…ON syntax, and sort the results by ArtistLastName in ascending order. O. Write an SQL statement to show the sum of PreTaxAmount for each ArtistName but exclude any items that were part of purchases with PreTaxAmount less than $25. Use a join using JOIN…ON syntax, and sort the results by ArtistLastName in descending order. P. Write an SQL statement to show which customers bought which items, and include any items which have not been sold. Includes CUSTOMER.LastName, CUSTOMER.FIRSTName, InvoiceNumber, InvoiceDate, ItemNumber, ItemDescription, ArtistLastName, and ArtistFirstName. Use a join using JOIN…ON syntax, and sort the results by ArtistLastName and ArtistFirstName in ascending order. Q. Write an SQL statement to modify all ITEM rows with an artist last name of Baxter to an artist first name of Rex. R. Write SQL statements to switch the values of ArtistLastName so that all rows currently having the value Baker will have the value Baxter, and all rows currently having the value Baxter will have the value Baker.

Engineering
1 answer:
Sveta_85 [38]3 years ago
7 0

Answer:

This question is comprising many parts (a to r). That is impossible to answer in one sheet. Following are attached images having answers to most of the parts.

I hope it will help you a lot.

Explanation:

You might be interested in
Liquid water is fed to a boiler at 24°C and 10 bar is converted at a constant pressure to saturated steam.
zepelin [54]

We can find the change in the enthalpy through the tables A5 for Saturated water, pressure table.

For 1bar=1000kPa:

T_{sat}=179.88\°c

H_{fg} = 2014.6kJ/kg

c_p=4.18 kJkg^{-1}{K^{-1}

\nu_g = 0.19436m^3/kg

Replacing,

\Delta h = h_{fg}+c_p(T_{sat}-T_{inlet})

\Delta h = 2014.6+4.18(179.88-24)

\Delta h=2666.17kJ/kg

With the specific volume we know can calculate the mass flow, that is

\dot{m}=\frac{\frac{15000}{3600}}{0.19436}

\dot{m} = 21.4378kg/s

Then the heat required in input is,

Q=\dot{m}\Delta h

Q=21.4378*2666.17

Q=57157.036kW

With the same value required of 15000m^3/h, we can calculate the velocity of the water, that is given by,

V= \frac{\dotV}{A}

V = \frac{\frac{15000}{3600}}{\pi /4 *(0.15)^2}

V=235.79m/s

Finally we can apply the steady flow energy equation, that is

\dot{m}(h_1+\frac{V^2}{2000})+Q = \dot{m}h_2

Re-arrange for Q,

Q=\dot{m}(h_2-h_1-\frac{V^2}{2000})

Q=\dot{m}(\Delta h-\frac{V^2}{2000})

Q= (21.4378)(2666.17-\frac{235.79^2}{2000})

Q= 56560.88kW

We can note that consider the Kinetic Energy will decrease the heat input.

4 0
3 years ago
Concrete ___ support and anchor the bottom of steel columns and wood post, which support beams that are pare of framing system o
dolphi86 [110]
I wanna say it’s D post support
3 0
2 years ago
A closed system of mass 10 kg undergoes a process during which there is energy transfer by work from the system of 0.147 kJ per
mr_godi [17]

Answer:

-50.005 KJ

Explanation:

Mass flow rate = 0.147 KJ per kg

mass= 10 kg

Δh= 50 m

Δv= 15 m/s

W= 10×0.147= 1.47 KJ

Δu= -5 kJ/kg

ΔKE + ΔPE+ ΔU= Q-W

0.5×m×(30^2- 15^2)+ mgΔh+mΔu= Q-W

Q= W+ 0.5×m×(30^2- 15^2) +mgΔh+mΔu

= 1.47 +0.5×1/100×(30^2- 15^2)-9.7×50/1000-50

= 1.47 +3.375-4.8450-50

Q=-50.005 KJ

7 0
3 years ago
Read 2 more answers
True or false? if i were to hook up an ac voltage source to a resistor, the voltage drop across the resistor would be in phase w
hodyreva [135]

Answer: True

Explanation:

4 0
2 years ago
When designing a car that runs on wind or Air car . can you tell me the details for the following points Compressed Air Engine:
BabaBlast [244]

Answer:

a)

The crack and connecting rod is used in the design of car.This mechanism is known as slider -crank mechanism.

Components:

1.Inlet tube

2. Wheel

3. Exhaust

4. Engine

5.Air tank

6.Pressure gauge

7.Stand

8. Gate valve

b)

The efficiency of air engine is less as compare to efficiency of electric engine and this is not ecofriendly because it produce green house gases.These gases affect the environment.

c)

it can run around 722 km when it is full charge.

                                                                                                                                                     

5 0
3 years ago
Other questions:
  • How I do I get nut out of sheets​
    8·2 answers
  • Air is compressed in a piston-cylinder device. List three examples of irreversibilities that could occur
    13·1 answer
  • When storing used oil, it need to be kept in________ container?
    11·1 answer
  • What is a two stroke engine and what is a four stroke engine, please keep the definitions as simple as can be and please explain
    8·2 answers
  • Create a Python program that will produce the following output:
    7·1 answer
  • A long bone is subjected to a torsion test. Assume that the inner diameter is 0.375 in. and the outer diameter is 1.25 in., both
    14·1 answer
  • When a user process is interrupted or causes a processor exception, the x86 hardware switches the stack pointer to a kernel stac
    13·1 answer
  • 1. In order to minimize hazards, what should you do before starting a job
    10·2 answers
  • Plz help If an item is $13.00 for a case of 24, then it is $
    11·2 answers
  • Which pipe for water is best for construction?
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!