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
Find the value of P(-1.5≤Z≤2)
Vladimir [108]

Answer:

  0.9104

Explanation:

Suitable technology can tell you the probability.

P(-1.5≤Z≤2) ≈ 0.9104

__

A phone app gives the probability as 0.9104426667829628.

7 0
3 years ago
When would working with machinery be a common type of caught-in and caught-between<br> hazard?
tigry1 [53]

Answer:

A working with machinery be a common type of caught-in and caught-between  hazard is described below in complete detail.

Explanation:

“Caught in-between” accidents kill mechanics in a variety of techniques. These incorporate cave-ins and other hazards of tunneling activity; body parts extracted into unconscious machinery; reaching within the swing range of cranes and other installation material; caught between machine & fixed objects.

6 0
3 years ago
The function below takes a single parameter, a list of numbers called number_list. Complete the function to return a string of t
makkiz [27]

Answer:

The solution code is written in Python:

  1. def convertCSV(number_list):
  2.    str_list = []
  3.    for num in number_list:
  4.        str_list.append(str(num))
  5.    
  6.    return ",".join(str_list)
  7. result = convertCSV([22,33,44])
  8. print(result)

Explanation:

Firstly, create a function "convertCSV" with one parameter "number_list". (Line 1)

Next, create an empty list and assign it to a new variable <em>str_list</em>. (Line 2)

Use for-loop to iterate through all the number in the <em>number_list</em>.(Line 4). Within the loop, each number is converted to a string using the Python built-in function <em>str() </em>and then use the list append method to add the string version of the number to <em>str_list</em>.

Use Python string<em> join() </em>method to join all the elements in the str_list as a single string. The "," is used as a separator between the elements (Line 7) . At the end return the string as an output.

We can test the function by calling the function and passing [22,33,34] as an argument and we shall see "22,33,44" is printed as an output. (Line 9 - 10)

6 0
3 years ago
4. The instant the ignition switch is turned to the start position,
geniusboy [140]

Answer:

D. Both pull-in and hold-in windings are energized.

Explanation:

The instant the ignition switch is turned to the start position, "Both pull-in and hold-in windings are energized." This is because the moment the ignition switch is turned to the start position, voltage passes through to the S terminal of the solenoid.

The hold-in winding is attached to the case of the solenoid. Similarly, the pull-in winding is also attached to the starter motor. Thereby, the current will move across both windings by getting energized to generate a strong magnetic field.

4 0
3 years ago
In a vehicle with front disc brakes, the vehicle pulls to the left when braking. What causes this?
IrinaVladis [17]
The answer to your question is A
3 0
2 years ago
Read 2 more answers
Other questions:
  • At a high school science fair, Connor won first place for his replica of the Golden Gate Bridge. Connor liked the project so muc
    5·1 answer
  • When using levers like scissors or hedge clippers, what can be done to increase the cutting force so that you don’t have to sque
    5·1 answer
  • Determine the maximum volume in gallons​ [gal] of olive oil that can be stored in a closed cylindrical silo with a diameter of 3
    12·1 answer
  • If a ball is dropped from a height its velocity will increase until it hits the ground, assuming that aerodynamic drag due to th
    6·1 answer
  • Going back the b beginning of the process is common in engineering true or false?
    15·1 answer
  • A steam power plant operating on a simple ideal Rankine cycle maintains the boiler at 6000 kPa, the turbine inlet at 600 °C, and
    11·1 answer
  • Is an ideal way for a high school student to see what an engineer does on a typical day but does not provide a hands-on experien
    9·2 answers
  • Which of the following devices is a simple machine?
    11·2 answers
  • Question
    8·1 answer
  • Please answer i dont understand and dont know the answer​
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!