Part 1: BB-8 droids are assembled from four major parts: head,antennae, body, and a computer (of course these parts areassemblies of smaller components, but let’s focus on the four majorparts for this exercise). Each new BB-8 created is added to theproduct inventory, increasing the Droid quantity on hand(DroidQOH), while the parts inventory quantity on hand (PartQOH) isreduced by the number of parts used. The following is the currentamount of quantity on hand.
Table: Droids
Table: Parts
DroidType
DroidQOH
Component
PartQOH
BB-8
419
Head
2468
Antennae
6486
Body
2547
Computer
8436
(A) How many database requests are needed for an inventory updatewhen assembling a droid?
(B) Write the database request(s) from part A using SQL.
(C) Write the complete transaction(s)