
Explanation of Solution
a.
Creation of spreadsheet:
Step1: Open the Microsoft Excel and enter the given data in the “Ch02Ex01_U10e.docx” file.
Step2: Compute the difference between current salary and Industry Average Salary.
- The formula for find the difference for Account department is “$B$2 – B7”.
- Then click and drag for finding the remaining rows. Proposed increase is for those who are highlighted in green color.
Screenshot of Excel sheet
The formula for find the difference for Marketing department is “$B$3 – B7”. Then click and drag for finding the remaining rows.
Screenshot of Excel sheet
The formula for find the difference for
Screenshot of Excel sheet
Step3: calculating the percentage to meet Industry Average...
Explanation of Solution
b.
Analysis made in contributing employee salary decision:
The above analysis can be used for making employee salary decision, those who are below the industry average range is recommended for salary rectification...
Explanation of Solution
c.
Three ways the user can share the Access application with another:
Share data by using network folders:
- This is the simplest option and has the least requirement. In this method, the
database file is stored on a shared network drive and all users can use that file at a time. - Advantage – all the users can use that file simultaneously.
- Disadvantage – the original data can be modified because of multiple users use that file simultaneously.
Share a database by using a server:
- This method is store the tables on the network and each user has local copy of a database file which contains links to the tables, along with forms, quires, objects and reports...

Want to see the full answer?
Check out a sample textbook solution
- how to read log logsarrow_forwardDiscrete Mathematics for Computer Engineeringarrow_forwardQuestion 1 - Array Iterators Like the JS on A2, there is no visual component to this question. The HTML really just needs to load the JavaScript, everything else will output to the console. The JS file should the completion of the task, and all necessary testing, so that just loading the file will complete the task with enough different inputs to ensure it works. Even Numbers [3 marks] Create a function that determines if a provided number is even. Define an array of numbers, then on the array use the appropriate array iterator to determine if the array contains only even numbers using the function you defined. Output the results, and test with several arrays. Long Names [3 marks] Define an array of names. Use an iterator to retrieve a new array containing only the names longer then 12 characters. Your iterator should be passed an anonymous arrow function. Test with several different arrays First Names [3 marks] Define an array called fullNames that contains 7 javascript objects of…arrow_forward
- Discrete Mathematics for Computer Engineeringarrow_forwardthis module is java 731 . make sure my answers are 1005 correct and the layout and structure is perfect and also include all comments etc. thank you i have attached question 1 (40 marks) and question 2 (30 marks ) this is question 3: Question3: (30 MARKS) Passenger Rail Agency for South Africa Train Scheduling System Problem Statement Design and implement a train scheduling system for Prasa railway network. The system should handle the following functionalities: 1. Scheduling trains: Allow the addition of train schedules, ensuring that no two trains use the same platform at the same time at any station. 2. Dynamic updates: Enable adding new train schedules and canceling existing ones. 3. Real-time simulation: Use multithreading to simulate the operation of trains (e.g., arriving, departing). 4. Data management: Use ArrayList to manage train schedules and…arrow_forwardthis module is java 731 . make sure my answers are 1005 correct and the layout and structure is perfect and also include all comments etc. thank you i have attached question 1 (40 marks) and question 2 (30 marks ) this is question 3: Question3: (30 MARKS) Passenger Rail Agency for South Africa Train Scheduling System Problem Statement Design and implement a train scheduling system for Prasa railway network. The system should handle the following functionalities: 1. Scheduling trains: Allow the addition of train schedules, ensuring that no two trains use the same platform at the same time at any station. 2. Dynamic updates: Enable adding new train schedules and canceling existing ones. 3. Real-time simulation: Use multithreading to simulate the operation of trains (e.g., arriving, departing). 4. Data management: Use ArrayList to manage train schedules and…arrow_forward
- this module is java 731 . make sure my answers are 1005 correct and the layout and structure is perfect and also include all comments etc. thank you i have attached question 1 (40 marks) and question 2 (30 marks ) this is question 3: Question3: (30 MARKS) Passenger Rail Agency for South Africa Train Scheduling System Problem Statement Design and implement a train scheduling system for Prasa railway network. The system should handle the following functionalities: 1. Scheduling trains: Allow the addition of train schedules, ensuring that no two trains use the same platform at the same time at any station. 2. Dynamic updates: Enable adding new train schedules and canceling existing ones. 3. Real-time simulation: Use multithreading to simulate the operation of trains (e.g., arriving, departing). 4. Data management: Use ArrayList to manage train schedules and…arrow_forwardDiscrete Mathematics for Computer Engineeringarrow_forwardTask 1: Write an abstract class Method +: public -: private #: protected Underline: static # input: int # output:String Method + isHard():boolean + specificWay():String + Method() + Method(input: int, output: String) + getInput(): int + setInput(input: int): void + getOutput(): String + setOutput(output: String): void +toString(): String Question Task 2: Write a class ReadMethod that extends the Method class. +: public -: private #: protected Underline: static -language: String ReadMethod Question + ReadMethod() + ReadMethod(input: int, output: String, language: String) + isHard():boolean + specific Way(): String +toString(): String + getLanguage(): String + setLanguage(language: String): voidarrow_forward
- i have attatched my java question , please make sure it is answered correct, include all comments etc, thank youarrow_forwardi have attached my 2 java questions . please answer them correctly, add all comments etc . thank you.arrow_forwardCan you help me solve this problem using Master's Theorem:Solve the recurrence relation f(n) = 3af(n/a) + (n + a)2 with f(1) = 1 and a > 1 byfinding an expression for f(n) in big-Oh notation.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





