Introduction to information system

1. (10 marks)
Read the description below and arrange the data accordin” rel=”nofollow”>ing to relational database concepts .
Durin” rel=”nofollow”>ing the week, there are three Flights, and three Pilots. Flight Number 6242 departs Toronto at 8:00 AM, and Arrives in” rel=”nofollow”>in Vancouver at 9:00 AM. Flight 6289 Leaves Win” rel=”nofollow”>innipeg at 7:55AM, and Arrives in” rel=”nofollow”>in Regin” rel=”nofollow”>ina at 8:40AM, and Flight 6254 Leaves Calgary at 8:00AM, and Arrives in” rel=”nofollow”>in Kelowna at 9:15AM.

John Johnson (Born May 1st, 1975) is a pilot with 10 Years of Experience, who has been assigned the Flight from Toronto to Vancouver on September 5, 2016. Janice Chow (Born July 18th, 1977) is a pilot with 8 years of experience who will pilot the plane from Win” rel=”nofollow”>innipeg to Regin” rel=”nofollow”>ina on September 6, 2016, and Fiorella Chielin” rel=”nofollow”>ini (Born November 3rd, 1980) has 3 2 years of experience, and was the captain” rel=”nofollow”>in of flight 6254 on September 7, 2016.

2. (10 marks)

A Management Information System can be viewed as a jigsaw puzzle of in” rel=”nofollow”>integrated parts. Explain” rel=”nofollow”>in in” rel=”nofollow”>in words and diagrams what the parts are and how they fit together.

3. (10 marks)

Usin” rel=”nofollow”>ing as reference Porters Value Chain” rel=”nofollow”>in, answer the followin” rel=”nofollow”>ing questions.

a) (3) Discuss and contrast the MIS used to support Primary and Secondary Activities.
b) (3) Describe the relationship between SCM and CRM and how do they help create Competitive Advantage. c) (4) Give two advantages and two disadvantages of busin” rel=”nofollow”>inesses alignin” rel=”nofollow”>ing their processes to their selected ERP system.

4. (10 marks)

ERP implementations are fraught with risk, discuss and show through examples some of the benefits brought to organizations that have implemented ERP systems. Use external resources to answer this question and in” rel=”nofollow”>include references.

5. (10 marks)

An oil pipelin” rel=”nofollow”>ine is bein” rel=”nofollow”>ing planned for construction along a route between two major Canadian cities. An assessment is needed by the provin” rel=”nofollow”>ince to determin” rel=”nofollow”>ine if the pipelin” rel=”nofollow”>ine is at risk of negatively impactin” rel=”nofollow”>ing the ecosystem through which it goin” rel=”nofollow”>ing to be constructed. This assessment will determin” rel=”nofollow”>ine if the Provin” rel=”nofollow”>ince will allow the project to go ahead.

Describe how a Geographical Information System might help with the decision makin” rel=”nofollow”>ing process.

find the cost of your paper