Laura Moore has recently left her job as a Graphic Designer to open her own Company; a Graphic Design Agency dedicated to the creation and design of apps for mobile devices. Laura has decided to be self-employed.

To do so, she will have her business premises, which belongs to her father, in downtown Barcelona and she will have to hire:

• A visual designer
• A developer
• An administrative assistant

1. To hire the administrative assistant, Marta has decided to offer an indefinite contract. She is her first employee that Marta will hire and she has a recognized degree of disability of 37%. Explain to Marta what bonuses and reductions could be applied in the hiring of the administrative and what type of contract should she carry out, exposing its main characteristics. You must prepare the work contract of the Administrative Assistant according to the appropriate official model.

Once the contract has been drafted and completed according to Spanish regulations, you must specify in detail the differences it would have had it been made according to the regulations of the United Kingdom.

2. Knowing the salaries agreed upon with each of the two workers, prepare the payroll for each of them. Make sure you detail the steps you have taken and the financial nature of each of the items involved:

a. Administrative Assistant. Three months seniority. She has an indefinite work contract, base salary: € 1,500. Collective bargaining: € 50.

She has two extraordinary six-month accrual pays and receives them on 06/30 and 12/31 of each year for an amount equal to the base salary. She has a disability of 37% and is single without children. She has made two overtime hours that month at a rate of € 15/h.

b. Visual designer. 2 months seniority. He has a temporary contract.

Base salary: € 1,950. Collective bargaining: € 100. Productivity: € 6 / day. He has two extraordinary six-month accrual payments and receives them apportioned each month. He is married and has a 9-year-old son (his spouse receives an income of over € 1,500/year).

Once you have developed all the steps to follow in each case and the amount of the items, design and present the official payroll of the administrative assistant.

Laura Moore has recently left her job as a Graphic Designer to open her own Company; a Graphic Design Agency dedicated to the creation and design of apps for mobile devices. Laura has decided to be self-employed. To do so, she will have her business premises, which belongs to her father, in downtown Barcelona and she will have to hire: A visual designer A developer An administrative assistant 1. To hire the administrative assistant, Marta has decided to offer an indefinite contract. She is her first employee that Marta will hire and she has a recognized degree of disability of 37%. Explain to Marta what bonuses and reductions could be applied in the hiring of the administrative and what type of contract should she carry out, exposing its main characteristics. You must prepare the work contract of the Administrative Assistant according to the appropriate official model. Once the contract has been drafted and completed according to Spanish regulations, you must specify in detail the differences it would have had it been made according to the regulations of the United Kingdom. 2. Knowing the

salaries agreed upon with each of the two workers, prepare the payroll for each of them. Make sure you detail the steps you have taken and the financial nature of each of the items involved: a. Administrative Assistant. Three months seniority. She has an indefinite work contract, base salary: € 1,500. Collective bargaining: € 50. She has two extraordinary six-month accrual pays and receives them on 06/30 and 12/31 of each year for an amount equal to the base salary. She has a disability of 37% and is single without children. She has made two overtime hours that month at a rate of € 15/h. b. Visual designer. 2 months seniority. He has a temporary contract. Base salary: € 1,950. Collective bargaining: € 100. Productivity: € 6 / day. He has two extraordinary six-month accrual payments and receives them apportioned each month. He is married and has a 9-year-old son (his spouse receives an income of over € 1,500/year). Once you have developed all the steps to follow in each case and the amount of the items, design and present the official payroll of the administrative assistant.

In response to question 4.2 from the textbook, demonstrate your understanding of the differences in the design, applications, and usage of the relational database as compared to the use of spreadsheets.

Question 4.2 Most DBMS packages contain data definition, data manipulation, and data query languages. For each of the following, indicate which language would be used and why. A database administrator defines the logical structure of the database. The controller requests a cost accounting report containing a list of all employees being paid for more than 10 hours of overtime in a given week. A programmer develops a program to update the fixed-assets records stored in the database. The human resources manager requests a report noting all employees who are retiring within five years. The inventory serial number field is extended in the inventory records to allow for recognition of additional inventory items with serial numbers containing more than 10 digits. A user develops a program to print out all purchases made during the past two weeks. An additional field is added to the fixed-asset records to record the estimated salvage value of each asset.

16. A developer of video game software has seven proposals for new games. Unfortunately,
the company cannot develop all the proposals because its budget for new projects
is limited to $950,000, and it has only 20 programmers to assign to new projects.
The financial requirements, returns, and the number of programmers required by each project are summarized in the following table. Projects 2 and 6 require specialized
programming knowledge that only one of the programmers has. Both of these
projects cannot be selected because the programmer with the necessary skills can be
assigned to only one of the projects. (Note: All dollar amounts represent thousands.)
Project Programmers Required Capital Required Estimated NPV
1 7 $250 $650
2 6 $175 $550
3 9 $300 $600
4 5 $150 $450
5 6 $145 $375
6 4 $160 $525
7 8 $325 $750
a. Formulate an ILP model for this problem.
b. Create a spreadsheet model for this problem and solve it.
c. What is the optimal solution?

In parallel computing, what is the meaning of “skew”?

Select one:

a. The number of operations in one of the parallel processors starts increasing exponentially.

b. In the distribution of work among the processors, some processors are getting a larger number of tuples than others.

c. One of the parallel processors overheats and in a chain reaction the same happens to all other processors.

d. One parallel processor runs hotter than the others.

e. The number of operations rises beyond reasonable limits.

What operation is responsible for the retrieval of information from a database in a transaction schedule?

Select one:

a. Get

b. Pull

c. See

d. Read

e. Retrieve

Logical, physical and view levels are elements of the model of…

Select one:

a. Entity Relationship (ER)

b. Data Abstraction

c. Domain Model Language (DML)

d. Domain Object Model (DOM)

e. Backup and Recovery

Which of the following is NOT commonly understood as a type of database user?

Select one:

a. Naïve user

b. Sophisticated user

c. Specialized user

d. Native user

e. Application programmer

Topic 1

TRUE OR FALSE Q's

1.            Computer software is the collection of programs that provide the instructions that a computer carries out.

2.            An abstraction is a mental model that removes or hides complex details.

3.            The abacus was the world's first electronic digital computer.

4.            Ada Augusta, Countess of Lovelace, is credited with being the first programmer.

5.            A vacuum tube was a device used in the third generation of computers.

6.            The fourth generation of computer hardware was characterized by large-scale integration.

7.            The personal computer was introduced in the fourth generation of computer hardware.

8.            The Internet is descended from a U.S. government-sponsored network called the ARPANET.

9.            Assembly-language is first generation software.

10.          Earliest machine programs were hard wired.

11.          Algorithmic thinking is a necessary skill in Computer Science.

12.          Computational Science is one of the Systems areas.

13.          Spreadsheets and word processors are known as software applications.

14.          Applications programmers use the tools built by systems programmers.

15.          An algorithm is a set of steps that defines how a task is performed.

Write a Visual C# project that will allow the user an option to choose from four different countries. When a country is chosen, the program will display the country flag and information that the user wishes to see. The name of the country selected will be displayed in a label under the country's flag image. The user may also choose to display or hide the form's title, the country name, and the name of the programmer/developer.   Check boxes will be used for the display/hide choices. Radio buttons will be used for the country selection.

You may choose the countries to display and their corresponding flags to display. In the Canvas module, you will see a zip file of flag images or you may choose your own.

Note: see the Note from the previous projects. These are now considered Basic Expectations and are expected in each program you develop and submit for grading.

Additionally, include keyboard access keys for all option buttons, check boxes, and command buttons. (add to Basic Expectations)
Be sure the tab order is set in the most logical order for the user.   (add to Basic Expectations)

The ( ) method will be called if a method is called from within a subclass that overrides a super class method.

In Java the (          ) keyword is used to prevent changes being made to a variable.

The property of ( ) refers to the ability of an object to take on many forms.

In Java, a character constant’s value is its integer value in the ( ) character set.

An interface requires each of the interface’s methods to be ( ) or declared abstract.

The (    ) statement forces an exception object to be generated.

Through the process of (    ) , a programmer hides all but the relevant data about an object in order to reduce complexity and increase efficiency.

Re-implementing an inherited method in a subclass to perform a different task from the parent class is called (    ) .

In a class definition, the special method that is called to create an instance of that class is known as a/an ( ) .

In Java, objects are passed as ( ) addresses.

List of words to choose from

Double, literal, overriding, bytecode, implemented, polymorphism, subclass, catch, protected, throws, constructor, interface, unicode, inheritance, int, overloading, memory, class, string, private, throw, main, extends, final, string literal, runtime, abstraction, prublic, jvm

A computer operator at the local data processing center decides to visit work on a Monday evening. She has a key to the outside door, and since there is no key required for the computer room, she simply walks into the computer room. The operator, who is really one of the nation’s most notorious computer programmer/hackers (having been convicted five time for manipulating various firms’ data files), opens the documentation bookcase, located in the corner of the computer room. In the bookcase she finds the procedural documentation, the systems documentation, user manuals, application documentation, and operator manuals. She examines the documentation to understand the payroll program and to find the location of the payroll files. She accesses the information systems library, which is available to all computer operators at all times, accesses the payroll program, reprograms it, and runs a payroll job that creates one electronic funds transfer (to a new account opened by the operator under an assumed name). On Tuesday, the operator transfers the funds to a Swiss bank account and does not show up for work.

        Required

Prepare a summary that details any internal controls violated in this situation.