Write C program to keep records and perform statistical analysis for a class of 20 students. The information of each student contains ID, Name, Gender, quizzes Scores (2 quizzes per semester), mid-term score, final score, and total score.
The program will prompt the user to choose the operation of records from a menu as shown below:
============================================
Menu
============================================
1. Add student records
2. Delete student records
3. Update student records
4. View all student records
5. Calculate an average of a selected student's scores
6. Show student who gets the max total score
7. Show student who gets the min total score
8. Find student by ID
9. Sort records by total scores
NOTE : The code is needed in C language and Must not be pleagurised
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 4 images
- C++ Visual 2019 Insert into the PADDLING table the trip ID, trip name, state, distance, maximum group size, and season from the TRIP table for only those trips having type PADDLING.arrow_forwardA movie file has the following record structure: name of the movie producer director type production cost Assume that the name of the movie is the primary key of the file. The field type refers to the type of the movie, for example, drama, sci-fi, horror, crime thriller, comedy and so forth. Input a sample set of records of your choice into the movie file.i) Implement a primary index-based ISAM file organization.ii) Implement secondary indexes on director, type and production cost.iii) How could the secondary index-based file organization in Programming Assignment 3 (ii), be used to answer a query such as “Who are the directors who have directed films of the comedy or drama type, who have incurred the highest production cost?arrow_forwardMore data is always better than less data when making a programming choice, but you shouldn't make a call based only on performance.arrow_forward
- E MyS Mura 04- S Visu: Blac 9 Sign N Hom MyS y goog y! Exer SN c.blackboard.com/ultra/courses/_207342_1/cl/outline Completion Your answers are saved automatically. * Question Completion Status: QUESTION 1 Exercise: Create a statement that will make a copy of the vendors table. The name of the copy should be vendors QUESTION 2 Exercise: Create a statement that will delete the vendors archive table you created in the previous exercise. QUESTION 3 Exercise: Create a statement that will add the following row to the vendor_contact table Click Save and Submit to save and submit. Click Save All Answers to save all answers.arrow_forwardBAGGINS Trucking maintains a trip file in which each record contains the following data:DRIVER nameMILES driven on tripHOURS driven on trip Design an application that inputs records from the file (until reaching "eof") and, for each record, displays the DRIVER's name and the average Miles-per-Hours (MPH) for the trip where MPH is calculated by dividing the MILES by the HOURS. The program should also accumulate a GRAND total of the MILES driven. At the end, the program should display the GRAND total of the MILES driven. For example, if the trip file contained the following:Smith, 300, 5Williams, 750, 10Jones, 880, 11 then the program should display:Smith averaged 60 mphWilliams averaged 75 mphJones averaged 80 mphGrand total of miles is 1,930 Pseudocode:arrow_forwardin visual c# add customer id from customer table to booking table which has a customer id column. they are primary key and foriegn key and are linked in realtionship table in access file. when button is clicked insert first name into booking table in first name column. This should automaically copy customer id to booking table in customer id column without codingarrow_forward
- Write a stored procedure named displayNumberOfFilmRatings(). The displayNumberOfFilmRatings () procedure should find number of films for each film rating and then display the film rating and the number for films having that type of rating. Note: The displayNumberOfFilmRatings() procedure does not need to declare any variables. Hint: The output should have two columns only. Hint: There is no need to use cursor processing for this stored procedure.arrow_forwardprepare a flowchart please # inside data sub subarray[serial, name, amount]; # My data; data = [['01','A',4000],['02','B',8000],['03','C',10000],['04','D',12000],['05','E',16000]] serial = 0 name = 1 amount = 2 #update.... total = 0; for i in data: total = total+i[amount] print(f"The total amount is: {total}")arrow_forwardA Last In First Out (LIFO) data structure is a data structure in which the item that is added last will be removed fırst. True Falsearrow_forward
- SQL PROGRAM Create a function that takes Celsius temperature and returns a Fahrenheitarrow_forwardHoliday Travel Vehicle (HTV) sells new recreational vehicles and travel trailers. When new vehicles arrive at HTV, a new vehicle record is created. Included in the new vehicle record are a vehicle serial number, name, model, year, manufacturer, and base cost. When a customer arrives at HTV, he or she works with a salesperson to negotiate a vehicle purchase. When a purchase has been agreed upon, a sales invoice is completed by the salesperson. The invoice summarizes the purchase, including full customer information, information on the trade-in vehicle (if any), the trade-in allowance, and information on the purchased vehicle. The invoice also summarizes the final negotiated price, plus any applicable taxes and license fees. If the customer requests dealer-installed options (simply options), they are listed on the invoice as well. A customer may decide to have no options added to the vehicle or may choose to add many options. Dealer-installed options are described by an option code,…arrow_forward
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education