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
kherson [118]
3 years ago
7

sing data from the BITS database, define a view named TopLevelClient. It consists of the number, name, address, balance, and cre

dit limit of all clients with credit limits that are greater than or equal to $10,000. Using SQL, write the view definition for TopLevelClient. Write an SQL query to retrieve the number and name of all clients as well as the difference between their credit limit and balance in the TopLevelClient view. Convert the query you wrote in Question 2b to the query that the DBMS will actually execute.
Computers and Technology
1 answer:
andreyandreev [35.5K]3 years ago
3 0

Answer:

a. CREATE VIEW TopLevelCust ASSELECT CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimitFROM CustomerWHERE CreditLimit >= 10000b. SELECT CustomerNum, CustomerNameFROM TopLevelCustWHERE Balance > CreditLimit;c. SELECT CustomerNum, CustomerNameFROM TopLevelCustWHERE CreditLimit >= 10000AND Balance > CreditLimit;

Explanation:

You might be interested in
Assume that two students are trying to register for a course in which there is only one open seat. What component of a database
lisabon 2012 [21]

The component of the database that prevents both students from getting the last seat is: transaction isolation

Data that enters the database are expected to maintain accuracy and also be consistent with the database structure.

So, when both students request for the last seat, the possibilities are:

  • <em>Student A gets the seat</em>
  • <em>Student B gets the seat</em>

The following is not a possibility

  • <em>Both students get the seat</em>
  • <em>None of the students gets the seat</em>

The above highlights means that, only one of the students would get the seat.

This is possible because of the concept called transaction isolation.

The transaction isolation ensures that the data requested by a user is <em>complete </em>and such data maintains <em>competency</em>.

So, when a student gets the last seat, the <em>next student </em>would not get the same seat (<em>or any other seat</em>), because a transaction has already been completed.

Read more about transaction isolation at:

brainly.com/question/13030145

8 0
3 years ago
Read 2 more answers
You are critiquing a logo design that one of your coworkers proposed. Your sense is that the individual elements of the design a
oksano4ka [1.4K]

Answer:

Unity.

Explanation:

Graphic design can be defined as an art which typically involves the combination of texts, images and colors to communicate an idea.

In graphic design, unity refers to the harmonious relationship between the various elements in a graphical piece of art, thus, making it appear as a single beautiful piece. Therefore, unity ensure a piece of work does not appear to the viewer as separate pieces but rather presents it as a single piece.

In this scenario, you are critiquing a logo design that one of your coworkers proposed. Your sense is that the individual elements of the design are fine, but when they are combined, they just don’t work well together. Thus, the main problem with this logo is unity.

8 0
3 years ago
Two Smallest (20 points). Write a program TwoSmallest.java that takes a set of double command-line arguments and prints the smal
Ivan

Answer:

Written in Java

import java.util.*;

public class Main {

   public static void main(String args[]) {

     int n;

     Scanner input = new Scanner(System.in);

     n = input.nextInt();

     double nums []= new double [n];

     for (int i=0; i<n;i++)

     {

         nums[i] = input.nextDouble();

     }

     

     Arrays.sort(nums);

     System.out.println("The two smallest are: ");

     for (int i=0; i<2;i++)

     {

         System.out.println(nums[i]);

     }

   }

}

Explanation:

This line declares number of input

     int n;

This line calls the Scanner function

     Scanner input = new Scanner(System.in);

This line gets input from user

     n = input.nextInt();

This line declares an array of n elements

     double nums []= new double [n];

The following iteration gets input into the array

     for (int i=0; i<n;i++)

     {

         nums[i] = input.nextDouble();

     }

This line sorts the array

     Arrays.sort(nums);

The following iteration prints the two smallest

     System.out.println("The two smallest are: ");

     for (int i=0; i<2;i++)

     {

         System.out.println(nums[i]);

     }

4 0
3 years ago
Use the drop-down menus to complete statements about archiving and backing up data fileArchiving data files manages the size of
svetoff [14.1K]

Answer:

Archiving data files manages the size of a mailbox for  

✔ local

storage.

Creating an Outlook data file  

✔ protects

data files in storage on a computer.

Explanation:

Because its right.

3 0
3 years ago
Read 2 more answers
Software that instructs the computer how to run applications and controls the display/keyboard is know as the
andreev551 [17]
Answer:
OS or operating system
5 0
4 years ago
Other questions:
  • Select the correct answer.
    8·1 answer
  • You have connected thirteen pcs and laptops to a wireless network. to make your wlan more secure, what should you do to disallow
    11·1 answer
  • Describe a time when you influenced someone else’s knowledge around technology, whether it be an app, a new gadget, etc. What di
    14·1 answer
  • What is C.R.A.T systems used for?
    9·1 answer
  • A researcher wants to do a web-based survey of college students to collect information about their sexual behavior and drug use.
    7·1 answer
  • If a CPU receives theinstruction to multiply the byte-sized values $12 and $3E, thisaction will take place in the ______________
    13·1 answer
  • Items that represent features of smartphones apps
    12·1 answer
  • The following SQL is which type of join? SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,OR
    15·1 answer
  • A workstation is out of compliance with the group policy standards set by the domain what command prompt would you use to ensure
    5·1 answer
  • Service-oriented architecture includes "reuse." Which of the following is a description of why a business finds it useful? Using
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!