Answered You can buy a ready-made answer or pick a professional tutor to order an original one.
Any one could help with this in a short time span?
Complete work on your Learning Team Database and show the Demo in-class on Tuesday, March 21st, 2017.
Execute the following queries in the Diamond Broker database:
- Submit all your queries that you use to generate the resultsets as requested in below.
- Create a 1-page inventory list showing all the attributes for each diamond in inventory (both in stock and not in stock)
- Show the total price and costs for all in stock inventory items
- Show a 1-page list of all diamonds that are in stock and have a carat weight of over 1.0 carats
- Show a 1-page list of customer names and order numbers for those customers that have placed an order in the past twelve months
- Show a 1-page list of all orders with customer name and include all items that are on that order
If your team works on different database management system, please submit your queries to show all resultsets from each tables and at least 3 Inner-Join queries and 3 Where-clause queries.
- @
- 165 orders completed
- ANSWER
-
Tutor has posted answer for $10.00. See answer's preview
***** 1Query ****** ****** ****** *********************************************** ********************************************************************************************************************************************************************* (InventoryID));ALTERTABLEinventoryALTERCOLUMNinventoryPriceintCREATETABLECustomer(CustomerIDintCustomerNamevarchar(255)primarykey (customerid));altertableOrderTableaddorder_datedatetime;droptableCREATETABLEOrderTable(OrderidintCustomeridintInventoryIDint **************************** ******************* **************************************************** (InventoryID)referencesInventory(InventoryID));---insert **** ***** ************************************ **** 1007'09/04/2015')insertintoOrderTablevalues(3001 **** 1006 ******************************************** 2001 **** ******************************************** **** **** ******************************************** 2000 **** ******************************************** 2001 1009 ******************************************** **** 1010 ******************************************** 2012 **** ******************************************** 2001 1011 ******************************************** **** **** '02/23/2016')insertintoOrderTablevalues(3004 **** 1013 '03/24/2016')---insert statementsinsertintoCustomervalues *********** Kenneth')insertintoCustomervalues (2001'Millie Odhiambo')insertintoCustomervalues *********** ******************************** (2004'Peter Benoit')insertintoCustomervalues (2005'PamellaMukethi')insertintoCustomervalues *********** ******************************* (2007'James ********************************* ************ ********************************* (2009'Williams Kenneth')insertintoCustomervalues (2010'Michaels ****** ************************** ************** ****** ************************** ************** Kenneth') insertintoCustomervalues *********** ********************************* ************ ****** ************************** ************* ****************** **** *************************************** 235 ********************************************************* 236 ********************************************************* 237 ****************** *************************************** *** 1150'VVS2''V-shapE'13'I''Y')insertintoInventoryvalues(1008 239 ***************** 13'J''Y')insertintoInventoryvalues(1009 *** ******************************************************** *** ******************************************************** 289 ********************************************************* *** ****************** 13'E''Y')insertintoInventoryvalues(1013 700 ********************************************************* 600 ********************************************************** *** ****************** ******************************************************* ** 1-page ********* list ******* *** *** attributes for **** diamond ** ********* ***** ** ***** *** *** in ********************************* *** ***** ***** and costs *** all ** ***** ********* ********************************************************************* * ****** **** ** *** ******** **** *** ** ***** *** **** * carat ****** ** **** ** *********************************************************** ******** * ****** list ** ******** ***** *** ***** ******* *** ***** ********* **** have placed ** ***** in *** **** twelve ***************************************************************************************************************************** * ****** **** ** *** ****** **** customer **** and ******* all ***** that *** on that *******************************************************************************
