Muscat marketing research company is conducting a rating survey of different chains of supermarkets.The rating is over 5 stars (*****), a Text file is provided with two columns, one holds the name ofsupermarkets and the other column holds rating in stars. Find the list below of 9 supermarkets aboutwhom rating is being conducted. Each star is equal to 1 point. Suppose a supermarket get ** means it haspoints.sum of points of each market /number of times rated.got2Amarketisratedmorethanonce,sotheformulaeisNote: Program solution must use functions and arrays only.Download rating.txt from moodle.Rating.txt is containing 100 records, so you may declare array size as 100 as a global variable.Sample Text fileAuchanCarrefourrating.txt xAuchan***GeantCarrefour車末**Geant**HyperPandaHyperPandaLuluLuluLulu*********SpinneysSpinneysArwani Stores****ArwaniTalalTalalMadinaAuchanMadinatCarrefour****Geant**HyperPandaLulu*****Lulu*****Input (): A void function receives two arrays to read data from the file rating.txt, string array holds thenames of the supermarkets and an integer array holds the points, and count variable with reference getsthe number of records added from file to array.Process (): A void computes and prints the rating for each supermarket by adding all its points thendividing by number of times it has been rated.Sample Output:CAWindowssystem32cmd.exeNameNo Times RatedRating==== ==== =====-=== ===-= ===Auchan|CarrefourGeantHyperPandaLuluSpinneysArwaniTalalMadinaPress any key to continue3.444.223.00113.27224.55122.92103.50103.7083.38

Muscat marketing research company is conducting a rating survey of different chains of supermarkets. The rating is over 5 stars (*****), a Text file is provided with two columns, one holds the name of supermarkets and the other column holds rating in stars. Find the list below of 9 supermarkets about whom rating is being conducted. Each star is equal to 1 point. Suppose a supermarket get ** means it has got points. A market is rated more than once, so the formulae is sum of points of each market /number of times rated.

Muscat marketing research company is conducting a rating survey of different chains of supermarkets. The rating is over 5 stars (***), a Text file is provided with two columns, one holds the name of supermarkets and the other column holds rating in stars. Find the list below of 9 supermarkets about whom rating is being conducted. Each star is equal to 1 point. Suppose a supermarket get means it has got points. A market is rated more than once, so the formulae is sum of points of each market /number of times rated.

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

WRITE THE CODE IN PLSQL 1.You have a table AUDITORIUMS with nested table which represents the classes that take place in that auditorium: a. Auditorium number b. Class CLASS_TYPE_TABLE c. Max people allowed to be in auditorium Check, if class with parameters ("Databases", DSP101) is registered in auditorium 405!
sfdbxb
using python in jupyter notebook; we were given a csv file called stolen_animals.csv which contained data on stolen animals in london . The original raw data was given like this; Count of Stolen Animals,Type of Animal,Borough,Type Of Offence,Animal Recovered,Year and Month1,Dog,Lambeth,Theft and Handling,Not Recovered,Jan-20101,Dog,Islington,Violence Against the Person,Not Recovered,Jan-2010 but have written a function which made each column into list, count of stolen animals into a list of integers and the rest into list of integers. I now need to create functions to find the average number of stolen animals and another to get a list of unique types of animals that have been stolen. To add we are not allowed to use packages and can only input/output to be done by open and close. Below is the specifications given for each function
General Output Find Results 6. Filename: TriangleProblem_FamilyName If a, b and e represcent the three sides of a triangle, then the arca of the triangle is: A = /s + (s – a) + (s – b) * (s – c where: s = “tb+c Also the radius of the largest inscribed circle is given by: r_insc = 4 and the radius of the smallest circumscribed circle is: r_circ =- 2.0 a•b•c 4*A circ _inse Inscribed Circle Circumscribed Circle
write in c++Write a program that would allow the user to interact with a part of the IMDB movie database. Each movie has a unique ID, name, release date, and user rating. You're given a file containing this information (see movies.txt in "Additional files" section). The first 4 rows of this file correspond to the first movie, then after an empty line 4 rows contain information about the second movie and so forth. Format of these fields: ID is an integer Name is a string that can contain spaces Release date is a string in yyyy/mm/dd format Rating is a fractional number The number of movies is not provided and does not need to be computed. But the file can't contain more than 100 movies. Then, it should offer the user a menu with the following options: Display movies sorted by id Display movies sorted by release date, then rating Lookup a release date given a name Lookup a movie by id Quit the Program The program should perform the selected operation and then re-display the menu. For…
A basic wooden railway set contains the pieces shown in figure below. It identifies the quantityof each type of piece denoted by ‘x’. Each piece is not uniquely identified by a primary keyvalue only labeled by type. i.e., Input information only states quantity of types such as twelvestraight pieces, two branch pieces, two merge pieces, and sixteen curve pieces. Pieces connect the knob to opening, with subtend curves extending the arc from start to end by45 degrees, and the pieces can be flipped over for track direction. The task is to connect these pieces into a railway that has no overlapping tracks and no looseends where a train could run off onto the floor. Question: Suppose that the pieces fit together exactly with no slack. Give a precise formulation of thetask as a search problem. Write a Java algorithm to assemble optimally solving the problem.
Muscat marketing research company is conducting a rating survey of different chains of supermarkets. The rating is over 5 stars (*****), a Text file is provided with two columns, one holds the name of supermarkets and the other column holds rating in stars. Find the list below of 9 supermarkets about whom rating is being conducted. Each star is equal to 1 point. Suppose a supermarket get ** means it has got points. A market is rated more than once, so the formulae is sum of points of each market /number of times rated. Note: Program solution must use functions and arrays only. Download rating.txt from moodle. Rating.txt is containing 100 records, so you may declare array size as 100 as a global variable. Sample Text file Auchan Carrefour rating.txt x Auchan *** Geant Carrefour **** Geant HyperPanda **** ** HyperPanda Lulu Lulu **** 本 Spinneys Arwani Stores Talal Lulu Spinneys ** Arwani ***** Madina ***** Talal Auchan *** Madinat Carrefour **** Geant ** HyperPanda 本 ***** Lulu Tulu.…
A user wants to write a C program for manipulating student records. The program contains a function for accessing the student file. The user wants to add some records to the file. Which of the following line of code is used to open the student file for implementing this functionality? Choose an answer A fp = fopen ("studentfile.dat", "r"); B ch = fgetc(fp); C fp = fopen ("studentfile.dat", "w"); D fputc (ch, fp);
Write a program that reads movie data from a CSV (comma separated values) file and output the data in a formatted table. The program first reads the name of the CSV file from the user. The program then reads the CSV file and outputs the contents according to the following requirements: Each row contains the title, rating, and all showtimes of a unique movie. A space is placed before and after each vertical separator ('|') in each row. Column 1 displays the movie titles and is left justified with a minimum of 44 characters. If the movie title has more than 44 characters, output the first 44 characters only. Column 2 displays the movie ratings and is right justified with a minimum of 5 characters. Column 3 displays all the showtimes of the same movie, separated by a space. Each row of the CSV file contains the showtime, title, and rating of a movie. Assume data of the same movie are grouped in consecutive rows. Hints: Use the find() function to find the index of a comma in each row of…
This is sample data from my JSON file [ {"username" : "Jane Doe","date" : "Sat, 1 Apr 2023","time in" : "09:06:45 PM","status in" : "Working",}, {"username" : "Jane Doe","date" : "Sat, 1 Apr 2023","time out" : "09:06:57 PM","status out" : "Break" Please code a JAVA PROGRAM that will allow the server to determine if a user is currently working or on break by searching their name.
DescriptionWrite a program to compute average grades for a course. The course records are in a single file and are organized according to the following format: each line contains a student's first name, then one space, then the student's last name, then one space, then some number of quiz scores that, if they exist, are separated by one space. Each student will have zero to ten scores, and each score is an integer not greater than 100. Your program will read data from this file and write its output to a second file. The date in the output file will be nearly the same as the data in the input file except that you will print the names as last-name, first-name; each quiz score, and there will be one additional number at the end of each line:the average of the student's ten quiz scores.Both files are parameters. You can access the name of the input file with argv[1]. and the name of the output file with argv[2].The output file must be formatted as described below: 1. First and last names…
Suppose you have a text file named admission.txt that consists of applicants who have applied for admission in an IT institute. Data of file consist of multiple rows and each row represents one record separated by comma character in the following order. First Name Last Name CNIC Inter marks Percentage Age Phone Number Subjects in Inter (Major Subjects) There are 200 available seats for current session and first come first served model will be followed. Admission Eligibility criteria is: Percentage must be greater than 60 Age must be less than 30 Candidate must have studied Math/Stat or Computer in Inter. You are required to read and process the text file in a way that data of qualified candidates should be copied in a file qualified.txt. The data of new file must be comma separated…