MGMT Construction is a group of independent general contracting construction companies, with over 4,400 employees in Antigua and Barbuda, Grenada, Trinidad and Tobago, and Jamaica. MGMT Construction has a corporate headquarter in Antigua and Barbuda. The existing system is paper intensive and manual with Architectural drawings and design documents changing daily. Costly delays because of difficulty locating and accessing the documents and other project information could make or break a project. Information on paper forms to track projects might not reach project decision makers until 30-40 days from the time it was recorded. By then, it was too late?decisions were made "from the gut" rather than based on facts.

MGMTCONSTR plans to convert to digital form, or the paper versions are scanned for digital storage. By performing much of the design and planning work on the computer, MGMTCONSTR would expect to identify and resolve issues early in the construction process to help keep projects ahead of schedule and within budget. The new system will also facilitate collaboration among project team members. A secure project-based website can provide realtime storage and management of information in a single shared accessible location.

This Cloud base solution hosts the hardware and software allowing staff working on MGMTCONSTR projects to access the systems at any time and location using mobile devices as well as conventional desktop machines and an Internet connection. The system can also hosts a real-time analytics dashboard to monitor project performance in terms of quality, safety, schedule, and cost. The data are displayed visually as bar graphs or pie charts to construction field staff, project managers, and executives, and colors ranging from red to orange to green display performance ratings.

QUESTION 1

With reference to Work Systems:

a) Using examples from the scenario, categorize the eight(8) elements of the work system and provide examples of these elements [2+8]

b) Identify two (2) elements that are essential to the interaction between the construction company and the businesses and explain one characteristic of the element to support you choice. [5]

QUESTION 2

MGMT Construction has decided to improve their information system so employees across the region could access plans and project document using Cloud technology.

a) Describe the methodology you would use to introduce a new or improved system in the organization. [4]

b) Using the principles of DFDs, identify the elements and cite examples of these from the highlighted scenario. [7]

c) Describe various security measures that should be considered for data privacy and ensure accurate allocations. [4]

QUESTION 3

a) The old system has a number of problems, explain how the new system prevents the problem of data redundancy and data inconsistency. [5]

b) MGMT Construction company kept much of its old records in Excel. One of the spreadsheets had the following columns shown below. In the new database system this data is to be streamlined. What is the name of this process and give the name and fields of the new tables used to store this information in the new system.[10]

Order_ Order_ Part_ Part_ Part_ Supplier_ Supplier_ Supplier_ Supplier_ Supplier_ Number Date Number Name Quantity Number Name Street State Zip