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
fgiga [73]
4 years ago
14

Using data from a tal distribution database, define a view named toplevelcust. it consists of the number, name, address, balance

and credit limit of all customers with credit limits that are greater than or equal to $10,000.
a. using sql, write the definition for toplevelcust.
b. write an sql query to retrieve the number and name of all customers as well as the difference between their credit limit and balance in the toplevelcust view.
c. convert the query you wrote in question 2b. to the query that the dbms will actually execute.
Computers and Technology
2 answers:
valentina_108 [34]4 years ago
7 0
A) CREATE TABLE toplevelcust (number INTEGER PRIMARY KEY, <span> name TEXT, address TEXT, balance DOUBLE, credit DOUBLE</span>);

b) select number, name, credit - balance from toplevelcust

c) This I cannot answer
natali 33 [55]4 years ago
7 0

Answer:

<u>Option-</u> A.

  • Using sql, write the definition for toplevelcust.                                                            

Explanation:

  • Using data from a tal distribution database, define a view named toplevelcust. it consists of the number, name, address, balance and credit limit of all customers with credit limits that are greater than or equal to $10,000.It is by using the sql, write the definition for toplevelcust.
You might be interested in
Which of the following is a strategy used to enhance communication in a presentation?
Ann [662]
I believe the answer could be A
7 0
3 years ago
Imagine that you have access to a class named MyCircle that has void setRadius(double r) and double getRadius() methods. Write a
Nikitich [7]

Code for the method described in the question in java:

public static double averageRadius(MyCircle[] myCircles) {

       double sum = 0;

       for (MyCircle myCircle: myCircles) {

           if(myCircle.getRadius() < 0) myCircle.setRadius(0);

           sum += myCircle.getRadius();

       }

       return sum / myCircles.length;

   }

And the complete program:

import java.util.Random;

public class MyCircle {

   private double radius;

   public double getRadius() {

       return radius;

   }

   public void setRadius(double radius) {

       this.radius = radius;

   }

   public static double averageRadius(MyCircle[] myCircles) {

       double sum = 0;

       for (MyCircle myCircle: myCircles) {

           if(myCircle.getRadius() < 0) myCircle.setRadius(0);

           sum += myCircle.getRadius();

       }

       return sum / myCircles.length;

   }

   public static void main(String[] args) {

       Random random = new Random();

       int N = 10;

       MyCircle[] myCircles = new MyCircle[N];

       for (int i = 0; i < myCircles.length; i++) {

           myCircles[i] = new MyCircle();

           myCircles[i].setRadius(random.nextInt(100));

           System.out.printf("Created MyCircle %d with radius %.2f \n", i, myCircles[i].getRadius());

       }

       System.out.printf("\nAverage radius of %d circles is %.2f \n", N, MyCircle.averageRadius(myCircles));

   }

}

The output was:

Created MyCircle 0 with radius 76.00

Created MyCircle 1 with radius 86.00

Created MyCircle 2 with radius 38.00

Created MyCircle 3 with radius 4.00

Created MyCircle 4 with radius 8.00

Created MyCircle 5 with radius 39.00

Created MyCircle 6 with radius 77.00

Created MyCircle 7 with radius 78.00

Created MyCircle 8 with radius 39.00

Created MyCircle 9 with radius 46.00

Average radius of 10 circles is 49.10

7 0
3 years ago
Which tab provide text formatting features
kirill [66]

Answer:

Home tab

Explanation:

Assuming that this question is based on providing text formatting features in Microsoft Word, this feature is found on the Home tab in the Font group or the Font dialog box. Some of these formatting features include underline style, colour, strikethrough, superscript, and subscript.

4 0
4 years ago
What is software? what are two types of software?​
mel-nik [20]
Software is the programs and other operating information used by a computer. Two types of software are system software and Application software. Hope this helps :)
3 0
3 years ago
A _____ is a predefined text format that includes multiple formatting options.
VladimirAG [237]
A style is a predefined text format that includes multiple formatting options.
7 0
3 years ago
Other questions:
  • The more critical a component or service, the higher the level of availability required. True False
    5·1 answer
  • Which type of peripheral is a keyboard?
    11·2 answers
  • A(n ________ is information that is passed to a function, and a(n ________ is information that is received by a function.
    15·1 answer
  • A PenTester has successfully exploited a remote host on a clients’ network. They want to create a backdoor on the host for futur
    11·1 answer
  • What is the most common concern with using variable frequency drives?
    6·1 answer
  • A small group of travelers is meeting inside an ancient building, and the travelers need access to the Internet using their mobi
    11·1 answer
  • Which of the following is not an example of debugging? looking for errors in programming code. fixing misspelled commands in pro
    13·1 answer
  • According to the passage, what are the goals of the<br> program? Check all that apply.
    11·1 answer
  • If we ignore the audio data in a video file, a video file is just a collection of many individual frames (i.e., images). What is
    6·1 answer
  • Genres are useful for many reaseons. What are some explanations you can think of for how genres can be useful to players, game d
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!