Concept explainers
Conference Planning
The following table shows a training company's workshops, the number of days of each, and their registration fees.
Conference Number of Days Registration Fee
Handling Stress 3 $1,000
Time Management 3 $800
Supervision Skills 3 $1,500
Negotiation 5 $1,300
How to Interview 1 $500
Conferences are held in several locations. The table below contains locations and hotel fees per day.
Location Hotel Fees per Day
Austin $150
Chicago $225
Dallas $175
Orlando $300
Phoenix $175
Raleigh $150
When a customer registers for a conference, he or she must pay the registration fee plus the lodging fees for the selected location.
Example: Supervision Skills in Orlando
Registration: $1,500
Lodging: $300 x 3 days = $900
Total: $2,400
Create an application that lets the user select a workshop from one ListBox and a location from another ListBox. When the user clicks a button Calculate, the application should calculate and display the registration cost, the lodging cost, and the total cost. Use a switch statement in your solution.
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 3 images
- Access: Tables and Controlsarrow_forwardPlease answe all the three subs parts questions. Do not manually calculates. Answer all the 3 subs parts . Correct answrs from experts. Thanksarrow_forwardHow many times has each language been used in films? Return the value for all six languages. Display: language name and the number of filmsarrow_forward
- first last cid name quantity ordDate address Customer custord Order prodord pid Product pname price color What is the primary key of ORDER table? Select one: a.ORDER table has no Primary Key b.Combination of cid and pid c.Combination of cid, pid and ordDate d.cidarrow_forwardAdd Course Course ID: Level: list Box 1 Department ID: Award Body: Course Name: Lecturer: Add Clear Exit could someone please write a sample of work breakdown documents for thisarrow_forwardTest Methods for Software Where do you draw the line while doing domain testing? Please provide a succinct summary of each.arrow_forward
- There are several types and sizes of constraints.arrow_forwardNow, you will calculate the highest-price house highest-price house sold for each agent when he or she served as a Dual Agent (DA). Use mixed references for ranges and the agent code condition in cell J3. Use relative cell references to the agent condition in cell E2. When you copy the formulas, use the paste Formulas options to preserve border formatting. In cell H2, insert the MAXIFS function in cell H2 to display the highest-price house sold by the first agent (cell E2) who was a Dual Agent (DA) (J3) for that house. Copy the function to the range H3:H4 and preserve the borders in the range H3:H4.arrow_forwardTable: Task Primary key: TaskID Foreign key: Team MemberID TaskID 1 2 3 Description Build login screen Implement inventory management Add logo to splahs 1 screen Duration StartDate 2022-05-06 1 2022-05-15 1 4 10 TeamMemberID 2022-05-06 2 Write a SQL statement to create the table Task. Hint: The sample data should give you an indication of the data types you should use.arrow_forward
- student takes ID ID course_id sec_id semester year grade пате dept_name tot_cred section course department course_id sec_id semester year building room_no time_slot_id course_id title dept_name credits advisor dept_name building budget s_id i id time_slot time_slot_id day start_time end_time prereq instructor classroom COurse_id prereg_id ID building пате dept_name salary room_no сараcity teaches ID course_id sec_id semester year Consider the relation that results from the expression: course natural join department Which of the following functional dependencies hold for this relation? (Mark all that apply) O {title, credits} -> building O dept_name -> budget O course_id -> {budget} O {building, budget} -> dept_name O title -> credits O {course_id, title} -> creditsarrow_forwardComputer Science A study conducted by Netflix’s consumer relations department has revealed that customers are more likely to review horror and thriller movies during certain months of the year. To discourage seasonal variations in these movie ratings, Netflix has called for your help to analyze horror and thriller movie rating counts over the past 15 years. Your query should display each month of the year (name of the month not the number) and the total number of ratings given during that month. A third column titled “Promotion Recommendation” determines whether a promotion should be applied to increase the number of ratings given during that month. If a month has less than 2200 ratings the final column should display ‘10% discount promotion’, if between 2201 and 4500 then display ‘5% discount promotion’, and if more than 4500 ratings then output ‘No Promotion’. Order your results by months. Do not hardcode the current date. ORALCE CODE PLEASE.arrow_forwardThe spreadsheet contains codes (BA, DA, SA) to represent agent roles (Buyer's Agent, Dual Agent, Seller's Agent). You want to switch the codes for the actual descriptions. In cell E12 of the Details sheet, insert the SWITCH function to evaluate the agent code in cell D12. Include mixed cell references to the codes and roles in the range J2:K4 for the values and results arguments. use all cell references in the function. Copy the function to the range E13:E39. Now you want to calculate the number of days between the list date and sale date. In cell J12, insert the DAYS function to calculate the number of days between the Listing Date and the Sale Date. Copy the function to the range J13:J39. You want to calculate agent commissions based on their role. In cell K12, insert the IFS function to calculate the agent's commission based on the agent code and the applicable rates in the range L2:L4. Use relative and mixed references correctly. Copy the function to the range K13:K39. You want to…arrow_forward
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education