MySQL Learning Team Assignment

profilegamarra.dannbk
Home>Homework Answsers>Computer Science homework help

Hello,

 

I am taking an Database (My SQL) class, and I need help with this assignment for week 4. I need this done by Saturday 03/18/2017

I have attached the previous weeks assignments as reference for week 4.

 

Week 4 Assignment

Complete work on your Learning Team Database.

Execute the following queries in the Diamond Broker database:

  • Create an 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

 

Thanks,

  • 9 years ago
  • 15
Report issue
Answer(1)
profile
IT_Expert
4.8 (178)
4.8 (71)
Chat

Purchase the answer to view it

blurred-text
  • attachment
    week_4_assignment.docx
  • attachment
    diamond_broker_database.pptx
  • attachment
    database.zip
Bids(1)