Question: Given the following problem specification, you need to develop a travelling agency system. The system will read 4 destinations (country name), then for each destination it will read 5 different tickes' prices. Make sure that prices are valid (cannot be 0 or negative) Calculate and print the average price for each destination ticket Find and print the maximum price Check the average price according to the table Price Message 150-500 Good deal Normal price 600-1000 1000+ Expensive Add comments to explain your code.

Question: Given the following problem specification, you need to develop a travelling agency system. The system will read 4 destinations (country name), then for each destination it will read 5 different tickes' prices. Make sure that prices are valid (cannot be 0 or negative) Calculate and print the average price for each destination ticket Find and print the maximum price Check the average price according to the table Price Message 150-500 Good deal Normal price 600-1000 1000+ Expensive Add comments to explain your code.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Managers Sales ManagerfirstName ManagerlastName ManagerTitle EmployeefirstName CompanyName RecipientFirstName RecipientlastName Product Quanity Address EmplooyeelastName EmployeeTitle Apt City Province PostalCode PricePerUnit TotalPrice SalesManFirstName SalesManlastName OperationExpenses EmployeefirstName/Vendoriame EmployeelastName PaymentType Paymentamount PaymentDate Address Quanity Apt City Province PostalCode Comments With the above, 1. Draw the cardinality charts including correct parent, child, min cardinality, and max cardinality
Correct and detailed answer will be Upvoted else downvoted. Thank you
An Art Museum needs to keep track of its artwork and exhibitions. The museum has a collection of artwork. Each piece of art has a unique id [ArtID], an artist, year and title. Artwork is categorized by type. There are two types, paintings and sculptures. Paintings have a paintType and style. Sculptures have a material, height and weight. Artwork is frequently shown in exhibitions. Each exhibition has a unique name, startDate, endDate. A listing of the artwork displayed at an exhibition is also retained. Below is an E-R diagram for a database to help the Art Museum. Provide appropriate names for entities E1, E2, E3, E4 identifiers 11, 12, 13, 14 missing attributes and relationship cardinality RC1 and relationship type RT1. Start_date End_date E1 E1 11 RC1 PaintType Style E3 13 A1 Title Year A/ A A/ A/ A/ A/ A/ A/ A A/ A/ E2 12 A/ E2 E3 E4 11 12 13 14 A1 A2 RC1 RT1 RT1 A2 Height Weight E4 14 Activate Go to Settin
stalls should be represented by ** , hazard boxes should be yellow two tables, one with hazards one without
Look up student MAJOR and ROOM information based on the student NAME. Enter formula into B2. 1 NAME MAJOR ROOM 2 58 3 4 NAME MAJOR ROOM 5 $1 CIS DBH 6 S2 7 3 A/F DBH A/F DBH 8 $4 мом SCI 9 S5 мом DBH 10 56 CIS SCI 11 S7 CIS DBH 12 S8 A/F 13 S9 мом 14 S10 CIS Size Color Price Item T. 15 Size L T M 16 Color R. 17 Price 28 H. 29 30 XL R. 18
The Marketing team of InstantRide wants to know that how many discounts have been offered for each ride. You need to calculate this information for each travel where a discount is applied and return two columns: TRAVEL_ID and DISCOUNT_AMOUNT. In addition, you need to return the calculation as a money value using the ROUND function to 2 decimals.
Question 8 The ERD below is the initial design to track events and the dates on which they are scheduled. Using the ERD, what can you determine about the statement "There were 5 events on July 4, 2012." EVENT DATE Has Scheduled on O This statement could NOT be true based on the ERD. O This statement could be true based on the ERD.
The histogram chart below has a single bar for every state in the United States. Each state is placed in a bucket, or range, based on its area in square miles. Count of States by Area in Square Miles 24 Area (Square Miles) (count) 18 12 50,000 100,000 150,000 200,000 Which of the following conclusions is BEST supported by the histogram chart? More than half of all states are smaller than 50,000 square miles B The most common size of states is between 50,000 and 100,000 square miles © Some states are larger than 200,000 square miles D More than half of all states are larger than 100,000 square miles
Correct and detailed answer will be Upvoted else downvoted. Thank you!
For this week's assignment you will allow the user to add employee, view all employees, search employee by ssn, and edit employee information. Below this is what its supposed to look like when completed. I have also included what I started to do but I can't figure out how to add the search by SSN option or the edit employee option. If you can give me a step by step on how to do this in python I would greatly appreciate it.
For the term project, you should write a report on a chosen topic related to your field. Follow the steps below: Choose a topic : Technology Narrow it down : Algorithms and data structures Find at least 10 related articles to your topic Read the articles, synthesize them and report the parts you want. Use appropriate citations and quotations (APA 6th or 7th edition) You need a reference list at the end of your report. The report should be minimum 1000 and maximum 2000 words.
After giving the correct answer, Please explain all the options thank you.