1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Arlecino [84]
3 years ago
12

Create a view named MAJOR CUSTOMER. It consists of the customer number, name, bal. ance, credit limit, and rep number for every

customer whose credit limit is $10,000 or less
a. Write and execute the CREATEVIEW command to create the MAJOR_CUSTOMERview.
b. Write and execute the command to retrieve the customer number and name of each customer in the MAJOR CUSTOMER view with a balance that exceeds the credit limit.
c. Write and execute the query that the DBMS actually executes.
d. Does updating the database through this view create any problems? If so, what are they? If not, why not?
Computers and Technology
1 answer:
Step2247 [10]3 years ago
5 0

Answer:

Following are the solution to the given point:

Explanation:

The solution to this question is defined in the attached in the attached file.

You might be interested in
the volume of two similar solids are 1080cm and 1715cm .if the curved surface area of the smaller cone is 840cm .fond the curved
gavmur [86]

Answer:

A_{big} = 1143.33cm^2

Explanation:

The given parameters are:

V_{small} = 1080

V_{big} = 1715

C_{small} = 840

Required

Determine the curved surface area of the big cone

The volume of a cone is:

V = \frac{1}{3}\pi r^2h

For the big cone:

V_{big} = \frac{1}{3}\pi R^2H

Where

R = radius of the big cone and H = height of the big cone

For the small cone:

V_{small} = \frac{1}{3}\pi r^2h

Where

r = radius of the small cone and H = height of the small cone

Because both cones are similar, then:

\frac{H}{h} = \frac{R}{r}

and

\frac{V_{big}}{V_{small}} = \frac{\frac{1}{3}\pi R^2H}{\frac{1}{3}\pi r^2h}

\frac{V_{big}}{V_{small}} = \frac{R^2H}{r^2h}

Substitute values for Vbig and  Vsmall

\frac{1715}{1080} = \frac{R^2H}{r^2h}

Recall that:\frac{H}{h} = \frac{R}{r}

So, we have:

\frac{1715}{1080} = \frac{R^2*R}{r^2*r}

\frac{1715}{1080} = \frac{R^3}{r^3}

Take cube roots of both sides

\sqrt[3]{\frac{1715}{1080}} = \frac{R}{r}

Factorize

\sqrt[3]{\frac{343*5}{216*5}} = \frac{R}{r}

\sqrt[3]{\frac{343}{216}} = \frac{R}{r}

\frac{7}{6} = \frac{R}{r}

The curved surface area is calculated as:

Area = \pi rl

Where

l = slant\ height

For the big cone:

A_{big} = \pi RL

For the small cone

A_{small} = \pi rl

Because both cones are similar, then:

\frac{L}{l} = \frac{R}{r}

and

\frac{A_{big}}{A_{small}} = \frac{\pi RL}{\pi rl}

\frac{A_{big}}{A_{small}} = \frac{RL}{rl}

This gives:

\frac{A_{big}}{A_{small}} = \frac{R}{r} * \frac{L}{l}

Recall that:

\frac{L}{l} = \frac{R}{r}

So, we have:

\frac{A_{big}}{A_{small}} = \frac{R}{r} * \frac{R}{r}

\frac{A_{big}}{A_{small}} = (\frac{R}{r})^2

Make A_{big} the subject

A_{big} = (\frac{R}{r})^2 * A_{small}

Substitute values for \frac{R}{r} and A_{small}

A_{big} = (\frac{7}{6})^2 * 840

A_{big} = \frac{49}{36} * 840

A_{big} = \frac{49* 840}{36}

A_{big} = 1143.33cm^2

<em>Hence, the curved surface area of the big cone is 1143.33cm^2</em>

4 0
3 years ago
How do i know when someone answered my questions and where can i check what they wrote?
maksim [4K]

Answer:

U can go to your profile, then go to your question to see what they have written.

Explanation: Hope this helps

3 0
3 years ago
In a _error,solution is working but not giving required results
drek231 [11]

Answer:

<h2>it is a random error </h2>

Explanation:

<h3>I HOPE THAT THIS ANSWER HELPS YOU </h3>
7 0
2 years ago
What are the things that a computer literate understands?Name thems.​
vitfil [10]

Answer:

•Determine your IP address.

•Verify physical connectivity to the network.

•Check that you have a logical connection to the network.

•Find out what path network traffic takes to get to its destination.

Translate from DNS names to IP addresses.

4 0
2 years ago
Hilda is troubleshooting a problem with the encryption of data. at which layer of the osi reference model is she working?
Fittoniya [83]
The la<span>yer of the osi reference model that hilda is currently working on is: presentation
On Osi reference model, the presentation layer is created </span><span>to take care of the semantics and syntax of the information exchanged between two systems. The presentation layer will make sure that the receiver of the information will understand the data that being given.</span>
7 0
3 years ago
Other questions:
  • Print either "Fruit", "Drink", or "Unknown" (followed by a newline) depending on the value of userItem. Print "Unknown" (followe
    13·1 answer
  • John would like to move from the city into the suburbs and has been saving up a large down payment for a home. Which is the most
    7·1 answer
  • Which method of accessing FTP has the most limited capabilities?
    9·2 answers
  • B) If you send me an email, then I will finish my program. If you do not send me an email, then I will go to sleep early. Theref
    10·1 answer
  • PLZ HELP What will be the output? class num: def init (self.a): self. number = a mul* __(self. b) return self. number + b. numbe
    7·1 answer
  • What is the best way of farming exotics in destiny?
    12·2 answers
  • You have imported a library with the birthMonth() function. Based on the API, how many strings are inputed to calculate the birt
    11·1 answer
  • The people on this platform are unbelievably nice. its almost rare to see this type of kindness online these days. Just wanted t
    14·1 answer
  • PLS HELP SOON
    15·1 answer
  • PLEASE ANSWER AND HURRY I'LL MARK YOU BRAINLIEST!!<br><br><br>​
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!