New Perspectives on HTML5, CSS3, and JavaScript
6th Edition
ISBN: 9781305503922
Author: Patrick M. Carey
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 9, Problem 6CP3
Above the randomlnt() function insert a command to call the function, generating a random integer from 0 to 9. (Hint: Remember that the size of this interval is 10 because it includes 0 in its range.) Store the result from the function in the randomQ variable.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
. The O’Neill High School Performing Arts Center auditorium contains 20 rows (numbered 1through 20) with 40 seats each (numbered 1 through 40). Write an application that allows auser to continuously enter a row and seat request until a sentinel value is entered. If the rowor seat number is too high, issue an error message. Otherwise, determine whether the seat hasalready been reserved. If so, display an error message; if not, then charge the user $7.50 for aticket and display a running total of the user’s purchase. When the user enters a sentinel,display the number of seats taken and the number still available in the auditorium.
Below is the code for a procedure that will accept a Customer ID as an input parameter and display the Customer ID, Customer Surname and Customer Address.
Review the code, then answer the questions that follow.
create or replace procedure sp_customer_details (c_id IN CUSTOMER.cust_id%TYPE,customer_details out VARCHAR2)ISBEGINSELECT 'CUSTOMER ID:' || c.cust_id || ', Surname:'|| c.cust_sname || ',ADDRESS:' ||c.cust_addressinto customer_detailsfrom CUSTOMER cwhere c.cust_id = c_id;END;
Q.1 Briefly discuss the advantages of using the %TYPE attribute in the code.
Q.2 Create the code to execute the procedure with exception handling if no customer data is found. Use customer ID C115 in your code.
Q3:Create a series called 'directors' that contains each director's name and his or her average rating. Print out the type of your variable.
Q4:Select the non-USA movies made after 1960 by Hayao Miyazaki.Save the result in a DataFrame called 'miyazaki', then print it.
Here are the steps:1. Query the data ('df' DataFrame) based on the following conditions:- Non-USA movies (country_id != 1)- Movies made after 1960 (title_year > 1960)- Movies made by director Hayao Miyazaki (director_id == 46)2. Save the filtered data in a DataFrame called 'miyazaki' and print it
Q5:Create a Pivot Table that shows the median rating for each director, grouped by their respective countries. Name your variable'pivot_agg'
Q6:How long did the movie Gladiator aim to keep your attention? Save the series with this informationin a variable called 'gladiator_duration', then print it.
Chapter 9 Solutions
New Perspectives on HTML5, CSS3, and JavaScript
Ch. 9.1 - Prob. 2QCCh. 9.1 - What is the difference between asynchronously...Ch. 9.1 - Provide the command to display an alert dialog box...Ch. 9.1 - Prob. 8QCCh. 9.2 - Prob. 6QCCh. 9 - Prob. 2RACh. 9 - Prob. 4RACh. 9 - Prob. 5RACh. 9 - Prob. 6RACh. 9 - Prob. 7RA
Ch. 9 - Prob. 8RACh. 9 - Prob. 9RACh. 9 - Prob. 10RACh. 9 - Prob. 11RACh. 9 - Prob. 1CP1Ch. 9 - Prob. 2CP1Ch. 9 - Prob. 3CP1Ch. 9 - Prob. 4CP1Ch. 9 - Prob. 5CP1Ch. 9 - Prob. 6CP1Ch. 9 - Prob. 7CP1Ch. 9 - Prob. 8CP1Ch. 9 - Prob. 9CP1Ch. 9 - Prob. 10CP1Ch. 9 - Prob. 11CP1Ch. 9 - Prob. 12CP1Ch. 9 - Prob. 13CP1Ch. 9 - Prob. 14CP1Ch. 9 - Prob. 15CP1Ch. 9 - Prob. 16CP1Ch. 9 - Prob. 1CP2Ch. 9 - Prob. 2CP2Ch. 9 - Prob. 3CP2Ch. 9 - Prob. 4CP2Ch. 9 - Prob. 5CP2Ch. 9 - Prob. 6CP2Ch. 9 - Prob. 7CP2Ch. 9 - Prob. 8CP2Ch. 9 - Prob. 9CP2Ch. 9 - Prob. 10CP2Ch. 9 - Prob. 11CP2Ch. 9 - Prob. 12CP2Ch. 9 - Prob. 13CP2Ch. 9 - Return to the bc_today.js file and change the...Ch. 9 - Prob. 15CP2Ch. 9 - Prob. 1CP3Ch. 9 - Prob. 2CP3Ch. 9 - Prob. 3CP3Ch. 9 - Prob. 4CP3Ch. 9 - Prob. 5CP3Ch. 9 - Above the randomlnt() function insert a command to...Ch. 9 - Prob. 7CP3Ch. 9 - Prob. 8CP3Ch. 9 - Prob. 9CP3Ch. 9 - Prob. 10CP3Ch. 9 - Prob. 2CP4Ch. 9 - Prob. 3CP4Ch. 9 - Prob. 4CP4Ch. 9 - Prob. 5CP4Ch. 9 - Prob. 6CP4Ch. 9 - Prob. 7CP4Ch. 9 - Prob. 8CP4Ch. 9 - Explore 9. Scroll back to the top of the file and,...Ch. 9 - Prob. 10CP4Ch. 9 - Prob. 13CP4
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
- The above screen is used to browse the products table it uses the ProductDAO.java file, it calls the getProductByCriteria() function which should accept a parameter, this parameter should be the criteria that would be built from the two combo boxes and the text box, and queries the products table.The getProductByCriteria() function should return a list of Product objects that matches the criteria specified. Modify the function so that it accepts a string paramater consisting of the fields from the combo boxes and a price number from the text box separated by commas and use this string to modify the query in the function to return the desired result set. public List<Product> getProductByCriteria() //MAKE MODIFICATIONS TO THIS FUNCTION SO IT CAN TAKE PARAMETER(S) { if (openConnection()) { try{ List<Product> items = new ArrayList <> (); Product temp = null; String…arrow_forwardWhen a lot of changes are required in data, which one should be a preference to be used? String or StringBuffer?arrow_forwardQ5:Save all of this director's movies and their ratings in a variable called all_movies_ratings, then print this variable.(The director with the most movies you got from the last question.) # your code hereall_movies_ratings = all_movies_ratings[['movie_title', 'imdb_score']] #this will select this columns onlydf['movie_title'] = df['movie_title'].str.replace('Ê','')print("\nQUESTION 5:")print(all_movies_ratings) Q6:Recommend a **random** movie that has a rating of over 8.3. Store the random recommendation in a variable called "rand_goodmovie".What is the title and imdb_score of your recommendation? Here are the steps:1. Query the data ('df' DataFrame) for movies with a rating over 8.3 (imdb_score > 8.3)2. Create a random integer index location to get a single movie recommendation3. Save the random movie recommendation in a DataFrame called 'rand_goodmovie'4. Save the title of the random movie recommendation in a variable "random_title" and print it5. Save the imdb_score of the…arrow_forward
- The syntax of a statement that invokes (calls) an independent Sub procedure is ____. a. procedureName([argumentList], dataType) b. procedureName([argumentList]) c. procedureName([argumentList]) As dataType d. procedureName{[parameterList]}arrow_forward3. 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)arrow_forwardFix the following code:Option StrictDim intDistance As IntegerintDistance = 17.5arrow_forward
- switch_player(): we will allow the players to choose their own names, but for our purposes, it is easier to think of them as number (0 and 1, for indexing purposes). We will display their names to them on the screen, but in the background, we will keep track of them based on their number. This function should take 1 argument, an integer (either 0 or 1) representing the player and should return the opposite integer (1 if 0 is entered and 0 if 1 is entered). This is a simple function, but it will make our code cleaner later. Use your constants! Using Thonnyarrow_forwardWindow 1Should have a welcome message, a textbox to receive AN EXISTING ID of the user and a button to access the data base. All users ID should be saved in a data base (Don’t use access). Once the Id is verified then the program will give the user access to the main menu window.Your database should have the following columns. Use SQL/mySQL to create the database and Netbeans as the IDE.arrow_forwardThe Movie table has the following columns: ID - positive integer Title - variable-length string Genre - variable-length string RatingCode - variable-length string Year - integer Write ALTER statements to make the following modifications to the Movie table: Add a Producer column with VARCHAR data type (max 50 chars). Remove the Genre column. Change the Year column's name to ReleaseYear, and change the data type to SMALLINT.arrow_forward
- 15. Suppose that Column B contains 100 observations of a string variable. Which of the following is therefore true? a. The command =AVERAGE(B2:B101)/100 will return the average value of this variable. b. The "COUNTIF" command cannot be applied to the data in this column. C. The "MODE" command can be applied to the data in this column. d. The "MEDIAN" command cannot be applied to the data in this column.arrow_forwardThis is the question I am stuck on - Add a prompt to the ShadyRestRoom application to ask the user to specify a (1) lake view or a (2) park view, but ask only if the bed size entry is valid. Add $15 to the price of any room with a lake view. If the view value is invalid, display a you selected an invalid option and assume that the price is for a room with a lake view. This is the code I have from the previous probelm but I am unsure how to add all that onto it - import java.util.Scanner; public class ShadyRestRoom2 { // Modify the code below public static void main (String args[]) { int selection; int price; String result; final int QUEEN = 1, KING = 2, SUITE = 3; final int QPRICE = 125, KPRICE = 139, SPRICE = 165; final String QSTRING = "Queen bed", KSTRING = "King bed", SSTRING = "Suite with a king bed and pull-out couch", INVALIDSTRING = "an invalid option"; Scanner in = new Scanner(System.in);…arrow_forwardWhich delimiter will be selected to change the text 'Happy#go#lucky' in to column? a. tab b. semicolon c. other d. spacearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
dml in sql with examples; Author: Education 4u;https://www.youtube.com/watch?v=WvOseanUdk4;License: Standard YouTube License, CC-BY