Ask question

Ask question

All categories

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