Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Bartleby Related Questions Icon
Related questions
Question
Javascript:
Using the data set as a pre-defined variable in your program, write code that uses the dataset to print the FIRST NAMES ONLY of people who have BOTH above average English grades AND below average age from the dataset.
var dataSet = [
{
"name":"Maura Glass",
"age":60,
"math":97,
"english":63,
"yearsOfEducation":4
},
{
"name":"James Gates",
"age":55,
"math":72,
"english":96,
"yearsOfEducation":10
},
{
"name":"Mills Morris",
"age":26,
"math":83,
"english":77,
"yearsOfEducation":10
},
{
"name":"Deena Morton",
"age":57,
"math":63,
"english":63,
"yearsOfEducation":10
},
{
"name":"Edith Roth",
"age":38,
"math":79,
"english":94,
"yearsOfEducation":10
},
{
"name":"Marva Morse",
"age":31,
"math":93,
"english":78,
"yearsOfEducation":9
},
{
"name":"Etta Potts",
"age":48,
"math":57,
"english":93,
"yearsOfEducation":7
},
{
"name":"Tate Moss",
"age":22,
"math":83,
"english":64,
"yearsOfEducation":8
},
{
"name":"Sanders Burris",
"age":27,
"math":65,
"english":66,
"yearsOfEducation":5
},
{
"name":"Latoya Malone",
"age":35,
"math":100,
"english":100,
"yearsOfEducation":5
},
{
"name":"Wade Foreman",
"age":25,
"math":76,
"english":87,
"yearsOfEducation":10
},
{
"name":"Miller Valentine",
"age":31,
"math":56,
"english":89,
"yearsOfEducation":6
},
{
"name":"Rita Olson",
"age":53,
"math":100,
"english":52,
"yearsOfEducation":6
},
{
"name":"Potter Newton",
"age":29,
"math":91,
"english":75,
"yearsOfEducation":5
},
{
"name":"Madeline Bartlett",
"age":23,
"math":60,
"english":74,
"yearsOfEducation":10
},
{
"name":"Tamara Tran",
"age":46,
"math":73,
"english":78,
"yearsOfEducation":4
},
{
"name":"Elena Evans",
"age":43,
"math":60,
"english":82,
"yearsOfEducation":10
},
{
"name":"Cote Merrill",
"age":55,
"math":86,
"english":63,
"yearsOfEducation":7
},
{
"name":"Madeleine Brennan",
"age":52,
"math":82,
"english":88,
"yearsOfEducation":4
},
{
"name":"Alford Weber",
"age":38,
"math":71,
"english":85,
"yearsOfEducation":4
},
{
"name":"Kirsten Daniel",
"age":35,
"math":86,
"english":61,
"yearsOfEducation":8
},
{
"name":"Melton Chan",
"age":26,
"math":55,
"english":96,
"yearsOfEducation":4
},
{
"name":"Mcmahon Woodward",
"age":54,
"math":56,
"english":63,
"yearsOfEducation":9
},
{
"name":"Helga Monroe",
"age":29,
"math":79,
"english":92,
"yearsOfEducation":5
},
{
"name":"Patricia Herrera",
"age":46,
"math":94,
"english":99,
"yearsOfEducation":10
},
{
"name":"Mccullough Lambert",
"age":56,
"math":65,
"english":96,
"yearsOfEducation":8
},
{
"name":"Haynes Davidson",
"age":60,
"math":86,
"english":50,
"yearsOfEducation":5
}
]
Requirements:
- Cannot use any array type built-in functions except filter(), map(), and reduce(). Thank you!
Expert Solution
Check MarkThis question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
bartleby
This is a popular solution
bartleby
Trending nowThis is a popular solution!
bartleby
Step by stepSolved in 3 steps with 3 images
Knowledge Booster
Background pattern image
Similar questions
- Given variable cities = {'GA' : 'Atlanta', 'NY' : 'Albany', 'CA' : 'San Diego'} write statement to delete then add an element to cities, so value of citiesbecomes {'CA': 'San Diego', 'NY': 'Albany', 'IN': 'Indiana'} Note: the order of the display of entries in a dictionary are not in a specific order.)arrow_forwardAssign pizzasInStore's first element's numCalories with the value in pizzasInStore's second element's numCalories. #include <stdio.h>#include <string.h> typedef struct Pizza_struct { char pizzaName[75]; int numCalories;} Pizza; int main(void) { Pizza pizzasInStore[2]; scanf("%s", pizzasInStore[0].pizzaName); scanf("%d", &pizzasInStore[0].numCalories); scanf("%s", pizzasInStore[1].pizzaName); scanf("%d", &pizzasInStore[1].numCalories); /* Your code goes here */ printf("A %s slice contains %d calories.\n", pizzasInStore[0].pizzaName, pizzasInStore[0].numCalories); printf("A %s slice contains %d calories.\n", pizzasInStore[1].pizzaName, pizzasInStore[1].numCalories); return 0;} I tried 10 time but I cant solve it so please help mearrow_forwardPlease use PYTHON def count_scrabble_points(user_input): """ The function ... """ tile_dict = { 'A': 1, 'B': 3, 'C': 3, 'D': 2, 'E': 1, 'F': 4, 'G': 2, 'H': 4, 'I': 1, 'J': 8, 'K': 5, 'L': 1, 'M': 3, 'N': 1, 'O': 1, 'P': 3, 'Q': 10, 'R': 1, 'S': 1, 'T': 1, 'U': 1, 'V': 4, 'W': 4, 'X': 8, 'Y': 4, 'Z': 10 } if __name__ == "__main__": ''' Type your code here. ''' Thank you!arrow_forward
- add code to display the information of each part in addition to the total inventory value in a table format. Old part number is OLS0001, quantity 30 and price 0.80, 24 is total inverntory Expected output: SMS0001 0.35 20 7.00 OLS0001 0.80 30 24.00 #include <stdlib.h>#include <stdio.h>#include <string.h>int main() { struct partitem { char number[10]; float price;};struct partitem part, oldpart;int oldpartqty; float oldpartprice;int qty = 20;part.price = 0.35;strcpy(part.number,"SMS0001");printf("price = %.2f\n",part.price);printf("name = %s \n", part.number);printf("quantity %d \n",qty );printf("enter oldpart\n");scanf("\n %s",oldpart.number);printf("\nold part number is %s",oldpart.number);printf("\nold part price");scanf( "%f",&oldpartprice);printf("old part qty");scanf("%d",&oldpartqty);printf("the price of the old part is %.2f \n",oldpartprice);printf("the qty of the old part is %d \n",oldpartqty);return 0;}arrow_forwardAssume an array is defined as int[] nums = {7, 15, 23, 5};. Which of the following would place the values in the array in descending numeric order? a. Array.Reverse(nums); b. Array.Reverse(nums); Array.Sort(nums); c. Array.Sort(nums); d. Array.Sort(nums); Array.Reverse(nums);arrow_forwardplease code this for pythonarrow_forward
- In the C programming language, if all function prototypes are listed at the top of your code, outside and above all functions, you do not need to worry about the order of the function definitions within the code. True Falsearrow_forwardWhen we use the Group-Object cmdlet, it will create this new property, which displays the number of objects in each grouping: Group of answer choices Number Count Entry Namearrow_forwardGiven code line, std::string un_address = "405 East 42nd Street, New York, NY, 10017"; Fill in the blanks: 17 std::stoi(un_address) returns std::stoi (un_address.substr( std::stoi (un_address.substr(un_address.find("1"))) J 20)) returns 42 returnsarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Text book imageDatabase System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationText book imageStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONText book imageDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- Text book imageC How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONText book imageDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningText book imageProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education