SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 3 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 20 Dec 2017 My Price 10.00

query retrieves the currency ratio for the currency

DDL is attached in order to answer the following: PLEASE EXECUTE in SQL SERVER

 

-What if you are asked to give the price of a flowing skirt in Cancun? you need two queries. Your first query retrieves the currency ratio for the currency

accepted in Cancun. Your second query hardcodes the currency ratio retrieved in the

first query, in order to determine the price in Cancun. this use case asks for the store location

by name in order to retrieve whatever currency is accepted by that location.

Capture a screenshots of both queries and the results of their execution.

 

-5. The legal form and size limitation of a value is one significant component that

determines how a value will be displayed in the result of a SQL query, and you get a

chance to explore it for yourself in this step. We now know it is the datatype that

constrains to a set of legal values and a size limitation.

Identify any one of the datatypes referred to in step 4, or even one of another of

your own choosing, that has a size limitation that you can control. Then do the

following:

a. Explain the datatype in a few sentences – the set of legal values allowed by the

datatype, the syntax of specifying the maximum size allowed for the column, and

what the size limitation means for that particular datatype.

b. Create a table with a name of your choosing that has just one column, and give the

column the datatype you identified along with a size limitation of your choosing.

c. Attempt to insert a value that exceeds the size limitation on the column and see

what error message your DBMS gives you.

Make sure to capture screenshots for parts b and c.

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 20 Dec 2017 02:12 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)