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
Question
Please can you type and execute all four
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Make the following modifications for the solution above: name the output/input file "myRandomNumbers.txt" use a loop to output 17 random numbers to the file after creating the file, close it open the file for input and read the contents and then total the numbers in the file determine the average of the numbers in the file determine the highest and lowest numbers in the file DO NOT USE PYTHON BUILTIN FUNCTIONS TO CALCULATE THE AVERAGE OR THE HIGHEST AND LOWEST NUMBERS an expected number of modules/functions would be in the 5-8 range Display your results: the numbers generated on a single horizontal line the calculated total and average the highest and lowest number in the file Be sure to use clear prompts/labeling for input and output.arrow_forwardFor this task, you are to write code that handles the transfer of virtual coins between players in a video game. Instructions As this task relates to tranferring coins between players, a Player class has been provided, which supports adding and subtracting coins. Also provided is an interactive loop for testing the transfer of coins between players. Part A You are to write a function called transfer_coins with three parameters: the number of coins to transfer, the player from which coins will be taken (the "giver"), and the player which the coins will be given to (the "receiver"). It should use the appropriate instance methods on each of the player objects to update them as required. Part B If you tested your solution thoroughly in the previous part, you probably came across a logic error in the program---there's nothing to stop us from taking more coins from a player than they have! You are to fix this problem by raising an exception instead of completing the…arrow_forwardExercise Write the pseudo code and flowchart that will read a file of student test results and produce a student test grade report. Each test record contains the student number, name and test score (out of 50). The program is to calculate for each student the test score as a percentage and to print the student's number, test score (out of 50) and letter grade on the report. The letter grade is determined as follows: A = 90-100% B = 80-89% C = 70-79% 90-100 80-89 :A :B D = 60-69% E = 0 -59%arrow_forward
- Run the program below, which creates “Dates” in the HW library. You will need to change the input statement to account for the format of the raw data. Add the following to this data step: Using the yrdif function to add a variable called “Agetoday”, which is the age today. Use proc print to list all the variables to the output window. Remember to format all dates for output purposes. data HW.dates; input Subj $ DOB ; datalines; 001 11Nov06 002 25May07 003 25Dec06 ; run; proc; run;arrow_forwardWrite a program that will take in basic information from a student, including student name, degree name, number of credits taken so far, and the total number of credits required in the degree program. The program will then calculate how many credits are needed to graduate. Display should include the student name, the degree name, and credits left to graduate. Step 4: Write the exact output you would expect from the following line of code if the user of the program enters “Bill Jones”. (Reference: Displaying Items, page 40 – 41). Display “The student’s name is “, studentNamearrow_forwardpython Now write another program that reads the text file created in the program above and calculates the user's weekly pay. The program should begin by prompting the user for the regular hourly pay rate. The program should then loop through the file and report the days and hours worked. The program should finish by calling a custom void function named calc_pay that calculates and prints the weekly pay, including overtime, if applicable. By law, weekly hours in excess of 40 should be paid at 1.5 times the regular hourly rate. The calc_pay function takes two arguments, total hours and hourly pay rate, and it must be imported from a separate module file. Note that three outputs are required for the pay.Sample Output 1Enter your hourly pay rate 25.00Here are your hours this weekMonday hours : 10.0Tuesday hours : 8.0Wednesday hours : 12.0Friday hours : 12.0Saturday hours : 8.0You worked 50.0 hours this weekYou worked 10.0 hours overtimeYour hourly pay rate is $25.00 Regular pay :…arrow_forward
- Please write a SIMPLE C++ Code that takes the equation numbers of A,B and C from the input file, adds the 2 polynomials equations adjacent to each other together and then print out the results to an output file. Please include all files that should be in the code to your response. also make sure that the code is runnable. The prompt with all other directions is down below. A mini sample code is also there if you need any helparrow_forwardPROBLEM: Create a program that will ask to fill in two square matrices and perform matrix multiplication. Output the resulting matrix in proper format. SPECIFICATIONS that you need to follow: - The maximum size of the square matrices is 10x10. Matrices 1 and 2 should have the same dimensions. - You may only use the codes that we studied under our lectures - All lines of codes should have a comment. - Save your cpp file as Surname_FE (Example: Pangaliman_FE.cpp) TEST CASES: If a user inputs n = 2: Input: Input dimension (nxn) of the matrix, n = 2Input Matrix 1 elements: 1 2 3 4Input Matrix 2 elements: 5 6 7 8 Result: Resultant matrix: 19 22 43 50 If a user inputs n = 10: Input: Input dimension (nxn) of the matrix, n = 10 Input Matrix 1 elements: -35 54 64 31 45 -12 17 -31 -19 -78 -35 54 3 -10 -11 90 -41 31 -30 0 22 -53 21 -13 -64 32 -70 57 58 86 -77 30 73 24 -77 -90 -26 85 48 -47 -96 58 70 -59 82 -97 43 51 45 62 63 40 67 42 52 -78 -69…arrow_forwardEXCEL VBA (a) Write a user-defined function called SumStop which takes an integer n as an input and adds up the values of the cells in row 1 (starting from cell A1) until the value of the sum exceeds n, and then outputs the number of cells used. You may assume that all of the cells in row 1 contain numbers. Use a suitable Do While loop and the cells command. Declare all variable types and include appropriate comments in your code.arrow_forward
- please don't change variable namesarrow_forwardWhich scenario would make sense to implement a for loop? a) b) c) d) Computing the amount of caffeine in an input size cup of coffee Computing how many miles a car can drive with 10 gallons of gas Computing whether 10 numbers are even or odd Computing the number of pizzas to buy with an input number of peoplearrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- 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
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education