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.

Answers

Answer 1
a) CREATE TABLE toplevelcust (number INTEGER PRIMARY KEY,  name TEXT, address TEXT, balance DOUBLE, credit DOUBLE);

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

c) This I cannot answer
Answer 2

Answer:

Option- 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.

Related Questions

4. Suppose you have two credit cards. The first has a balance of $410 and a credit limit of $1,000. The second has a balance of $510 and a credit limit of $1,000. What is your overall credit utilization?

Answers

Credit Utilization = Credit Balance / Credit Limit * 100For N-cards, Credit utilization = (credit Utilization of Card1 + credit Utilization of Card1 +  .... credit Utilization of CardN ) / N
For our case: Credit Utilization for Card 1 (CU1) = $410/$1000 = 0.410 = 41%Credit Utilization for Card 1 (CU2) = $510/$1000 = 0.510 = 51%Overall credit Utilization = Average of all the CUs for all the cards = (CU1 + CU2)/2 = 46%

You've formatted the first paragraph of a document. What button can you use to apply the formatting from the first paragraph to the next paragraph in the document?
    
  A. Format Painter
  B. Copy
  C. Cut
  D. Paste

Answers

The option that best answers the given question is (A) format painter. Format painter is a tool that you can use when you need to copy formatting from one object to another.

Thus, in the case study given, where you want to copy the formatting of a paragraph to another’s, it is best to use format painter. Cut, paste, and copy will not help you.

Technology that is attached to a tag and used to identify postal packages is a(n) _____.
smart card
database
RFID
digital ink pen

Answers

Technology that is attached to a tag and used to identify postal packages is a(n) RFID.
__________________________________________________________

RFID:  Radio-Frequency Identification

The correct option is C. Technology that is attached to a tag and used to identify postal packages is an RFID.

Radio waves are used in radio frequency identification (RFID) technology to identify individuals or objects. There is a device that can read data from a wireless device or "tag" without making physical contact or requiring a line of sight from a distance.

What frequency does RFID use?

RFID High-Frequency (HF) Between 3 and 30 MHz make up the HF band. The majority of HF RFID systems run at 13.56 MHz, with reading ranges ranging from 10 cm to 1 m. Moderate interference sensitivity affects HF systems. Applications for data transfer, payment, and ticketing frequently use HF RFID.

Electromagnetic fields are used by radio-frequency identification (RFID) to automatically recognize and track tags that are fastened to objects. A radio transmitter, receiver, and tiny radio transponder make up an RFID system.

Thus, the ideal selection is C.

Learn more about radio frequency identification here:

https://brainly.com/question/28272536

#SPJ2

3k means about 3 thousand bytes. How would you express four trillion bytes?

Answers

Hello!

Four trillion bytsz will be expressed as "4T".

T stands for trillion.

Melissa and Sue want to distribute a document to be discussed at a meeting starting in about thirty minutes. People will be attending the meeting by phone from two other locations.They learn that the computer network is not working, so they are unable to send an e-mail with an attachment. They should _____.

type an e-mail and wait for the network to work again

try to call everybody and cancel the meeting

fax the document to each location

use a word processor to retype the document and print it

Answers

The answer is (c) fax the document to each location


Since fax machines are all connected to the old telephone lines, when used, they place a phone call to the number you have specified. This machine at the destination number on the other end receives and the transmission of documents is done over a telephone call. 

Melissa and Sue will also be in a position to send this fax using a computer if the computer will be connected to the phone line and a presence of a dial-up fax modem.




If a user has two texts selected, the Reveal Formatting pane allows the user to

compare the word counts of the two texts.
insert tables into both texts.
spell-check both texts.
compare the fonts of the two texts.

Answers

The answer is (D) compare the fonts of the two texts.

Word has a reveal formatting feature that allows one to see how selected text has been formatted. This feature is important since it allows you to tell at a glance what formatting has been used. To use this tool, press the combination keys shift+f1 and the reveal formatting pane will pop up.






The _____ unit is the preferred style unit for web page text because it makes it easy to develop pages in which different page elements have consistent relative font sizes under any device.

Answers

em The answer that you are looking for is (em)

Answer:

"Ems"  (em)

Explanation:

“Ems” (em): Is is a scalable unit that is used in web page text or markup language like HTML, it allows page elements have a consistent relative font sizes.

It is important to know that an em (1em) is equal to the current font-size, for instance, if the font-size of the document is 10pt, 1em is equal to 10pt. Ems are scalable in nature, so 2em would equal 20pt.

Which brand recently acquired by Microsoft was originally created in Sweden?

Answers

Mojang Studios, creator of Mine-craft , was acquired by Microsoft in 2014, marking a significant milestone in gaming history.

1. Mojang Studios: Mojang Studios is the Swedish video game developer behind the immensely popular game Mine-craft . Founded in 2009 by Markus Persson, also known as "Notch," and co-founders Carl Manneh and Jakob Porsér , the company gained widespread acclaim for Mine-craft's  innovative gameplay and open-world sandbox design.

2. Acquisition by Microsoft: In September 2014, Microsoft announced its acquisition of Mojang Studios for a staggering $2.5 billion. This acquisition marked Microsoft's foray into the world of gaming and bolstered its position in the industry.

3. Impact on Mine-craft : Despite the acquisition, Mine-craft has retained its distinct identity and continued to flourish under Microsoft's ownership. The game's popularity has only grown, reaching millions of players across various platforms, including PC, consoles, and mobile devices.

4. Expansion and Development: Under Microsoft's stewardship, Mojang Studios has expanded its portfolio beyond Mine-craft, developing spin-offs, such as Mine-craft Dungeons, and exploring new ventures within the gaming realm.

5. Cultural Influence: Mine-craft's cultural impact remains significant, with its influence extending beyond gaming into realms such as education, architecture, and creative expression. The game's simple yet versatile mechanics have made it a favorite among players of all ages worldwide.

6. Legacy: The acquisition of Mojang Studios by Microsoft stands as a milestone in both companies' histories, demonstrating the power of innovation and creativity in the gaming industry while showcasing the potential for fruitful collaborations between established giants and emerging talents.

What term refers to the combining of voice, video and text-processing and access to multiple network platforms from a single device?

Answers

The answer is Digital Convergence

This term in context refers to the combination of more than two different technologies into a single device. Typically, it is the convergence of 4 industries (I.T, Consumer Electronics, Telecommunication, and entertainment) into one conglomerate. 

An example is how a cell phone is able to take pictures. This example is a combined functionality of a camera and a telephone







The correct answer should be Digital Convergence

how the average temperature changes in the first 5 months of the year

Answers

If you could specify the temperature of what you need would be better, like the temperature of the earth or such. But from what I can guess is that temperature changes because of the Earth's tilt and revolution around the sun causing seasons and the moon orbiting the earth which cause the day and nights we experience.

hope this benefits at least a portion of your question

I think these might be the answers but im not to sure, so am I right? or wrong? please help
1.)B
2.)A
3.)True
4.)B

1.) An education application would most likely do which of the following?
A.)Allow users to watch popular movies and TV shows
B.) Connect users with social and business contacts
C.) Confirm users' travel plans
D.) Teach users a new language

2.)How does a Graphical User Interface (GUI) on a touchscreen interface differ from a GUI on a desktop or laptop?
A.)A finger or stylus is used instead of a pointer.
B.) A magic wand is used instead of a pointer.
C.)Users speak commands instead of using a pointer.
D.)Users visualize commands instead of using a pointer.

3.)A copyright gives the exclusive legal right to the original author or creator to print, publish, perform, record, or produce material.
True
False

4.)An education application would most likely do which of the following?
A.)Allow users to watch popular movies and TV shows
B.)Connect users with social and business contacts
C.)Confirm users' travel plans
D.)Teach users a new language





Answers

Number 1 and 4 are the same? I agree with your answers.

1. D) Teach users a new language

2. A)A finger or stylus is used instead of a pointer.

3.  True

4. D)Teach users a new language

Poor language skills can lead to a (an) ______?

Answers

If you are referring to this question:
What kind of block can result from poor language skills?
Poor language skills can lead to a (an) ______

The answer would be a mental block. This is a common occurrence when learning things, but it is notable in language learning. At times, they also call this a plateau of the mind. Poor language skills can impede the train of thought, which can also cause this type of block.

Write a while loop that assigns summedvalue with the sum of all values from 1 to usernum. assume usernum is always greater than or equal to 1. note: you may need to define additional variables.

Answers

Hi,

The program starts here
__________________________________________________________

public class sumval

    public static void main(int usernum)
        {
              int summedvalue;
              int i=1;
                  while(i<=usernum)
                     {
                           summedvalue = summedvalue + 1;
                           i++;
                       }
                System.out.println("SUM OF VALUES IS ="+summedavalue);
         }
}

The records in a database table are generally visualized as​ ________.
a. fields
b. relationships
c. rows
d. files
e. attributes

Answers

The records in a relational database table are generally visualized as fields.
The data in database  is stored in records that contains all the data about one particular item in the database. Each record is composed of fields. The field is a single piece of data such as name, date of birth or telephone number. 
The fields of all records form the columns.

When servers need operating system upgrades or patches, administrators take them offline intentionally so they can perform the necessary work without risking malicious attacks?

Answers

The answer is True

Unintentional downtime which is as a result of malicious attacks is less common. Research however indicates that it is growing rapidly. Downtime can be unintentional or intentional. Many times, admins schedule intentional downtime in advance. They try to this so that it has a small impact on the rest of the organization.


Given the code below, what would output to the Console Window?

Think carefully on this one...it is tricky!
C#
1
string a = ”10”;
2
string b = “20”;
3
Console.WriteLine(a+b+5);

Answers

I don't know C# but based on experiences in other OOP languages and languages in general, you get a type error, whatever format that may be for C#. You cannot concatenate "10" and "20" as strings and then attempt to add an integer 5 unless the language has inferred type coercion.

Investments in data networks, ip addresses, routers, and switches are ________ because of their impact on productivity, security, user experiences, and customer service.

Answers

Investments in data networks, IP addresses, routers, and switches are business decisions because of their impact on productivity, security, user experiences, and customer service.
The goal of the business decision is to choose the next step for the  business that will lead to greater success.

who maintains control over the 529 plan

Answers

The account holder. They maintain control over it.

The Account Holder On Apex.......Hope this helps you

Hard drive storage is considered to be solid state. true or false

Answers

i think it is true, to be honest



Final answer:

The statement that hard drive storage is considered to be a solid state is false. Hard drives use magnetic storage techniques, while solid-state drives use flash memory without moving parts.

Explanation:

The statement that hard drive storage is considered to be a solid state is false. Hard disk drives (HDDs) utilize magnetic storage to save and retrieve digital information through rotating disks, or platters, which are coated with a ferromagnetic material. Information is written to and read from these platters using a read/write head. On the other hand, solid-state drives (SSDs) use flash memory for data storage, which means there are no moving parts involved, and they rely on semiconductor chips.

Hard disk drives have been the mainstay of persistent storage due to their ability to store vast amounts of data. Indeed, the storage density of HDDs can be quite impressive, with modern hard drives achieving a storage capacity of up to 1 TB on a 2.5" drive. However, as the need for faster access speed becomes more critical, especially in the context of computing where CPUs operate at much higher speeds, the use of solid-state drives has grown significantly. With their non-mechanical design, SSDs provide substantially faster data access times compared to HDDs.

Given the code below, how many times would "I love C#" be output to the Console Window?
1
int counter = 10;
2
while (counter>5) {
3
Console.WriteLine("I love C#");
4
counter++;
5
}
C#

0

10

11

Infinite Loop

Answers

The answer is infinite loop the program would continue executing since the statement parameters are met by counter 10 being greater than 5
I'm relatively new to coding but that looks like an infinite loop.

The * key is used for _____.
addition
subtraction
multiplication
division

Answers

the * key is used for multiplication
The answer is multiplication

Which social networking site became a gaming platform after 2009?

Answers

It is hi5 if I’m a Plato class
Its hi5 i just know bc of guy above lol

Dani has drawn some shapes in a PowerPoint presentation about ice skating and would like to make it look like the shapes are resting on the ice rink.
What would most likely be the fastest and easiest way for Dani to do this?

A. Dani should copy each shape, paste it below the original, and use the rotate tool to spin it around so that it is a mirror image of the original.
B. Dani should draw under the originals new shapes that are mirror images, and she should make the new shapes brighter colors than the originals.
C. Dani should use the Styles gallery to find a style that makes a shape look like it is resting on glass.
D. Dani should use Shape Effects for each original shape to add a Reflection effect under each one.

Answers

ANSWER: D. Dani should use Shape Effects for each original shape to add a Reflection effect under each one.

EXPLANATION: Dani should use the Shape Effects for the original shapes because that would add a reflection effect under each individual shapes. As Dani wants to portray the shapes as if they are resting on ice rink, it is usual for ice rinks to reflect images on it. The shape reflection that would be added by the Shape effect will be similar to what it should look like if any thing reflects on ice rink.

A. Dani should copy each shape, paste it below the original, and use the rotate tool to spin it around so that it is a mirror image of the original.

How is the Microsoft Word 2013 window organized?

with contextual tabs for major groupings of editing features and ribbons with specific groupings to organize commands
with drop-down menus for each editing icon organized by contextual ribbons of data
with ribbons for each major grouping and drop-down lists for all editing options
with dialog boxes for each major grouping and ribbons within the dialog box to choose formatting option

Answers

The answer is (A): with contextual tabs for major groupings of editing features and ribbons with specific groupings to organize commands.


Contextual tab or tabs are hidden menu that appears when objects like images or texts are selected in programs like MS Word 2013. They typically contain one or more commands applicable to a selected text or object only. They are there in the Ribbon when you need them and disappear when you do not need them anymore. They are basically used for major groupings of editing features.
A ribbon on the other hand help users understand how commands are used directly and efficiently. It organizes a program’s features into a series of tabs.




Answer:A

Explanation:

In powerpoint,

The Notes button is used to
A. enter speaker notes that will appear on the slide.
B. enter speaker notes that won't appear on the slide.
C. leave a comment on the slide.
D. add text onto the slide.

Answers

Final answer:

In PowerPoint, the Notes button is used to enter speaker notes that won't appear on the slide, intended to aid the presenter during their talk, not for collaboration or feedback like comments.

Explanation:

The Notes button in PowerPoint is used to enter speaker notes that won't appear on the slide during the presentation. These notes are meant to help the presenter during the speech or presentation by providing additional information or reminders about what to say when a particular slide is being displayed. It's important to note that speaker notes are different from comments, which are typically used for collaboration and providing feedback on the slide content. Comments can be added by highlighting text and clicking New Comment in the tools ribbon to create a comment box in the margin, where you can type your comment. However, comments are not the same as the notes that a presenter might refer to while delivering a PowerPoint presentation.

Final answer:

The Notes button in PowerPoint is for entering speaker notes that are not displayed on the slides, helping presenters during a presentation with additional cues and content.

Explanation:

The Notes button in PowerPoint is used to enter speaker notes that won't appear on the slide. This feature allows presenters to add additional information and reminders that can help during a presentation, without cluttering the slide visible to the audience. Speaker notes are a great way to prepare for a presentation as they can hold cues and additional content that the presenter may refer to.

They are different from comments, which are typically used to give feedback or collaborate on the slide content with others, and are also distinct from the text appearing on the slides themselves, which is meant for the audience to read.

In the replace dialog box, clicking what button changes highlighted text

Answers

In the Replace dialog box, clicking on either “replace” or “replace all” button will change the highlighted text and replace it with the new text you have specified in the “replace with” text field. The highlighted text is a result of finding a specific word and the dialog box gives you the option to replace the found word with a new text. It is more appropriately referred to as the “Find and Replace dialog box.”

ANSWER: Replace Button

EXPLANATION: After opening the replace dialog box and putting the desired values in the boxes, we need to click the 'Replace' button to change the highlighted text. If the word which needs to be changed appear multiple times in the document, then clicking on 'Replace All' is advised as it would change all the old words with the new ones.

Kerry is working in Outlook 2010. A portion of his computer screen is shown. Which feature of the window is missing?

Answers

The Reading Pane

The reading pane in Outlook can be used to view and work with items that are in the inbox folder. Sometimes, this feature might not visible when working with Outlook. The reading pane can be positioned to the right, bottom, or hidden completely. To unhide it, click the View menu, click the Reading pane and then select the ON option to turn it on

Which of the following devices is used to connect a computer to a network

Answers

Most are wireless routers, meaning converged devices that include a WAP,router, and often an Ethernet switch in the same device.

what is an icon or animation used to represent a participant in an internet chat referred to as

Answers

An avatar is a visual representation, such as an icon or animation, used to represent a participant in an internet chat, giving a personal touch and embodying the user's persona in the digital realm.

An icon or animation used to represent a participant in an internet chat is commonly referred to as an avatar. These visual representations can range from a simple static image to a complex three-dimensional character. Avatars are used to give a personal touch to the digital communication experience, embodying the user's persona in the virtual realm.

In contrast to religious icons, which are sacred images representing holy figures, an avatar is a secular, digital counterpart widely used in online platforms and gaming environments for identity representation and communication. Moreover, in addition to icons, animations such as emojis or GIFs also serve as participant representations in online chats.


The Shading icon will add _____ to the background of a selected paragraph.

borders

bullets

color

texture

Answers

The correct answer is C, color. hope this helps, have an amazing day :)

Answer:

color

Explanation:

Other Questions
the speed of an object in space is shown in the graph what is the slope of the line ? When does hurricane season start There are 190 students taking band, chorus, or both. If there are 180 students taking band and 60 students in both band and chorus, how many students are only in chorus?706010120 Which of the following best describes set of numbers? 6, 9, 12, 15, ... infinite alternating sequence finite geometric sequence infinite arithmetic series infinite arithmetic sequence? When managers organize divisions based solely on the type of customer they focus on, they adopt a _____? Subtract.(6k+2)(3k2)Enter your answer, in simplified form, in the box.Please answer! Do you think it was a brave decision for Gooding to write to Lincoln? What do you think the results of his letter might have been? The graph shows how the cost of gasoline Help please!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!11 A solution has a density of 1.22 g/ml. what volume of the solution has a mass of 48.2 g? What type of forces affects the speed and direction of motion of an object?A: Balanced forcesB: Unbalanced forcesC: Equal and opposite forces in the vertical planeD: Equal and opposite forces in the horizontal plane In "The Bat Poet," the songs of the mockingbird are ________ to the little brown bat.Which words most accurately complete the sentence?an annoyancean inspirationa complimentan insult The current dispute over chechnya can be traced directly to the communist era when _____ imposed soviet power in the region. joseph stalin vladimir putin vladimir lenin karl marx You zoom down.Which adverb could Barry add to sentence 8 to improve the meaning of the sentence?A.TiredlyB.LightlyC.ImmediatelyD.Colorfully Can someone solve this please? A cylinder shaped water tank has a diameter of 8 m and a height of 20 m. What volume of water does the tank contain when it is 60% full? Use 3.14 to approximate pi. Enter your answer as a decimal to the hundredths place in the box.____ m For each pair of numbers, tell: By what percent of the first number is the second number larger? By what percent of the second number is the first number smaller? 100 and 110 Which description compares the vertical asymptote(s) of Function A and Function B correctly?Function A: f(x)= 1/ x+4Function BBoth functions have a vertical asymptote at x=4 .Function A has a vertical asymptote at x = 1.Function B has a vertical asymptote at x = 3.Function A has a vertical asymptote at x = 4.Function B has a vertical asymptote at x = 2.Function A has a vertical asymptote at x=4x=4 .Function B has a vertical asymptote at x = 2. How much interest would an account earn if 3,000 is invested at an interest rate of 4.8% compounded semiannually for 2 years In this ecosystem diagram, pollution and human activities have led to a decrease in the number of eagles. A sudden viral attack on rabbits has led to a decrease in the population of rabbits in the ecosystem. Based on these changes, which two of the following predictions are scientifically sound?