Write a function named void find FreshFoodDetails (FreshFood food[], int noFood) that prompt the user to input the fresh food details that he/she wants to view the price. Display the fresh food, production place and the total price of the selected fresh food according to kilogram as shown in Figure 4.3. Please enter the type of fresh food you wish to purchase: RED ONION Please enter the production place of RED ONION: INDIA Please enter the weight in kg that you want to view the price. of the fresh food :3.5 Fresh Food: RED ONION Production Place: INDIA Total price of 3.5kg is RM 14.00 Figure 4.3. foodDetails.txt

Write a function named void find FreshFoodDetails (FreshFood food[], int noFood) that prompt the user to input the fresh food details that he/she wants to view the price. Display the fresh food, production place and the total price of the selected fresh food according to kilogram as shown in Figure 4.3. Please enter the type of fresh food you wish to purchase: RED ONION Please enter the production place of RED ONION: INDIA Please enter the weight in kg that you want to view the price. of the fresh food :3.5 Fresh Food: RED ONION Production Place: INDIA Total price of 3.5kg is RM 14.00 Figure 4.3. foodDetails.txt

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

the code CREATE FUNCTION Calculate_Monthly_Payment( @mortage_amount BIGINT , @apr DECIMAL(18, 6) , @years INT)RETURNS DECIMAL(18, 6)ASBEGIN /* A = P (i + i (1+i) −1 n ) where: A = Monthly Payment Amount P = Principle (Initial) Mortgage Amount i = APR / 12 = Monthly Interest Rate n = years * 12 = Total Number of Payments */ -- Calculate monthly interest rate DECLARE @i DECIMAL(18, 6) SET @i = @apr / 12 DECLARE @n INTEGER SET @n = @years * 12 RETURN (@mortage_amount *@i * POWER(1+@i,@n)) / (POWER(1+@i, @n) - 1) END isn't working it shows that ERROR: syntax error at or near "@" LINE 3: @mortage_amount BIGINT ^ SQL state: 42601 Character: 48
A function named validGPA() to validate the GPA. A valid GPA value must be between 0 and 4 inclusive. The function must return the value of GPA and must take value of GPA as parameter.
Create a function named fnTuition that calculates the tuition for a student. This function accepts one parameter, the student ID, and it calls the fnStudentUnits function that you created in task 2. The tuition value for the student calculated according to the following pseudocode: if (student does not exist) or (student units = 0) tuition = 0 else if (student units >= 9) tuition = (full time cost) + (student units) * (per unit cost) else tuition = (part time cost) + (student units) * (per unit cost) Retrieve values of FullTimeCost, PartTimeCost, and PerUnitCost from table Tuition. If there is no student with the ID passed to the function, the function should return -1. Code two tests: 1) a student who has < 9 student units, and 2) for a student who has >= 9 student units. For each test, display StudentID and the result returned by the function. Also, run supportive SELECT query or queries that prove the results to be correct.
3. Which among the following shows a valid use of the Direction enumeration as a parameter to the moveCharacter function? Select al that apply. enum Direction { case north, south, west, east}func moveCharacter(x: Int, y: Int, facing: Direction) {// code here} moveCharacter(x: 0, y: 0, facing: .southwest) moveCharacter(x: 0, y: 0, facing: Direction.north) moveCharacter(x: 0, y: 0, facing: .south) moveCharacter(x: 0, y: 0, facing: Direction.northeast)
assign(self, assignment:Assignment) -> AssignmentResult: """ This function is to simulate the process of the student receiving an assignment, then working on the assignment, then submitting the assignment and finally receiving grade for the assignment. This function will receive an assignment then a grade should be calculated using the following formula: grade = 1 - (Student's current energy X Assignment difficulty level). The min grade a student may receive is 0% (0) After the grade is calculated the student's energy should be decreased by percentage difficulty. Example if the student has 80% (.8) energy and the assignment is a difficultly level .2 there final energy should be 64% (.64) = .8 - (.8 * .2). The min energy a student may have is 0% (0) Finally the grade calculated should be stored internally with in this class so it can be retrieved later. Then an Assignment Result object should be created with the student's ID, the assignment…
Write a set of functions that calculate the cost of movie tickets for a family. These functions should use a pass-by-reference variable that accesses the double running_total variable in main(). Using a loop, keep displaying the ticket prices for each age group: Something like: Model Hall Movie Ticket Box Office Under Age 3 (free) Ages 3-11 ($10.25) Ages 12-54 ($15.50) Age 55 or older ($12) If 4 tickets are purchased (not counting under age 3) then 20% discount Within the loop: Keep asking the user to input the moviegoer age and to enter a zero for the age when they are finished inputting all the family members. Also, within the loop: Keep a running_total that is output to the screenafter each age has been entered. This running_total should be accessed through the functions using apass-by-reference variable. Finally, after the looping is done: Calculate the total cost, including a 7.5% sales tax, and output it to the screen.
Task Two Design and develop a function that asks the user to enter a number and save it as the variable "flag". Design and develop another function that uses "flag" and output count numbers from 1 to that number. In the main program demonstrate the use of the two functions.
In this program, your task is to calculate average of grades and then display the final grade. Your tasks are as follows: Create a function called get_average() that takes a list containing grades of five subjects and calculates the average and returns it. Create a function called get_grade() that takes average of the five subjects from the get_average() function and displays the grade as per the table below:
Write a function called substring that uses the leftmatch and rightmatch functions to remove a pattern from the left and right side of a value. It should take three arguments as shown: $ substring /usr/ /usr/spool/uucppublic /uucppublic spool $ substring s. s.main.c .c main $ substring s. s.main.c .o Only left match main.c $ substring x. s.main.c .o No matches s. main.c