I want solution flowchart Start Step 1: Declare Student_Name[10], Student_Score[10][5],i=0,j=0,sum=0 Step 2: for i=0 to 9 Step 3: Get Student_Name[i] Step 4: for j=0 to 4 Step 5: Get Student_Score[i][j] Step 6: sum=sum+Student_Score[i][j] Step 7: End for Step 8: Print "Name= ",Student_Name[i] "Average=", (sum/5) Step 9: End for End
Q: Consider the following set of tasks and their associated profits and deadlines, in a dual-core…
A: Introduction:Given a dual core processor system's task and their profit with deadlines are given we…
Q: I want solution flowchart
A: Given Pseudocode/code: Start Step 1: Declare Student_Name[10], Student_Score[10][5],i=0,j=0,sum=0…
Q: 4. K-Distinct Numbers You are given an integer N. You have to present N as a sum of K distinct odd…
A:
Q: If I have a table in sql database phpmyadmin the table's column : ID Name Salary City 1 John 200…
A: First we create database connection through php and then populate the list box with data from…
Q: Some rows of the STUGRADE table of a school are shown below: STU_CODE CLS_CODE GRADE YEAR 291…
A: In this scenario, we have a table named STUGRADE that contains student grades with columns like…
Q: This dataset “Birthweight_reduced_kg_R" contains information on new born babies and their parents.…
A:
Q: Explain any four different ways for reading input from the user in the command line environment?
A: Below is the answer with explanation for java language as language not specified:
Q: Assume that you have a product code that has the following format: XXXXNNN Where X is a character…
A: Below is the detailed PL/SQL program to separate the code into its two parts as shown in the above…
Q: Evaluate: Ig (1/16) =
A: The expression "lg(1/16)" represents the logarithm to the base 2 of the number 1/16 in computer…
Q: Whoever must play, cannot play def subtract_square(queries): Two players play a game of "Subtract a…
A:
Q: Consider the following Employee table: ID Name Hire Date Address Salary ... Isa Hamad Zahra Salman…
A: Lets see the solution.
Q: Assume that you have a product code that has the following format: XXXXNNN Where X is a character…
A: Answer :
Q: IN SCALA COULD YOU COMPLETE THE FUNCTIONS: get_january_data, get_first_price, get_prices,…
A: Coded using Scala.
Q: start end 1 8 6
A: -- sql-- select start only if x1 = x2 - 1 is satisfied-- select end as max if x2 = x1 + 1 is…
Q: PYTHON CODE Using Artists.csv (link below), write a query that returns all lines that are female…
A: It is defined as a powerful general-purpose programming language. It is used in web development,…
Q: Please help me with this, the deadline is near T_T
A: Q: Code the given problem in C
Q: The following is a table of applicants to be considered for admission into 07BSAM: POINTS MATH…
A: - We need to provide pseudocode for the modes of study for students using FOR-LOOP. - I have…
Q: The use of global variables is strongly discouraged for applications managed by a team of…
A: Scope of variable Scope of a variable means, up to which part of a program, a variable can be access…
Q: Write a stored procedure called sp_apply_discount() that will apply percent discount to books in a…
A: Database: An organized group of data that can be electronically stored and retrieved is…
Q: Database: CUSTOMER (CustomerID, LastName, FIrstName, Phone, EmailAddress) PURCHASE (InvoiceNumber,…
A: Below is the required query:
Q: SQL A table Products have: a name (TEXT) a description (TEXT) a unit cost stored in cents…
A: HI THERE,I AM ADDING SCHEMA AND QUERIES BELOWPLEASE GO THROUGH IT THANK YOU
Q: Based on the table below, what values would appear in range C4:E6 when the contents of C3:E3 are…
A:
Q: Task 1: Generate the truth table for a 7-segment display. XYZ A B C D E F G 00011 0010 010 1 1 0 1 1…
A: Let's create a K maps for 3 input and 7 segment output.
Q: NFO 2303 Database Programing Assignment # : PL/SQL Procedure & Function Practice Note: PL/SQL…
A: What is SQL? SQL stands for Structured Query Language SQL lets you access and manipulate databases…
Q: Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is…
A: We have a dataset of orders containing order quantities and a corresponding price table. Our task is…
Q: How good is Optical Fibre compared to DSL in networks?
A: Introduction :Here we have asked that why optical fibres are better than DSL.
Q: In java create an application to manage your data bas information the database is already created in…
A: To create a Java application to manage your MySQL database, you can use JDBC (Java Database…
Q: ID At_fault_claims 1001 0 1001 1 1002 0 1002 1 1002 1 1003 0 1004 1 1005 1 1005 0 Aggregate the the…
A: solution:
Q: use the following statement to Write a PL/SQL Function that accepts 4 parameters, 2 strings…
A: DECLAREStudent1 varchar2(32767);Student2 varchar2(32767);S1Marks number;S2Marks number;c…
Q: calculate_new_balance Given a starting balance (a number), and a list of transaction tuples,…
A: Given: Given a starting balance (a number), and a list of transaction tuples, calculate the final…
Q: Code should be in Python Prompt the user for a title for data. Output the title. Ex: Enter a…
A: Solution :: As we know all python programming is a interpreted high-level general-purpose…
Q: 1 2 3 4 5 6 7 8 A B Paper Type Name Letter Stock 65lb Cover Stock Premium White Copy Paper 2 Hole…
A: vlookup is an excel function which is used to refer values within the same sheet or other sheet…
Q: What is the purpose of AUTO_INCREMENT?
A: The solution is given below for the above given question:
I want solution flowchart
Start
Step 1: Declare Student_Name[10], Student_Score[10][5],i=0,j=0,sum=0
Step 2: for i=0 to 9
Step 3: Get Student_Name[i]
Step 4: for j=0 to 4
Step 5: Get Student_Score[i][j]
Step 6: sum=sum+Student_Score[i][j]
Step 7: End for
Step 8: Print "Name= ",Student_Name[i] "Average=", (sum/5)
Step 9: End for
End
Step by step
Solved in 2 steps with 1 images
- I want solution flowchart Start Step 1: Declare Student_Name[10], Student_Score[10][5],i=0,j=0,sum=0 Step 2: for i=0 to 9 Step 3: Get Student_Name[i] Step 4: for j=0 to 4 Step 5: Get Student_Score[i][j] Step 6: sum=sum+Student_Score[i][j] Step 7: End for Step 8: if (sum/5) > 90 and (sum/5)<=100 then Step 9: Print "Student Name= ", Student_Name[i] , "Grade= A+" Step 10: End if Step 11: else if (sum/5) > 80 and (sum/5)<=90 then Step 12: Print "Student Name= ", Student_Name[i] , "Grade= A" Step 13: End elseif Step 14: else if (sum/5) > 70 and (sum/5)<=80 then Step 15: Print "Student Name= ", Student_Name[i] , "Grade= B" Step 16: End elseif Step 17: else if (sum/5) > 60 and (sum/5)<=70 then Step 18: Print "Student Name= ", Student_Name[i] , "Grade= C" Step 19: End elseif Step 20: else Step 21: Print "Student Name= ", Student_Name[i] , "Grade= F" Step 22: End else Step 23: End for EndSolve this, please.You are given a list of courses that are currently available in Oxford College that looks like the following: courses = ['CSE110','CSE111','MAT620','CSE520','EEE361','CSE650','MAT510']. All courses till 400 level (499) are for the undergraduate students whereas any courses above 500 are for the graduate or masters students. Write a python program that creates a dictionary from the above list where the keys will be each department name (CSE,EEE,MAT for the above example) and their values will be a dictionary of two keys - Undergraduate Courses and Graduate Courses. Each key will have courses that fall in Undergraduate and Graduate level respectively. Sample Input - No need to take input ['CSE110','CSE111','MAT620','CSE520','EEE361','CSE650','MAT510'] Sample Output: (You just have to print the resultant dictionary. No need to follow the pattern below) { 'CSE':{ 'Undergraduate':['CSE110','CSE111'], 'Graduate':['CSE520','CSE650'] },…
- a. Software Engineering Research Group (SERG) IIUM is organizing a programming competition. Students are allowed to use either Python or C++ programming language for the competition. Student who wishes to opt for Python goes into lab 1 while for C++ in lab 2. The seating arrangement is based on question ID. The number of students that registered for the competition are 10 students only. Each lab has capacity of 13 students. You are required to create a hash table to indicate where each student with the following question IDs (keys) be hashed/mapped to in the slot of the lab (hash table). IDs = {41, 28, 54, 18, 36, 10, 90, 12, 38, 25} using the hash function, h1(ID) = (ID) % lab capacity Show all your calculations and indication to where the values are being hashed.Code to create javaWrite in C language Description You have 2 tables, courses and scores. courses consists 3 columns, sid, student_id, and course_id. scores consists 2 columns,sid and score. Please find that how many students failed on at least one course. Input First line consists 2 integers m and n, shows number of rows in courses and scores. Followed m lines are records of courses. student_id are 8-digits numbers begin with non-zero digit. sid and scores are positive integers smaller than 1000. Followed n lines are records of scores. sid are positive integers smaller than 1000. score are integers in range [0, 100]. Output Student will be flunked when his/her average score in the course less than 60. Output is 2 integers shows number of student and student failed on at lease one course. Sample Input 1 2 4 1 10800001 5 2 10800002 5 1 90 1 29 2 65 2 60 Sample Output 1 2 1
- Write in C language Description You have 2 tables, courses and scores. courses consists 3 columns, sid, student_id, and course_id. scores consists 2 columns,sid and score. Please find that how many students failed on at least one course. Input First line consists 2 integers m and n, shows number of rows in courses and scores. Followed m lines are records of courses. student_id are 8-digits numbers begin with non-zero digit. sid and scores are positive integers smaller than 1000. Followed n lines are records of scores. sid are positive integers smaller than 1000. score are integers in range [0, 100]. Output Student will be flunked when his/her average score in the course less than 60. Output is 2 integers shows number of student and student failed on at lease one course. Sample Input 1 2 4 1 10800001 5 2 10800002 5 1 90 1 29 2 65 2 60 Sample Output 1 2 1 Expert Answer (Sample Input and Output need to be the same as the input and output nothing else) Step 1 There are 2…You need to use Java to connect with the mysql and create a simple mysql system. Databases "POS" have 4 tables 1. Staff_Info Staff_ID Staff_Name Staff_Pw Staff_Title 001 AA 1111 Manager 002 BB 2222 General Once the pos system opened, you need to ask the staff to enter the password. The manager can see the payment record if needed, which the general staff cannot. Food_Info Food_ID Food_Cat Food_Name Price 001 burger Classic burger 32 002 burger Chicken burger 38 003 side Fires 10 004 side Salad 15 005 beverage Coke 5 006 beverage Lemon Tea 8 There are only three categories of food, and 6 in total. Order_Info Order_ID Payment_ID Order_Item Order_Quantity Order_ID and Payment_ID should be automatically generated from 0001. Payment_Info Payment_ID Payment_Amount Payment_Date Payment_Time Payment_Method There are two types of…123 4 5 6 7 8 A B Paper Type Name Letter Stock 65lb Cover Stock Premium White Copy Paper 2 Hole punch Letter Ultra-White Cardstock C Quantity 100 17 25 66 87 DE Discount 25% 5% 10% 15% 20% F Order Discounts G Minimum Quantity Discount 0 25 50 75 100 5% 10% 15% 20% 25% In the above spreadsheet, create a formula in cell D4 that uses the VLOOKUP function with the table array $F$4:$G$8. The formula will determine the applicable discount for each paper type order. You should be able to autofill this formula down through cells D4:D8.
- IN SCALA COULD YOU COMPLETE THE FUNCTIONS: get_january_data, get_first_price, get_prices, get_delta, get_deltas, yearly_yield, compound_yield AND investment val blchip_portfolio = List("GOOG", "AAPL", "MSFT", "IBM", "FB", "AMZN", "BIDU")val rstate_portfolio = List("PLD", "PSA", "AMT", "AIV", "AVB", "BXP", "CCI", "DLR", "EQIX", "EQR", "ESS", "EXR", "FRT", "HCP") // (1) The function below takes a stock symbol and a year as arguments.// It should read the corresponding CSV-file and then extract the January // data from the given year. The data should be collected in a list of// strings (one entry for each line in the CSV-file). import io.Sourceimport scala.util._ def get_january_data(symbol: String, year: Int) : List[String] = ??? // (2) From the output of the get_january_data function, the next function // should extract the first line (if it exists) and the corresponding// first trading price in that year with type Option[Double]. If no…A data set has 4 columns--index, CUSTOMER_EMAIL, Net Revenue, and Year. For each year we need the following information: New Customer Revenue e.g., new customers not present in previous year only Lost Customers New Customers Total Customers Previous Year Total Customers Current Year Please implement it using python.Some rows of the STUGRADE table of a school are shown below: STU_CODE CLS_CODE GRADE YEAR 291 111 3.1 2010 938 101B 2.3 2011 931 M101 3.3 2040 291 M101 3.4 2018 190 111 2.0 2021 931 321 3.9 2003 Suppose that STU_CODE is the student code (foreign key) and CLS_CODE is the class code (foreign key). Which of the following computes the average for each year of the student with code 931? a. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931 GROUP BY YEAR b. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931. c. SELECT AVG(GRADE) FROM STUGRADE GROUP BY STU_CODE = 931 d. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931 GROUP BY AVG(GRADE)