Someone gives me the idea to increase this title for my thesis MULTI PURPOSE COOPERATIVE AUTOMATED LENDING MANAGEMENT SYSTEM.

The SQL Query for the average quoted price, maximum quoted price, and minimum quoted price of all orders is given below:

Display itemcode and descr of those items.

Filter Closed and Rejected Quotations.

SELECT * FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed')

Find maximum price of those quotations.

SELECT MAX(QUOTEDPRICE) MAXI FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed')

Fetch the itemcode of the quoation.

SELECT ITEMCODE FROM QUOTATION WHERE QUOTEDPRICE= (SELECT MAX(QUOTEDPRICE) MAXI FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed'))

Display the details of the fetched item.

SELECT ITEMCODE, DESCR FROM ITEM WHERE ITEMCODE IN (SELECT DISTINCT ITEMCODE FROM QUOTATION WHERE QUOTEDPRICE = (SELECT MAX(QUOTEDPRICE) MAXI FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed')))

However,  the following query doesn't show a logical error:

SELECT ITEMCODE, DESCR FROM ITEM WHERE ITEMCODE IN

(

  SELECT DISTINCT ITEMCODE FROM QUOTATION WHERE QUOTEDPRICE =

 (

   SELECT MAX(QUOTEDPRICE) FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed')

 )

  AND QSTATUS IN ('Rejected','Closed')

)

Read more about SQL here:

https://brainly.com/question/27851066

#SPJ1

Answer:

Power Query reads the table schema from the data source and automatically displays the data by using the correct data type for each column. Unstructured sources Examples include Excel, CSV, and text files. Power Query automatically detects data types by inspecting the values in the table.

The Power Query is used in Excel. It is used to transfer data from other data sources like text, web or other workbooks.

Power Query extracts the table schema from the data source and uses the appropriate data type for each column to automatically display the data. unorganized sources Excel, CSV, and text files are a few examples. By looking at the values in the table, Power Query automatically determines the data types.

Power Query automatically adds two phases to your query when this setting is enabled: Encourage column headings: increases the prominence of the table's first row as the column header. Changed type: Examines the values from each column before changing the data types of the Any data type values.

Therefore, Excel makes advantage of the Power Query. Data from other data sources, including text, the web, and other workbooks, are transferred using it.

To learn more about power query, refer to the link:

https://brainly.com/question/29756007

#SPJ2

Answer:

The 3 methods used in Microsoft word to auto format are; Margin Justification, Tabular Justification, Paragraph Justification

What is formatting in Microsoft Word?

In Microsoft word, there are different ways of formatting a text and they are;

Margin justification; This is a type of formatting where all the selected text are aligned to either the left or right margin as you go to a new page as dictated by the user.

Paragraph justification; This a type of auto formatting where paragraphs are not split as they go to a new page but simply continue from where they left off.

Tabular justification; This is a type that the text is indented or aligned at a 'tab stop' to possibly show a paragraph.

Read more about Formatting in Microsoft Word at: brainly.com/question/25813601

Using DFD, let's examine how the meal ordering system functions (Data Flow Diagram). Food ordering system DFD.

The "mechanical" aspect of managing inventory is purchasing systems. These are the software applications that convert our projections, actual orders, safety stock, and order quantities into purchase requisitions or production orders.

An online ordering system's primary function is to give customers a method to order from a restaurant online. Why is this significant then? The major justification is that it's advantageous to both the client and the company.

To know more about Ordering system visit:

https://brainly.com/question/2249009

#SPJ13

System software manages the computer itself. It runs in the background, maintaining the basic functions of the computer so that users can run higher-level application software to perform specific tasks. Essentially, system software serves as a foundation for application software to run on.

What is a System software?

System software is the most important type of software required to manage the computer system's resources.

Internally, system software runs and interacts with application software and hardware. Furthermore, it serves as a link between a hardware device and the end user.

System software runs in the background and manages all aspects of the computer's operation. Low-Level Software is so named because it runs at the most basic level of a computer and is usually written in a low-level language. When we install the operating system on one device, it is automatically installed on another.

System software contributes to the creation of the user interface and allows the operating system to communicate with the computer hardware in a computer system​.

To learn more about System software, visit: https://brainly.com/question/13738259

#SPJ9

It should be noted that the number of subnets and hosts available from network 192.168.43.0 255.255.255.224 is 8 and 32, respectively. Only 30 of the 32 hosts are generally functional.

A network host is a computer or other device that is connected to a computer network. A host can serve as a server, supplying network users and other hosts with information resources, services, and applications. Each host is given at least one network address.

A computer network is a group of computers that share resources on or provided by network nodes. To communicate with one another, computers use common communication protocols over digital links.

So, in respect to the above response, bear in mind that we may compute the total number of: by putting the information into an online IPv4 subnet calculator.

Learn more about hosts:

https://brainly.com/question/14258036

#SPJ1

Answer:

Having a network of computers (especially a server) allows you to store things on the network instead of your own computer's drive.

Explanation:

A network is a grouping of computers. Some of these computers are usually servers, especially in medium-sized companies. An example is having a server unit (usually with something like an Intel Xeon processor, and with at least 64GB of RAM) with the main feature being mass storage. It's like your own personal cloud! You'll often see a couple of 10TB drives stashed into one. Everything anyone could need to access is on there, as well as everything they need to save. This really helps if you give your employees basic laptops for WFH.

As a cool anecdote, I have 5.5TB of storage and am using 90% of it. You can never have enough! The cost adds up too, with 2TB of typical Hard Drive storage being a $50 expense. With laptops, you usually need an external HDD, which is slightly more expensive. Hence, cloud/network.

You can use the Task Manager to see the applications that are currently running.

To learn more about Task Manager refer,

https://brainly.com/question/28481815

#SPJ1

Cells are the boxes you see in the grid of an Excel worksheet, like this one. Each cell is identified on a worksheet by its reference, the column letter and row number that intersect at the cell's location. This cell is in column D and row 5, so it is cell D5. The column always comes first in a cell reference

Answer: answer 4 and 5

Explanation:

to save something on a device option 4 and 5 is the best fit for this

The way that you can format a paragraph border  is by:

To format, this can also be done by:

Therefore, Press Format. Select the line style you want to use for the border by clicking it in the Style box under Line on the Border tab. Choose the color you want to use from the Color box. To construct the border you want to use, click the border buttons under Border.

Learn more about paragraph from

https://brainly.com/question/1424157
#SPJ1

See full question below

How do you format a paragraph border

It is true that every workplace should have an emergency action plan.

What is an emergency action plan (EAP)?

A written document required by specific OSHA standards is an emergency action plan (EAP). [29 CFR 1910.38(a)] An EAP's purpose is to facilitate and organize employer and employee actions in the event of a workplace emergency.

During an emergency, well-developed emergency plans and proper employee training (so that employees understand their roles and responsibilities within the plan) will result in fewer and less severe employee injuries and less structural damage to the facility.

A poorly prepared plan will almost certainly result in a disorganized evacuation or emergency response, causing confusion, injury, and property damage.

So, the correct answer to the question is True (T).

To know more about the emergency action plan, visit: https://brainly.com/question/3238467

#SPJ1

The two complex sentences which are highlighted are as follows:

A complex sentence may be defined as a type of sentence that significantly consists of one independent clause and at least one dependent clause. These types of sentences best work if you need to provide more information to explain or modify your sentence's main point.

In the above two sentences, there is one independent clause and at least one dependent clause. Both clauses are joined by the usage of numerous punctuation marks like colon, semi-colon, comma, etc.

Therefore, the two complex sentences which are highlighted are well described above.

To learn more about Complex sentences, refer to the link:

https://brainly.com/question/14908789

#SPJ1

The elements or features that can help refine and narrow search results are: B) Boolean operators.

Boolean operators can be defined as the specific words and symbols that are typically designed and developed to enable an end user in expanding or narrowing search parameters, especially when querying a database or search engine in order to generate focused and productive search results.

In Computer technology, there are three (3) main types of Boolean operators and these include the following:

In conclusion, a Boolean operator can help an end user in refining and narrowing his or her search results.

Read more on Boolean operator here: https://brainly.com/question/8897321

#SPJ1

Answer:

it is B.

Explanation:

Answer: 1,  2, 3, 5

Explanation:

in python, you can make custom modules

Functions, modules parentheses, and variables are correct. Thus, option 1, 2, 3, and 5 is correct.

When anything is said to be functional, it's talking about how well it works generally. A chunk of code called a function carries out a certain duty. It can be used repeatedly and summoned. A function can receive information from you and return data as a return. You will use built-in functions within the libraries of many programming languages, nevertheless, you can additionally create your very own functions.

Actions can call any function inside of them. One could develop your own unique modules. The item(s) included in brackets are referred to as parameters when a function is invoked. In the customized function wherever the formula is utilized, a variable defined in main is unreachable.

Learn more about Functions, here:

https://brainly.com/question/21145944

#SPJ2

A Naive approach can be used to find the longest consecutive sub-sequence of integers.

Integers may be defined as whole numbers that can be positive, negative, or zero. It does not include any functional number or the numbers in the form of p/q. Examples of integers may include -5, 1, 5, 8, 97, etc.

The idea for finding the longest consecutive sub-sequence of integers is to sort or filter the array and find the longest subarray with consecutive elements. After sorting the array and eliminating the multiple occurrences of elements, run a loop and keep a count and max.

Therefore, a Naive approach can be used to find the longest consecutive sub-sequence of integers.

To learn more about Integers, refer to the link:

https://brainly.com/question/929808

#SPJ1

Answer:

(a): Yes, it is logically correct as the code does a loop through the all characters of the string and outputs the total amount of them within the string.

(b): It is poorly designed because it is not the most efficient way to get the size of the string. There is a much better way in obtaining it through s.length() and it also accounts for spaces as characters as well.

Explanation:

Hello! Let's help you with your question here!

Now, it is split up into two parts so I will explain them both as such.

For this part of the question. Yes, it would be logically correct. When the size is returned, it will return the number of characters in s. Let's break down the code step by step:

As you can see from the rundown, it initializes a counter and loops through each character of the string and increases the counter as it goes. So for this part, it is logically correct as it does give us the total amount of characters within a string which is considered the string size.

It is poorly designed under two reasons, one is more important than the other as the second one isn't really a requirement, it's just quality of life.

The main reason why this is poorly designed is that it is not optimized. What it does here is going through the entire string and adds 1 to the counter every time there is a character. However, s.length() achieves the same thing. Instead of creating a counter and having it loop through the entire string and adding 1 to the counter for every character and then returning the counter. s.length() is a method that returns the length of a specified string. In this case, it returns the size of the string. To put it simply, the code in the example can be simplified to just:

private static int stringSize(String s) {

      return s.length();

}

This would still give us the same result as the example without having to go through a loop. In programming and algorithms, we learn about time complexity. To put it simply, it is the time it takes for the program to complete. The faster it does without any errors, the more efficient and optimal it becomes. For the code example above, we have time complexity O(n). What this means is that the program needs to run through a loop (multiple checks) before finishing the code, this is the second fastest time. However, with the code I showed you above, it has a time complexity of O(1). For this code, it doesn't need to run any checks, it can just finish the code immediately. Therefore, the code in the example is not efficient.

While the code does work well and does give you an accurate total size of the string every time, it however accounts for spaces as well. If you were to have a space in your string, it would bump the counter up as in Java, as spaces are considered a character because of this you won't get an accurate string size count if you want letters and symbols only. A way to improve it is to create a check within the loop that tells us if the character we are looking at, in the index, is a space or not. If it is a space, we subtract the size counter by 1 and move on. So the modified code would look like this:

public static int stringSize(String s) {

      int size = 0;

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

            size++;

            char c = s.charAt(i);

            if (c == ' ') {

                 size--;

            }

      }

      return size;

}

In the code, I am still adding 1 to the size counter still. However, in the bold. I create a variable c of type char and take the character of the string where the index is currently and use an if statement to determine if it is a space or not. If it is not, then the code repeats until the loop is done and then returns the size of the string. However, if it is a space, it'll subtract 1 from the size counter and will loop through the entire string doing this check and then returns the size of the string when it is done.

Learn more about time complexity at https://brainly.com/question/28018274

Using the knowledge in computational language in SQL it is possible to write the code that display for every restaurant the name of the restaurant  and for every category of menu item its description.

INSERT INTO Dish Values(13, 'Spring Rolls', 'ap');

INSERT INTO Dish Values(15, 'Pad Thai', 'en');

INSERT INTO Dish Values(16, 'Pot Stickers', 'ap');    

INSERT INTO Dish Values(22, 'Masaman Curry', 'en');  

INSERT INTO Dish Values(10, 'Custard', 'ds');  

INSERT INTO Dish Values(12, 'Garlic Bread', 'ap');    

INSERT INTO Dish Values(44, 'Salad', 'ap');    

INSERT INTO Dish Values(07, 'Cheese Pizza', 'en');  

INSERT INTO Dish Values(19, 'Pepperoni Pizza', 'en');    

INSERT INTO Dish Values(77, 'Veggie Supreme Pizza', 'en');

INSERT INTO MenuItem Values(0, 0, 13, 8.00);

INSERT INTO MenuItem Values(1, 0, 16, 9.00);

INSERT INTO MenuItem Values(2, 0, 44, 10.00);

INSERT INTO MenuItem Values(3, 0, 15, 19.00);

INSERT INTO MenuItem Values(4, 0, 22, 19.00);

INSERT INTO MenuItem Values(5, 3, 44, 6.25);

INSERT INTO MenuItem Values(6, 3, 12, 5.50);

INSERT INTO MenuItem Values(7, 3, 07, 12.50);

INSERT INTO MenuItem Values(8, 3, 19, 13.50);

INSERT INTO MenuItem Values(9, 5, 13, 6.00);

INSERT INTO MenuItem Values(10, 5, 15, 15.00);

INSERT INTO MenuItem Values(11, 5, 22, 14.00);

See more about SQL atbrainly.com/question/13068613

#SPJ1

When communicating online, it is important to understand there is no vocal tone or body language, as there is in face-to-face conversation. What are some things you can do when communicating online to maintain appropriate netiquette? Use details to support your answer.

Some starter ideas to get you going:

This signals a lack of respect and professionalism.

This comes across as yelling and is inappropriate for business communication.

Do not make assumptions when information is vague. For example:

Mary: Send me the report by 4 tomorrow.

John: Just to clarify, do you mean 4 PM tomorrow?

This will increase confusion in a conversation.

Answer:

Avoid the use of slang and profanity.

This signals a lack of respect and professionalism.

Avoid using all caps when composing the message.

This comes across as yelling and is inappropriate for business communication.

Ask for clarification and repeat back the message to ensure the understood message was the intended message.

Explanation:

Networks can use protocols and apply them to (formatting) and (processing) to allow information to be passed from one machine to another in a common format.

A common language for computers would be network protocols. Although the software and hardware used by the computers in a network may be very dissimilar, the use of protocols allows them to communicate with one another.

Therefore, Data, network, transport, and application layers are just a few of the many protocols that make up the Transmission Control Protocol/Internet Protocol (TCP/IP) suite and thus, A protocol is a common set of guidelines for formatting and processing data in networking. Computers can talk to one another thanks to protocols.

Learn more about Networks from

https://brainly.com/question/1027666
#SPJ1

Java is a programming language that developers use to build applications for computers, servers, game consoles, scientific supercomputers, mobile phones, and other devices.

According to the TIOBE index, which ranks programming language popularity, Java comes in third place overall behind Python and C. We can thank Java outstanding qualities for the language extensive usage, including:

To Learn more about Java refer to:

https://brainly.com/question/25458754

#SPJ9

Answer:

Explanation:

weird

name = input("Enter your name: ")

email = input("Enter you e-mail: ")

print("Hi",name,"we can contact you via your e-mail address which is",email)

To write a program that asks the user for the name of a file, we will use the readline() method of our file object, and using a for loop, we'll repeat the readline() five times.

The structure of the program and it's programming:

We will use readline() method of our file object( here it has been taken as file_obj).

Using a for loop we'll repeat the readline() five times.

If the file has less than five lines and we try to keep reading after the read position has gotten to the last character in the file, the readline() function will just return the empty string " ".

So nothing will be displayed. We need set end=' ' in our print() function to ensure that we don't get a bunch of extra new lines.

Don't forget to close the file after you're done with it.

# Getting file name from the user filename = input('Enter the filename :')  

# Opening the file in read mode file_obj = open(filename, 'r');  

# Reading and displaying the file's first five lines for i in range(5):     print(file_obj.readline(), end = '')

# Reads a single line at a time and displays it   # Closing the file file_obj.close()

To know more about programming, visit: https://brainly.com/question/16936315

#SPJ1

Using the knowledge in computational language in JAVA it is possible to write the code that write a program whose input is: firstName middleName lastName, and whose output is: lastName, firstName middleInitial.

import java.util.Scanner;

import java.lang.*;

public class LabProgram{

public static void main(String[] args) {

String name;

String lastName="";

String firstName="";

char firstInitial=' ',middleInitial=' ';

int counter = 0;

Scanner input = new Scanner(System.in);

name = input.nextLine(); //read full name with spaces

int i;

for(i = name.length()-1;i>=0;i--){

if(name.charAt(i)==' '){

lastName = name.substring(i+1,name.length()); // find last name

break;

}

}

for(i = 0;i<name.length()-1;i++){

if(name.charAt(i)==' '){

firstName = name.substring(0, i); // find firstName

break;

}

}

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

if(name.charAt(i)==' '){

counter++; //count entered names(first,middle,last or first last only)

}

}

if(counter == 2){

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

if(Character.toUpperCase(name.charAt(i)) == ' '){

middleInitial = Character.toUpperCase(name.charAt(i+1));//find the middle name initial character

break;

}

}

}

firstInitial = Character.toUpperCase(name.charAt(0)); //the first name initial character

if(counter == 2){

System.out.print(lastName+", "+firstName+" "+middleInitial+".");

}else{

System.out.print(lastName+", "+firstName);

}

}

}

See more about JAVA at brainly.com/question/12975450

#SPJ1

Virtual reality (VR), augmented reality (AR), AI, social media, and digital currency are the defining features of Metaverse.

What Is A Defining Feature Of The Metaverse?

The Metaverse has a wide range of distinct characteristics. Rather than leaving the comfort of your own home, you can interact with other people in the same way you would in the real world. It's a fascinating and entertaining experience.

Perhaps the most significant advantage of the Metaverse is that anyone, no matter where they are, can use a physical device such as a smartphone or computer to connect to and interact with Virtual Worlds. It may provide solutions to a wide range of global issues by providing an interactive digital mingling and management experience that may be useful in remote working, medical, internet browsing, and much more.

The Metaverse is also distinguished by the fact that it is a virtual world in which users can interact in real time. It is a 3D representation of the internet in which users can create their own avatars, visit virtual spaces, and engage in a variety of activities. The Metaverse has its own economy, with users earning and spending virtual currency.

Furthermore, Metaverse is constantly evolving and expanding, adding new features and content on a regular basis. The Metaverse is likely to become more immersive and realistic as more people join it, blurring the line between the virtual and real worlds.

To know more about the Metaverse, visit: https://brainly.com/question/28949928

#SPJ1

The program whose inputs are four integers is illustrated:

#include <iostream>

using namespace std;

int MaxNumber(int a,int b,int c,int d){

int max=a;

if (b > max) {

max = b;}

if(c>max){

max=c;

}

if(d>max){

max=d;

}

return max;

}

int MinNumber(int a,int b,int c,int d){

int min=a;

if(b<min){

min=b;

}

if(c<min){

min=c;

}

if(d<min){

min=d;

}

return min;

}

int main(void){

int a,b,c,d;

cin>>a>>b>>c>>d;

cout<<"Maximum is "<<MaxNumber(a,b,c,d)<<endl;

cout<<"Minimum is "<<MinNumber(a,b,c,d)<<endl;

}

Java is a general-purpose, category, object-oriented programming language with low implementation dependencies.

Java is a popular object-oriented programming language and software platform that powers billions of devices such as notebook computers, mobile devices, gaming consoles, medical devices, and many more. Java's rules and syntax are based on the C and C++ programming languages.

Learn more about program on:

https://brainly.com/question/26642771

#SPJ1

Immersion and Interaction are the two most important features of virtual reality.

What is Immersion?

Immersion, also known as presence, refers to the degree of reality in which the viewer exists as the protagonist in the virtual environment. By wearing interactive devices such as helmet-mounted displays and data gloves, viewers can immerse themselves in a virtual environment and become a part of it.

What is Interaction?

Interaction refers to the user's ability to manipulate objects in the simulated environment as well as the natural degree of feedback from the real world. Human-computer interaction in VR technology is similar to natural interaction. There are two kinds of interactions: three-degree-of-freedom (3DoF) interactions and six-degree-of-freedom (6DoF) interactions.

What is Virtual reality (VR)?

Virtual reality (VR) is a simulated experience that uses pose tracking and 3D near-eye displays to immerse the user in a virtual world. A computer-generated simulation of a three-dimensional image or environment that can be interacted with in a seemingly real or physical way by a person wearing special electronic equipment, such as a helmet with a screen inside or gloves with sensors

To know more about Virtual Reality (VR), Kindly visit: https://brainly.com/question/13269501

#SPJ1