Create a function name BALANCE that returns the status of outstanding amount for each customer. Use the following criteria for your function: Outstanding_amt less than 5000 , returns ‘SMALL AMOUNT’ Outstanding_amt between 5000 and 10000 , returns ‘AVERAGE AMOUNT’ Outstanding_amt greater than 10000 , returns ‘LARGE AMOUNT’ Use function BALANCE in your SQL statements that display the cust_code, cust_name, Outstanding_amt and function BALANCE.
Q: Python program using function as ojcets in High order function.This assignment of function into vari...
A: Please find the answer below
Q: Computer science What is the central processing unit in the mobile's power circuit?
A: Introduction: CPU is also known as the brain of the computer because It's the control center of the ...
Q: What IT Governance considerations a corporation should review before deploying an application in the...
A: Introduction: Many companies' downfalls may be traced back to a lack of sound corporate governance. ...
Q: Create a function that reverses an array This challenge is particularly helpful if you're planning t...
A: Introduction: A collection of things stored in contiguous memory spaces is referred to as an array. ...
Q: QUESTION 1 Write a complete program that consists of the main function that will call 4 user-defined...
A: logic:- To repeat users calculation, use while(1) loop and in one of choice put break. Use two fun...
Q: Data Algorithms (language: Java) Describe what each function does and its Big O? import java.util....
A: The total execution in java with depiction in remarks is as per the following:
Q: a) What is the type of the grammar according to Chomsky hierarchy? Why? b) Find the language generat...
A: Chomsky Hierarchy shows the languages class which were taken by different machines. Given grammar: ...
Q: lease Help ASAP!!!
A: Employeeid will be unique for each employee, and that also defines the class. So it can be considere...
Q: Which is quicker, asymmetric or symmetric encryption?
A: Introduction: There are two kinds of encryption. The first is asymmetric encryption, and the second ...
Q: Provide examples of the four network security concerns that IoT systems should be on the lookout for...
A: IoT is a system of interrelated computing devices, mechanical and digital machines, objects, animals...
Q: When the MPU starts up for the first time it goes to the and begins executing. Reset vector Interrup...
A: MPU is memory protection unit that provides memory protection.
Q: Is there a list of the many forms of malware and what they do?
A: Introduction: Malware is a broad phrase that refers to harmful software, including Malware, ransomwa...
Q: What do you understand by the deadlock? What do you understand by deadlock detection and recovery?
A: Deadlock:- A Deadlock is what is happening where a bunch of cycles is in hanging tight for state or ...
Q: can you help me how I install wordclod in cmd
A: Word Cloud is a data visualization technique used for representing text data in which the size of ea...
Q: What effect does the file deletion algorithm have on Symbian, Android, and iPhone?
A: Introduction: Android is a mobile operating system based on a modified version of the Linux kernel a...
Q: Java Write a Java to Implement Prim's and DIJKSTRA's algorithm for Single Source Shortest Path Probl...
A: Dijkstra's approach for least spanning tree is quite similar to Prim's algorithm. We create an SPT (...
Q: Please answer it in Python Write a function integerlist that would return Increasing, Decreasing, C...
A: Your python program is given below as you required with an output.
Q: Compare SISD, SIMD, MISD, and MIMD in detail
A: SISD - it refers to single instruction and single data stream. It used to represents a single comput...
Q: 6. What is the binary equivalence of decimal 287, in WORD size? 10
A: Here in this question we have asked that what is the binary equivalence of decimal number 287 in wor...
Q: Assume that the physical address of the instruction is (D6A92H) and the code 2 Bandwidth segment (CS...
A: Memory addressing schemes:1. An Absolute Address, such as 04A26H, is a 20 bit value that directly re...
Q: Explain why deep access is superior to shallow access from the perspective of a coder; avoid making ...
A: Introduction: For non-block structured languages, dynamic scope allocation rules are utilised.It def...
Q: iii. 111. int sum = 0; for ( int i = 0; i<n; ++i ) { for ( int j= 0; j<n; ++j) { sum += f( j, 10 ); ...
A: Time complexity of whole code will be given by multiplying complexities of for loops and function f(...
Q: Give an example of when adaptors are typically required when systems are built by merging applicatio...
A:
Q: Please answer it in Python Sorting a list is to take the minimum and put it at the beginning, then s...
A: Introduction: Selection sort is a sorting algorithm that picks the smallest element from an unsorted...
Q: Write the proper method declaration/ method call for the following (Javaprogramming) A method named...
A: The parameters will be passed after the function name inside parenthesis and the return type will be...
Q: Write a c program that prints the prime number between 2 and 100.
A: Program Explanation:- Using the header file. Define the main function. Declare integer type variabl...
Q: What is the objective of Access Security Software?
A: Introduction: In order to avoid insecurity, the Principle of Least Privilege urges system designers ...
Q: hello! can you help me with my code? the expected output should be the same, it's on the photo. here...
A: The swap function will swap the values using pointers. It actually takes the parameters as the addre...
Q: Explain the terms of interaction in human-computer interaction (HCI) in your own words.
A: let us see the answer:- Introduction:- Human-computer interaction (HCI) is the study of how people i...
Q: GIven the following Salinity (S) and Freezing Temperature F tables we can expect for a freezing temp...
A: Given :- GIven the following Salinity (S) and Freezing Temperature F tables we can expect for a free...
Q: Map it to a query tree Provide a simplified WHERE clause
A: Normalization¯ manipulate query quantifiers and qualificationQ Analysis¯ detect and reject “incorr...
Q: 1 Description of the Program In this assignment, you will make two classes, Student and Instructor, ...
A: According to the Bartleby rules, only one question can be solved at a time. //Instructor.java ...
Q: What are the limits of this destination IP-based forwarding method of delivering messages? Through t...
A: What are the limits of this destination IP-based forwarding method of delivering messages? Through t...
Q: 372658.2384292.qx3zay7 Jump to level 1 Write code in PutDollars that puts moneyAmount to output. Fun...
A: Algorithm: Start Read userMoney from user Implement a method named PutDollars() that takes userMone...
Q: Distinguish the reasons why distributed software systems are more complex than centralized software ...
A: Introduction: Distributed systems are more complicated than single-processor systems. Complexity eme...
Q: What exactly is the Named constant?
A: Named constant: Named constant is a constant value that cannot be changed during the execution of a...
Q: What are the benefits of putting several subsystems and logical divisions on one computer?
A: Introduction: Here we are required to explain what are the benefits of putting several subsystems an...
Q: Suppose I have a double matrix stored in an array of arrays. Write two nested enhanced for loops to ...
A: A 2D array is a collection of arrays. In C programming, a two-dimensional (2D) array is also known a...
Q: When it comes to some systems, how may BIOS/UEFI passwords be bypassed?
A: Introduction: Passwords for the BIOS or UEFI UEFI stands for Unified Extensible Firmware Interface, ...
Q: What was the breakdown of the evaluation's usability and user experience goals?
A: Introduction: The following are the usability and user experience goals that were used in the evalua...
Q: Hello! I am having trouble on how to write out the Java code based on the instructions (in bold //**...
A: public static int calculateThreeOfKind() { int score; score = 0; boolean hasThr...
Q: MATLAB The meaning of "a = b"
A: Introduction:- Meaning "a = b" is assigning the value present in variable b to variable a
Q: SSN PNUMBER PNAME HOURS 100 1000 Hadoop 50 220 1200 CRM 200 280 1000 Hadoop 40 300 1500 Java 100 120...
A: For 1 NF - select PNAME from R1 where PNUMBER = 1500;
Q: Write a secure Bounded Stack class in Java, where the item type is string. Fail fast by throwing exc...
A: The answer is as follows.
Q: 149. Write a C# Sharp program to create a new list from a given list of integers removing those valu...
A: The code is given in the below step
Q: The role of a database administrator in a NoSQL database is explained below
A: Introduction : DBA: DBA is an abbreviation for database administrator. DBA may refer to either a per...
Q: In the process of deleting rows, columns, and tables, what is an important point to bear in mind is
A: Introduction : Database management systems are created in order to keep records of numerous linked e...
Q: In the process of deleting rows, columns, and tables, what is an important point to bear in mind is
A: Introduction: A database management system is built to efficiently handle the records of numerous as...
Q: Explain the three main types of cloud computing platforms
A: The answer as given below:
Q: the advantages of these two Network+ certification programs should be discussed Make sure to include...
A: Introduction: When applying for a job in IT, you'll almost certainly be asked to offer a lot of info...
Create a function name BALANCE that returns the status of outstanding amount for each customer. Use the following criteria for your function: Outstanding_amt less than 5000 , returns ‘SMALL AMOUNT’ Outstanding_amt between 5000 and 10000 , returns ‘AVERAGE AMOUNT’ Outstanding_amt greater than 10000 , returns ‘LARGE AMOUNT’ Use function BALANCE in your SQL statements that display the cust_code, cust_name, Outstanding_amt and function BALANCE.
Step by step
Solved in 3 steps
- INFO 2303 Database Programming Assignment # : PL/SQL Procedure & Function Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Write a script to create a PL/SQL procedure called findSal that displays the doctor’s salary and bonus after passing in the doc_id into the procedure. For example, if you pass in doc_id 504, you will get the following output. execute findSal(504) The salary for Dr.Cotner (504) is: 11500 The bonus is: 7500 PL/SQL procedure successfully completed.SBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID DBS311 Your Name use the following statement to Write a PL/SQL Function that accepts 4 parameters, 2 strings representing students names, and 2 integers representing the marks they received in DBS311. The function will determine which student had the higher mark and return the name of the student. If the marks were the same, then return the word "same" and return "error" if an error occurs or the calculation can not be determined.Database design Objectives: To understand and be able to write simple SQL queries Instruction: Refer to HR schema to answer the questions Include screenshot of your code and output of each question 1. Write SQL query that displays the last name and salary of employees earning more than $12,000. 2. Write SQL query that displays the last name and department number for employee number 176. 3. Write SQL query to display the last name and salary for all employees whose salary is not in the range $5,000 through $12,000. 4. Write SQL query to display the last name, job ID, and hire date for employees with the last names of Matos and Taylor. Order the query in ascending order by hire date. 5. Display the last name and department ID of all employees in departments 20 or 50 in ascending alphabetical order by name. 6. Write a query that displays the last names of all employees who have both an “a” and an “e” in their last name. 7. Write a query to display the employee…
- In PL/SQL, Create a recursive store function called add_numbers to calculate the total of all consecutive positive integers from 1 to the number entered by the user. The number that will stop the function must be entered by the user when running the function and be passed to the function. If the user enters a zero or a negative number, display the total as 0. You can use the function in a SELECT statement to execute it. See sample outputs below. ADD_NUMBERS(5)---------------------------- 15 ADD_NUMBERS(3)----------------------------- 6Please develop PL/SQL program that asks for a radius of a circle. After user enters a radius number, the program then calculates 1. Circumference and 2. Area of a circle, then prints both as follows: You entered radius as 5 The circumference is 31.4159 The area is 78.5398 If the area is less than 50 then print 'Please enter bigger radius'. Otherwise print 'Your radius is Ok! Declare variables for circumference and area in such a way that the result would be rounded to 4 decimal places after the dotPATHS is a table that contains information about paths on a number line. The structure of PATHS is as follows, where x1 and x2 represent that there is a path from Coordinate x1 to Coordinate x2 (You can't move from Coordinate x2 to Coordinate x1 ). NAME ΤΥΡE NULLABLE X1 INT FALSE X2 INT FALSE Problem Please write an SQL statement that returns the beginning and end point of each path in PATHS . Sort them by the value of the beginning point in ascending order. Constraints • In the case where a direct path from Coordinate a to Coordinate b is available, no path from Coordinate b to Coordinate a will be given. |x1-x2| = 1 • No path will overlap with one another. Example Suppose that PATHS is as follows: x1 x2 1 2 2 3 4 7 7 6 This table can be visualized as follows: START END END START 7 8. 9 Therefore, your SQL statement must return the following: start end 1 4 8 6
- USE NORTHWIND DATABASE Write a SELECT statement using the CASE function. The statement returns two columns basedon how many orders the customer has in the database. The first column is the customer name andthe second column, Membership Type, is based on which case applies to the customer:If the customer has more than 25 orders they are a Diamond Customer.If the customer has more than 15 orders they are a Gold Customer.If the customer has more than 10 orders they are a Silver Customer.If the customer has more than 5 orders they are an Iron Customer.Otherwise the customer is a Valued Customer.Write a PL/SQL code to print 'PASS' if the student has scored above 40. Choose an answer A declare m number:= 80;begin if m>40 dbms.output.put_line('PASS'); end if;end;/ B declare m number:= 80;beginif m>40 dbms_output.put_line('PASS');end;/ C declare m number:= 80;begin if m>40 dbms_output.put_line('PASS'); end if;end;/ D declare m:= 80;beginif m>40 dbms_output.put_line('PASS');end if;end;/**In SQL** Write a SELECT statement that returns these columns: InstructorDept The DepartmentName column from the Departments table for a related instructor LastName The LastName column from the Instructors table FirstName The FirstName column from the Instructors table CourseDescription The CourseDescription column from the Courses table CourseDept The DepartmentName column from the Departments table for a related instructor Return one row for each course that’s in a different department than the department of the instructor assigned to teach that course. (Hint: You will need to join the Departments table to both the Instructors table and the Courses table, which will require you to use table aliases to distinguish the two tables.)
- SQL code for: Create a stored procedure “setRelocationFee” to set the relocation fee for a given employee. If the employee’s office is in San Francisco, the relocation fee is $10000; if the employee’s office is in Boston, the relocation fee is $8000; if the employee’s office is in London, the relocation fee is $20000; if the employee works in other offices, the relocation fee is $15000. Below is a sample statement to test your stored procedure. set @employeeID = 1501; call setRelocationFee(@employeeID, @relocationfee); select @employeeID, @relocationfee; Having this database CREATE TABLE `offices` ( `officeCode` varchar(10) NOT NULL, `city` varchar(50) NOT NULL, `phone` varchar(50) NOT NULL, `addressLine1` varchar(50) NOT NULL, `addressLine2` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `country` varchar(50) NOT NULL, `postalCode` varchar(15) NOT NULL, `territory` varchar(10) NOT NULL, PRIMARY KEY (`officeCode`) ) ENGINE=InnoDB DEFAULT…Student Name: Student Number: Write a PL/SQL Program to do the following Your Program should request the user to enter the temperature. Then based on the users input your program should display the following messages a. Print "Hot" if the temperature is above 80 degrees, b. Print "Nice Weather" if it's between 50 and 80 degrees, c. Print "cold" if it is less than 50 degrees Test 40, 55 and 85 as inputs; Guideline: Create a unique code Add Comments to the program ● Take clear screen shots of the program source code and the outputs Explain the code block briefly You must submit the code as one .sql file and paste all the screenshots in the Word document and upload it to Moodle before deadline. 99+ DELLUsing truth table and functions please complete task 3. Schematic truth table should match). Must have 3 ins and 7 outs. Will upvote!(: