User Account

All Pages

Create an exit button

Assignment Help PL-SQL Programming
Reference no: EM13934621

I need assistance with following (Visual Basic .Net) VB.NET program. I can build the GUI, however I need help with the

calculation for the box office average against the movies.

List your employees names in a drop down combo box. When the user selects a employee, display in a text area all of their

previous work performed under code name James Bond 007. In a single text area, output the data in this order:

Year Name of Mission Adjusted total box office

Obtain the required information from attached "Program 3 Data.txt".

1. Ensure that when a employee is selected, any text area is cleared and the new employee data is displayed.

2. Create a clear button that clears all of the text in the text area, clears the summary area and resets the combo box to its

default setting.

3. Create an exit button.

4. Ensure to provide instruction to the user of how to use the program. Create a menu bar item which contains a help function.

5. Use a single text area for the display.

6. Create a 'Summary' area on the GUI that allows for quick reference.

7. In the summary area, create a check box for each employee so that a user can either select any number of employees.

8. When an employee is selected, display the Adjusted Box average of all missions the employee participated in on a new

label.

9. When two or more employees are selected, display the most profitable employees name and averaged adjusted box office.

10. To average the adjusted box office, average the total box office against the number of movies the employee worked.

Year          Title                                            Actor                       Inflation Adjusted Total Box Office

1962        Dr. No                                          Sean Connery              $425,488,741

1963        From Russia with Love                    Sean Connery              $555,909,803

1964        Goldfinger                                     Sean Connery              $868,659,354

1965        Thunderball                                   Sean Connery              $966,435,555

1967        You Only Live Twice                        Sean Connery               $720,388,023

1969        On Her Majesty's Secret Service        George Lazenby            $513,445,231

1971        Diamonds Are Forever                     Sean Connery              $617,520,987

1973        Live and Let Die                              Roger Moore                $785,677,477

1974        The Man with the Golden Gun            Roger Moore                $426,826,774

1977         The Spy Who Loved Me                    Roger Moore               $666,367,656

1979         Moonraker                                       Roger Moore                $624,527,272

1981         For Your Eyes Only                            Roger Moore                $481,005,579

1983         Octopussy                                        Roger Moore                $405,873,493

1985         A View to a Kill                                   Roger Moore                 $316,186,616

1987        The Living Daylights                            Timothy Dalton              $362,876,056

1989          Licence to Kill                                    Timothy Dalton               $271,586,451

1995         GoldenEye                                          Pierce Brosnan               $499,954,330

1997        Tomorrow Never Dies                             Pierce Brosnan               $465,588,535

1999        The World Is Not Enough                        Pierce Brosnan               $504,705,882

2002         Die Another Day                                   Pierce Brosnan               $546,490,272

2006        Casino Royale                                       Daniel Craig                   $640,803,677

2008        Quantum of Solace                                 Daniel Craig                    586,090,727

Reference no: EM13934621

Questions Cloud

Calculate overhead allocation rates based on direct labor : Calculate overhead allocation rates based on direct labor hours, direct labor cost, and machine time.
Performance evaluation of portfolio is difficult : Performance evaluation of a portfolio is difficult. What challenges can investment managers face and what recommendations would you make in effort to meet these challenges? Portfolio insurance has always had an intuitive appeal to investors, particul..
Respiratory and integumentary systems : Choose two different body systems that have been covered so far in this module (please use respiratory and integumentary systems) and, within each system, compare and contrast three disease states, with a view to recognising and managing them in c..
Determine the length of a dna molecule in micrometers : Give mathematical expression to calculate the number of possible sequences of nucleotide pairs with the usual base pairing, for a molecule of n-deoxyribonucleotide pairs.
Create an exit button : Ensure that when a employee is selected, any text area is cleared and the new employee data is displayed
What is the dealer effective rate of return on the loan : You will buy a car at $25,600 and a dealer computer the monthly payment to be $508.45 for 60 months of financing. What is the dealer's effective rate of return on the loan?
Calculate the cost of forward contract and option : Assume the following: LC Exposure = 10,000; Spot Rate = $1.00/LC1.00; 1 Year Forward = $0.98/LC1.00; 1 Year Strike Price = $0.975; Premium = $0.005; and WACC = 8.0% p.a. Please calculate the cost of the forward contract and the option.
Government sources in reporting on inequalities in health : 1. Explain the effects of socioeconomic influences on health. 2. Assess the relevance of government sources in reporting on inequalities in health.
Understanding of-ability to apply the programming concepts : This assignment tests your understanding of and ability to apply the programming concepts we have covered in the unit so far, including the usage of variables, input/output, data types, selection, iteration, functions and data structures.

Reviews

Write a Review

PL-SQL Programming Questions & Answers

  Create a database model

Create a database model and Submit the table creation statements for the Database Model.

  Write pl-sql procedures and functions

Write PL/SQL procedures and functions to populate and query that database

  Sql questions

Write a query to display using the employees table the EMPLOYEE_ID, FIRST_NAME, LAST_NAME and HIRE_DATE of every employee who was hired after to 1 January, 1995.

  Run the lab_03_01.sql script

Run the lab_03_01.sql script in the attached file to create the SAL_HISTORY table. Display the structure of the SAL_HISTORY table.

  Write sql queries

Write a query to display the last name, department number, and salary of any employee whose department number and salary both match the department number and salary of any employee who earns a commission.

  Explaining sql insert statement to insert new row in cds

Write down a SQL insert statement to insert new row in "CDS" table.

  Write down name of actors in ascending order

Write down actors (or actress, your choice, but not both) who have won at least two (2) Academy Awards for best actor/actress. Provide the actor name, movie title & year. Order the result by actor name."

  What is an sql injection attack

What is an SQL injection attack? Explain how it works, and what precautions must be taken to prevent SQL injection attacks.What are two advantages of encrypting data stored in the database?

  Determine resonant frequency in series rlc resonant circuit

Given the series RLC resonant circuit in the figure, operating at variable frequency, determine: The resonant frequency ω o ,  The circuit’s quality factor Q , The cut-off frequencies, f 1  & f 2  and the bandwidth BW

  Query that uses cube operator to return lineitemsum

Write summary query which uses CUBE operator to return LineItemSum (which is the sum of InvoiceLineItemAmount) group by Account(an alias for AccountDesciption).

  Query to show customers were missing for existing orders

As DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Write query which would shows which customers were missing for existing orders. Use a join or a subquery.

  Sql query into a relational algebra statement

Turn this SQL query into a relational algebra statement? SELECT Request.reqfor, Ordering.invamt, Ordering.invnbr, Ordering.invdat

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd