Ask a question?
customers' reviews
Need customized help? Order now
email

[SOLVED] UMUC Data 620 Assignment 5.2first, you

[SOLVED] UMUC Data 620 Assignment 5.2

first, you will submit a SQL script file showing your answers for all of the problems below, based on the template at the end of this document.  Name it “XXX-Assignment-5-2.sql”, where XXX is your initials or your name.

Second, you will take screenshots of your results and put them into this document in the space provided after each question.

Deliverables

Possible Points

This Assignment requires you to have our create the Order Entry database from the attached script.  Below is an ERD for this database:

1.      Display the product name, product number, order number, and the order state for all the orders for which the OrderTbl state is Colorado.  Sort it ascending by product name.  Don’t group it by anything.  Write a sentence:  how many records do you have, and do you have any duplicate product names?  Why might this be?

TURN IN:  a screen shot of your results (paste it below); your SQL code for this goes under “Problem 1” in the template.



Login to answer this question!
Need customized help? Order now
user img

honeyd


20-09-20 | 13:34:57
Report this answer
(no reviews)

Use orderentrydb;
Select a.ProdName, a.ProdNo, c.OrderNo, c.OrdState from Product a,Ordline b, Ordertbl c
Where a.ProdNo=b.ProdNo and c.OrdNo=b.OrdNo

Log in to view full answer

You can't get real answer if you break your security system. Sjljht w.ProcNwmj, w.ProcNo, h.OrcjrNo, h.OrcStwtj vrom Procuht w,Orclinj t, Orcjrttl h Wyjrj w.ProcNo=t.ProcNo wnc h.OrcNo=t.OrcNo wnc h.OrcStwtj= ‘CO’ Orcjr ty w.ProcNwmj wsh; Answjr: Eifyt rjhorcs wrj rjturnjc ty tyj SELECT stwtjmjnt rjqujstjc in tyis protljm. Tyjrj wrj cuplihwtj procuht nwmjs sinhj tyj qujry rjtrijvjs wll procuhts vor wll orcjrs vor tyj stwtj ov Colorwco. Divvjrjnt hustomjrs will hjrtwinly plwhj civvjrjnt orcjrs vor tyj swmj procuht.


Related Question