Other Engineering Answers

In computer architecture which different modes are defined such that in a given instruction set architecture how the machine language instructions identify the operand(s) of each instruction. Explain in detail about all of them with suitable examples

Write SQL Queries for following set of tables:

EMPLOYEE (EmpNo, Name, DoB, Address, Gender, Salary, DNumber) ,

DEPARTMENT (DNumber, Dname, ManagerEmpNo, MnagerStartDate).

Write the following queries ( create table and add random data):

i) Display the Age of ‘male’ employees.

ii) Display all employees in Department named ‘Marketing’.

iii) Display the name of highest salary paid ‘female’ employee.

iv) Which employee is oldest manger in company?

v) Display the name of department of the employee ‘SMITH’

Explain the process followed by CPU while completing the interrupts and resuming to instructions with proper steps

Produce a detailed report which could be presented to someone such as a director of the business. The report should include information about IT systems within the company in the context of data flow and general communication. If, when you have completed your investigation, you feel that there are areas where communication is not as effective as it should be, you should produce an improvement plan which can be added to the end of your report.      

Task 4 

You have been asked by your manager to survey the various types of information being passed around the company and between its customers and raw materials suppliers.  

• Write a detailed memo to your manager explaining your thoughts on how information and communications could be improved within the factory.  

Task 3 

In task 1 you were asked to identify three engineering companies. To complete this task, you need to base your research on the company that operates in the secondary sector — that is, the company that designs and manufactures products for sale to customers.  

Select a specific product that is manufactured by your engineering company. Explain how information is passed between the various people responsible for its design, manufacture, sale and continued maintenance. You should support your written findings with suitable block diagrams and company literature such as flow charts.     

Task 2 

Study the scenario and carryout the following tasks 

1. Draw an organisational chart for company A which shows lines of command. Describe the origins of this type of structure. 

1. Construct an organisational chart for company B and describe how it differs from company A. 

1. Describe how the matrix structure for company C would be set up. 

(d) Describe the classification of each company in terms of size and status.

Company B 

Set up three years ago and employing about 80 people, company B has a board of directors and is registered as a private limited company (Ltd). It makes a similar product to company A, is much more reactive to customer demand and has never missed a delivery date even though there have been times when machine tools and other equipment have broken down. The company is organised in a flat structure and produces the same volume of product as company A. 

Company C 

This is a relatively young start-up company owned by three friends and selected by NAMC to collaborate on a new project. Company C’s management has decided to reorganise the research and development, design and manufacturing sections so that the business operates in a matrix structure. 

Middle managers 

Catering, building maintenance, machine shop operation, electroplating, tooling, design office, production control, inspection, goods inwards, despatch, IT services, UK sales, overseas sales, health and safety.  

Other staff 

CAD designers, manufacturing engineers, production schedulers, CNC machining centre technicians, machine operatives, sales engineers, commissioning and maintenance technicians, inspectors, quality auditors, personnel administrators, wages administrators, IT technicians, front-of-house staff, staff trained as first-aiders, plating shop operatives, assembly and test technicians, goods inwards administrators, catering staff, cleaners, staff trained as evacuation wardens in the case of fire or emergency, customer relations. 

Scenario: 

AG Ltd buys hydraulic equipment from three suppliers. Each has a different type of organisational structure and management style. 

Company A 

Set up 30 years ago by the current managing director, company A is still organised in a tall hierarchical structure. It employs approximately 100 people.  

It is well known in the industry for the quality of its products but lately there have been problems with delivering on time and at the last AGM shareholders expressed concern about its profitability. The managing director maintains a very rigid line of command. 

The workforce is made up of directors, senior managers, middle managers and other staff. The job roles within each of these categories are as follows. 

Directors 

Managing, finance, marketing, production, technical, personnel. 

Senior managers 

Purchasing, sales, advertising, finance, personnel, marketing, public relations, research and development, product design, production, maintenance, quality assurance, customer relations.