Durian & Co has five salespersons who sell three different types of durians. Once a day, each salesperson records for each type of the product that they have sold. Develop an application to record the information consists of the salesperson's name, the type of durian and the total number of durians has been sold that day. Day 1 Musang Udang D24 King 7 Day 2 Musang Udang Merah D24 Merah King Johari 10 8. 4 10 Ah Chong 5 10 7 8. 4 Muthu 7 3 12 6 Siti 12 8. 6. 4 8 10 Danial 20 4 7 10 The program will initialize the information for last two days' sales (see Table 1) into 2-dimensional arrays. The columns of Day 1 and Day 2 represent the type of durian, and the rows represent the salesperson. By using for loop and two-dimensional array, the program then summarize: 1) The total number of durians sold by each salesperson and by product. 2) Cross total each row to get the total sales of each durian for last 2 days. 3) Cross total each column to get the total sales by salesperson for last 2 days. 4) List salespersons that sold lowest number of durians below the average.

Durian & Co has five salespersons who sell three different types of durians. Once a day, each salesperson records for each type of the product that they have sold. Develop an application to record the information consists of the salesperson's name, the type of durian and the total number of durians has been sold that day. Day 1 Musang Udang D24 King 7 Day 2 Musang Udang Merah D24 Merah King Johari 10 8. 4 10 Ah Chong 5 10 7 8. 4 Muthu 7 3 12 6 Siti 12 8. 6. 4 8 10 Danial 20 4 7 10 The program will initialize the information for last two days' sales (see Table 1) into 2-dimensional arrays. The columns of Day 1 and Day 2 represent the type of durian, and the rows represent the salesperson. By using for loop and two-dimensional array, the program then summarize: 1) The total number of durians sold by each salesperson and by product. 2) Cross total each row to get the total sales of each durian for last 2 days. 3) Cross total each column to get the total sales by salesperson for last 2 days. 4) List salespersons that sold lowest number of durians below the average.

Name: Write a C program Durian & Co has five salespersons who sell three dif
Uploaded: 2024-03-20T06:51:23.000Z
Channel: Bartleby
Description: Write a C program Durian & Co has five salespersons who sell three different types of durians. Once a day, eachsalesperson records for each type of the product that they have sold. Develop an application to recordthe information consists of the sales

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter11: Sql Server Databases

Section: Chapter Questions

Problem 1E

See similar textbooks

Similar questions

Write a SQL statement that will add the below row to the Task table.TaskID Description Duration StartDate TeamMemberID4 Implementemailnotifications2
Computer Science A study conducted by Netflix’s consumer relations department has revealed that customers are more likely to review horror and thriller movies during certain months of the year. To discourage seasonal variations in these movie ratings, Netflix has called for your help to analyze horror and thriller movie rating counts over the past 15 years. Your query should display each month of the year (name of the month not the number) and the total number of ratings given during that month. A third column titled “Promotion Recommendation” determines whether a promotion should be applied to increase the number of ratings given during that month. If a month has less than 2200 ratings the final column should display ‘10% discount promotion’, if between 2201 and 4500 then display ‘5% discount promotion’, and if more than 4500 ratings then output ‘No Promotion’. Order your results by months. Do not hardcode the current date. ORALCE CODE PLEASE.
Department DepartmentID DName ContactNo 1 UIIT 0300-1234567 2 UIMS 0300-4567891 Student RollNo Sname Fname DepartmentID 111 Ali Ahmed 1 112 Sana Waqar 2 113 Afzal Ikram 2 There are only two departments and are already initialized globally, but students can be upto 100 and just defined globally. To maintain how many student’s record have been entered you can use global variable with name as count. Write a C++ program having: Structures, structure definitions and required initializations for the above scenario. Function which takes input data (RollNo, Sname, Fname and DepartmentID) of student from user within the function, then verify that the DepartmentID exists in Department or not? If exists then copy DName and ContactNo in the student record along with above input, otherwise just display a message that department does not exists. For example the following record will not be allowed to store in the…
Create a view named CONDO_FEES. It consists of two columns: the first is the square footage, and the second is the average fee for all condos in the CONDO_UNIT table thathave that square footage. Use AVERAGE_FEE as the column name for the average fee.Group and order the rows by square footage. a. Write and execute the CREATE VIEW command to create the CONDO_FEES view. b. Write and execute the command to retrieve the square footage and average fee foreach square footage for which the average fee is greater than 500. c. Write and execute the query that the DBMS actually executes. d. Does updating the database through this view create any problems? If so, what arethey? If not, why not?
Which of the following statements retrieves data from the Sales table and stores it in the CompanyDataSet? Me.CompanyDataSet.Fill(Me.Sales) Me.SalesBindingSource.Fill(Me.CompanyDataSet) Me.SalesBindingNavigator.Fill(Me.CompanyDataSet.Sales) Me.SalesTableAdapter.Fill(Me.CompanyDataSet.Sales)
List all information for each order item. Include an item total, which can be calculated by multiplying the Quantity and Paideach columns. Use a column alias for the calculated value to show the heading Item Total in the output.
What does the funnel symbol that appears next to a field’s name in the Query Builder dialog box indicate? The field is used in a SELECT statement’s ORDER BY clause. The field is used in a SELECT statement’s WHERE clause. The field is the primary key. The field is the foreign key.
Which type of constraint should you use to ensure that every book has a profit margin between 15% and 25%?
Use excel XVOOKUP FIND THE INFO ABOUT SALE MADE BY LAURA
Table name: Products Column Role Data Type Length Constraint Name P ID Stores the ID of a product Number 8. Primary key P Name Stores the name of a product Varchar2 25 P_entryDate Stores the entry date of a product Stores the expiry date of a product Date Cannot be null P_Expiry P Expiry date should be greater than P entryDate Date P Price Stores the price of a product Number 3,2 Cannot be null a) Write in SQL a command that creates the table Products according to the above description (2 marks). b) Write in SQL a statement that adds to the table Products a new column named supplierID of type Number(5). This column should be defined as a foreign key that relates the table Products to the table Supplier (1.5 marks). c) Write in SQL a query that lists all the details of products arranged in descending order according to the entry date (1.5 marks).
Customers (cNo, cName, cSurname, cCity, cPhone, CDOB, saleRepld) saleRepld: references Salespersons(sNo) Salespersons (sNo, sName, sSurname, sCity, sDepartment, sSalary, sPhone, sHiredate) Which of the following queries displays salespersons working in departments 20, 30 or 50 in alphabetical order by surname? Select one: a.SELECT * from Salespersons WHERE SDepartment in (20,30,50) ORDER BY sSurname asc; b.SELECT * from Salespersons WHERE sDepartment = 20,30,50 ORDER BY sSurname asc; c.SELECT * from Salespersons WHERE sDepartment in (20,30,50) ORDER BY sSurname desc; d.SELECT * from Salespersons WHERE SDepartment between 20 and 50 GROUP BY sSurname asc;
What are the types of queries that you can use in Microsoft Access? Please describe the purpose of the queries types.