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%
Write a prgram that creates a dictionary containing course numbers and room numbers of the room where the courses meet. The dictionary should have the following key value pairs:
Course Number Room Number
CS101 3004
CS102 4501
CS103 6755
NT110 1244
CM241 1411
This program should also create a dictionary containing course numbers and the names of the instructors that teach each course. The dictionary should have the following key-value pairs:
Course Number Instructor
CS101 Haynes
CS102 Alvarado
CS103 Rich
NT110 Burke
CM241 Lee
This program should also create a dictionary containing the course numbers and the meeting times of each course. The dictionary should have the following key values
Course number Meeting Time
CS101 8:00 a.m.
CS102 9:00 a.m.
CS103 10:00 a.m.
NT110 11:00 a.m.
CM241 1:00 p.m.
If the course is not in the dictionary, a message should be displayed the program should contain a loop which continues to ask for course number unbolt the user chooses to quit
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 4 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
- If you are given the following dictionary: dict_1 = { 'Dallas': 'Cowboys', Green Bay': 'Packers New England': 'Patriots', Philadelphia': 'Eagles', Seattle': Seahawks } And you want to add a key value pairing for "New Orleans" : "Saints", what is the code you would use? add(dict_1["New Orleans": "Saints"]) dict_1["New Orleans"] = "Saints" In order to add another key value pairing, you would have to edit the original "dict_1" dictionary directly dict 1 New Orleans} == dict_1{Saints}> add("New Orleans" : "Saints"]_____ 00arrow_forwardPYTHON prov_records_per_date() takes a 2-D list (similar to the database) and an integer representing the province ID. This function returns another 2-D list, where each element of this list stores information in the following format. [ [day1, total number of patients (both icu and non-icu) in this provice reported in day1], [day2, total number of patients (both icu and non-icu) in this provice reported in day2], ... ] >>> results = prov_records_per_date(database, 35) >>> display_dict(result) >>> display_list(result) ['2022-01-31', 239] ['2022-02-05', 393] >>> results = prov_records_per_date(database, 10) >>> display_dict(result)['2022-02-02', 225] >>> results = prov_records_per_date(database, 81) >>> display_dict(result)No data in listarrow_forwardPlease written by computer source Eight students' grades in the respective courses are given via this dictionary:{'Math' : [80, 89, 93, 66, 84, 85, 74, 64],'Science' : [94, 76, 88, 78, 88, 92, 60, 85],'English' : [83, 76, 93, 96, 77, 85, 92, 60],'History' : [96, 66, 76, 85, 78, 88, 69, 99]}Form the corresponding pandas dataframe and report the means and standarddeviations by student and by course. Provide the 5-number summary for eachcourse.arrow_forward
- You are to write a short program using dictionaries. Create a dictionary object that will store key value pairs of cars and prices. The list of items are as follows. Tesla M3 = 67,000, Lexus RX400 = 53,000, Infinity G12= 14,000, Ford F150= 60,000, Honda Civic= 31,500. 1) First step is to save the data in the dictionary called cars. 2) Second step is for your program to ask the user to enter which car do they want to buy using the input method. The user may enter "Ford 150". 3) Third step is locating the car in the cars dictionary object. 4) Next step is to get the price from the dictionary to show to the user in the following format. "The car you selected Ford 150 is for 60,000ドル and with tax the total cost will be 64,200ドル" You should plan to use 7% for tax calculation. It could easily be calculated as 60000*.07 +たす 60000 =わ 64200arrow_forwardCreate a program that asks the user to enter a series of city names and populations. Each name and population should be added to a dictionary as a key/value pair. Once they are finished entering these values, use a dictionary comprehension to create a new dictionary featuring only the cities whose populations are over 2 million. Print the key/value pairs in the resulting dictionary out.arrow_forwardPerform the following tasks: Create a dictionary named color_dict containing key-value pairs 'red': 222, 'green': 184, and 'blue': 135. Read strings key_read and value_read from input. Add key_read and value_read as a new key-value pair to color_dict with key_read as the key and value_read as the value.arrow_forward
- Python program named "YourMuseumID_Exhibits.py" focusing on museum exhibit data: You have a list of dictionaries representing exhibits in a museum. Each dictionary contains the exhibit name, the number of artifacts on display, and the historical era it covers. Perform the following tasks: (a) Calculate and display the total number of artifacts on display for all exhibits in the museum. (b) Identify and display the exhibit with the highest number of artifacts on display. (c) Implement a function that takes a user-input exhibit name and searches for it in the list. If found, display the number of artifacts on display and the historical era it covers; if not found, print a message indicating that the exhibit is not in the museum. (d) Implement a sorting algorithm of your choice to sort the exhibits based on the number of artifacts on display in descending order and display the sorted list. Make sure to incorporate functions for each task and display the results in the main function with...arrow_forwardCreate a dictionary (order_dict) that the key is the burger number, and the value is a list of the quantities. For example: order_dict which is {'1': [10, 3, 78], '2': [35, 0, 65], '3': [9, 23, 0], '4': [0, 19, 43], '5': [43, 0, 21]} Create a dictionary (total_order_dict) that the key is the burger number, and the value is the total of the quantities for that burger. For example: total_order_dict which is {'1': 91, '2': 100, '3': 32, '4': 62, '5': 64} Use "assert to test the values of the total_order_dict For example: expected_result_ototal_order_dict = {'1': 91, '2': 100, '3': 32, '4': 62, '5': 64} assert actual_result_ototal_order_dict['1'] == expected_result_ototal_order_dict['1'] , "The actual result is not the \same as expected result for the order number 1!" (and test the other elements) The function can be like: def test_sum(): #Testing assert actual_result_ototal_order_dict['1'] == 91, "The actual result is not the \ same as expected result for the...arrow_forwardThe function below, get_value_if_key, takes two arguments: the dictionary data_dict and a key of any type my_key. Fix the code to return the value from data_dict for key my_key if that key exists. The function should not return anything otherwise (i.e. return None).arrow_forward
- Overview This program will welcome a user to the trivia builder 3000, then prompt the user to add questions to the trivia bank. After the user indicates they are done it will print out the contents of the trivia bank. Expected Output Example 1 Welcome to the trivia builder 3000 Enter the next question: Who was the fifth Beatle? Enter the correct answer for that question: Pete Best Enter the next question: You did not enter a question, let's try again. Enter the next question: How many dimples does a golf ball have Enter the correct answer for that question: 336 Enter the next question: Done We will stop entering questions now Here is the final trivia dictionary: The question is: Who was the fifth Beatle? And the answer is: Pete Best The question is: How many dimples does a golf ball have? And the answer is: 336 Example 2 Welcome to the trivia builder 3000 Enter the next question: What was the first name for the Beatles? Enter the correct answer for that question: The Quarymen Enter the...arrow_forwardThis program will store roster and rating information for a football team. Coaches rate players during tryouts to ensure a balanced team. (1) Prompt the user to input five pairs of numbers: A player's jersey number (0 - 99) and the player's rating (1 - 9). Store the jersey numbers and the ratings in a dictionary. Output the dictionary's elements with the jersey numbers in ascending order (i.e., output the roster from smallest to largest jersey number). Hint: Dictionary keys can be stored in a sorted list. (3 pts)Ex: Enter player 1's jersey number: 84 Enter player 1's rating: 7 Enter player 2's jersey number: 23 Enter player 2's rating: 4 Enter player 3's jersey number: 4 Enter player 3's rating: 5 Enter player 4's jersey number: 30 Enter player 4's rating: 2 Enter player 5's jersey number: 66 Enter player 5's rating: 9 ROSTER Jersey number: 4, Rating: 5 Jersey number: 23, Rating: 4 Jersey number 30, Rating: 2 ... (2) Implement a menu of options for a user to modify the roster. Each...arrow_forwardCreate a dictionary whose keys are month name and values is the number days in the corresponding months: a) Accept month name and number of days from the user. b) Print key in alphabetic order. c) Print months with 31 d) Accept number of days from the user and display all the month having those many days.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
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