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
thumb_up100%
I have to create a
- Your program will initialize lists to store information about the states. You should have one list for the names of the states, one list for the names of the capitals, one list for the names of the state birds per state, and one list for the order number the state joined the union. Alternatively, you can use a db list of lists as demonstrated in the exercises in the book to store the information in one structure or dictionaries.
- Next ask the user to enter a name of a state.
- Find the index of that name.
- Use that index to report back to the user the name of the capital, state bird, and the order the state joined the union.
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 2 images
Knowledge Booster
Background pattern image
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
- Please send me answer of this question immediately and i will give you like sure sirarrow_forwardCould you show me a different way to write this code in python? I’m trying to make the code simple and easy to understandarrow_forwardthe volume of traded Apple stocks during February and March 2022. The dates are in ascending order with their respective trade volumes.Input:Write a Python program that reads the data of the dates and stock volumesinto two separate lists.Output:The program must display the dates having the maximum and minimumtrading volume of each month. In addition, the program must display the whole trade volume, average trade volume for each month and shows the month that Apple has a higher trading volume.Sample Output:___________ has the maximum trade volume of ______________ in February.___________ has the minimum trade volume of ______________ in February.___________ has the maximum trade volume of _____________ in March.___________ has the minimum trade volume of ______________in March.The whole trade volume of these two months is ______________.The average trade volume of February is ______________.The average trade volume of March is ______________.AAPL has higher trading volume in...arrow_forward
- I have to create a program using python so that when the user inputs a state, it outputs the given info such as capital, state bird, and rank. I have most of it coded, but when I run the program I get an invalid syntax error, I'll attach a screenshot of what I have so far. I'll also attach what it's suppose to look like. Here are the instructions: Your program will initialize lists to store information about the states. You should have one list for the names of the states, one list for the names of the capitals, one list for the names of the state birds per state, and one list for the order number the state joined the union. Alternatively, you can use a db list of lists as demonstrated in the exercises in the book to store the information in one structure or dictionaries. Next ask the user to enter a name of a state. Find the index of that name. Use that index to report back to the user the name of the capital, state bird, and the order the state joined the union.arrow_forwardOne of the things discussed in this chapter is the sorting of data. Imagine that a large medical center hires you to write a program that displays a list of potential organ recipients. The hospital's transplant team will consult this list if they have an organ available for transplant. The hospital administrators have instructed you to sort potential recipients by last name and display them in alphabetical order. If more than 10 patients are waiting for a particular organ, the first 10 patients will be displayed; a doctor can either select one or move on to view the next 10 patients. You are concerned that this program will unfairly select patients whose last names begin near the front of the alphabet. It's critical that the hospital has a program written quickly, as the hospital currently has no method of going through potential organ recipients. Based on this, answer the following questions in detail: Would you write and install the program? If yes, would you change anything about...arrow_forwardPlease help me with this in python. I have attached question and output below.arrow_forward
- Write a program in python that allows the user to enter the total rainfall amounts from your home town for each of 12 months of 2020 into a list. (Use whatever numbers you want) Display the month and the rainfall amounts. The program should calculate and display the total rainfall amount for the year and the average monthly rainfall, Be sure to identify the amounts displayed. Also determine and display the months with the highest and lowest rainfall amounts. When displaying the months with the highest and lowest rainfall, use a string method to display just the first three letters of the months with the highest and lowest rain amounts. REMEMBER to put comments, and write comments through both programs (file creation program, and display program) telling what the program is doing.arrow_forward1. Write a python program called a2_q1.py that asks the user (business owner) for their product information and creates an electronic list (e-list) of items. In part-2 of this assignment, customers should be able to use this e-list to purchase multiple products of varying quantities while products are available in stock.Your program should start by asking the business owner’s name (string) and the name of the company (string). Next, it should ask for three (3) product names (strings), their unit prices (floats), and the total number of products in stock (ints). Finally, it should display the list of items. Note: users are always allowed to enter any type of data when asked for input. Your program must always verify the user input. Invalid input should be handled with suitable error messages for each type of invalid input and the prompt should be repeated. To keep things simple, we will consider that when prompted a user can enter either an integer, a string, or a float (i.e., not a...arrow_forwardThis is the questions and answers for the first parts Questions: Using Python Create a list with building names 'Richard Weeks Hall’, ’Busch Student Center’, ‘Environmental & Natural Resource Sciences Building’ Replace the list to 'Richard Weeks’, ’Busch Student Center’, ‘Environmental & Natural Resource Sciences Bldg’ Code for the total points of each name by setting• The base points as the length of the building name.• The bonus points: as ‘Bldg’ being equal to 10 points Meaning, 'Academic Building' which would be 'Academic Bldg' would have a base point of 13 and a bonus point of 10 for a total of 23. #1 Create a list of buildings Buildings=[ 'Richard Weeks Hall', 'Busch Student Center', 'Environmental & Natural Resource Sciences Building' ] print("The Building names in the list are: ") print(Buildings) #2 Process the name of each building res = [sub.replace(' Hall', '').replace('Building', 'Bldg') for sub in Buildings] print("The names have been replaced to :...arrow_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