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
Write a
Course Number (key) Room Number (value)
CS101 3004
CS102 4501
CS103 6755
NT110 1244
CM241 1411
The 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 (key) Instructor (value)
CS101 Haynes
CS102 Alvarado
CS103 Rich
NT110 Burke
CM241 Lee
The program should also create a dictionary containing course numbers and the meeting times of each course. The dictionary should have the following key-value pairs:
Course Number (key) Meeting Time (value)
CS101 8:00am
CS102 9:00am
CS103 10:00am
NT110 11:00am
CM241 11:00pm
The program should let the user enter a course number, and then it should display
the course's room number, instructor, and meeting time.
Sample Run
Enter a class name: CS101↵
Class: CS101↵
Room: 3004↵
Instructor: Haynes↵
Time: 8:00am↵
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 1 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
- ‘Write a program to maintain grades for a class. The program will repeatedly prompt the user with the following menu, and use functions to perform the tasks ofuser's choice. Exit 1. Enter student info 2. Print grades for a student 3. Print class max, min, and average grades The program should use a dictionary to keep information about a student, including the student names and grades for three exams: midterm 1, midterm 2 andfinal exam. Assume the grades are positive integers between 0 and 100. The program should keep information about the students in a list for the entire class. ‘Assample run of the program is as follows. Exit 1. Enter student info 2. Print grades for a student 3. Print class max, min, and average grades Enter your choice: 1 Do you want to enter student info (y/n):Enter the student name: Adams Enter midterm 1 grade: 85 Enter midterm 2 grade: 87 Enter final exam grade: 90 Do you want to enter student info (y/n!Enter the student name: Mary Enter midterm 1 grade: 78 Enter...arrow_forwardQuestion 6 As a software engineer, you are hired to arrange cricket players based on their country and type. You have given all the player's information in a tuple called my_tuple. The players are from 3 countries which are Bangladesh, Australia and England. They are 2 types which are "Batters" and "Bowlers" You are given the following nested tuple where each element in the my_tuple is a tuple consisting of a name and a 4 digit ID. my_tuple = (("Mominul", 1101)., ("Mustafiz", 1202),("Bell", 2101),("Cook", 2103), ("Smith", 3101), ("Finch", 3102), ("Starc", 3203), ("Imrul", 1103), ("Taijul", 1204)) Write a python program that will convert this tuple into the following dictionary using the process described below: Your code should work for all types of similar tuple if the sample input is changed. Output dictionary (You just have to print the resultant dictionary. No need to follow the pattern below) 'Bangladesh':arrow_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_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_forwardPython 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_forward
- Create 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_forwardOverview 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_forward
- Which of the following statement is used to create a dictionary in python.? a. All of these b. dic={} c. dic={5:'Mueez',7:'Rayyaan') d. dic={'Mueez':5,'Rayyaan':7}arrow_forward(1) Create two dictionaries: one should contain bank account number as key and the customer name as value. The other should contain bank account number as key and the balance as value. (1 pt) Ex:An account dictionary with one entry: {'109': 'John Doe'} A balance dictionary with one entry: {'109': 2500.58} Create the following 4 accounts:Account #: Name: Balance ($): '109' 'John 'Doe' 2500.58 '110' 'Mary Woods' 1070.50 '111' 'Sam Brown' 7850.00 '112' 'Mark Miller' 5000.95arrow_forwardCreate a program that contains a dictionary containing 20 countries as keys and their capitals as values. ( Use the Internet if needed) 4. The program is to randomly quiz the user by displaying a country's name and ask user to enter the country's capital. 5. The program is to verify user's entry , if correct , program is to congratulate user and display another countries name. Use sentinel to allow the user to exit the program if they choose to. 6. The program should keep count of the number of correct and incorrect responses and display results when user chooses to stop playing Python codearrow_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