1: Business process questions

Choose one information system.

(a) For that system, describe the business processes that the system undertook to convert input to output. Break down the business process in your information system into 5-10 smaller processes. For every process, please clearly indicate who does what and why,

(b) For every process, please clearly explain what kind of hardware, software, or network is involved.

(c) Please evaluate the business processes: is it possible to remove or add one or more business processes in order to create greater business value?

2: IT governance and privacy

Please answer the following questions:

1. What is PIPEDA?
2. How does PIPEDA restrict the use of personal information by organizations?
3. Can an individual sue an organization because of PIPEDA? What role does the privacy commissioner have with PIPEDA?

3: An Access mini project

Case:

Suppose you are a marketing assistant for a consumer electronics company and are in charge of setting up your company’s booth at tradeshows. Weeks before the shows, you meet with the marketing managers and determine what equipment they want to display. Then, you identify each of the components that need to be shipped and schedule a shipper to deliver them to the trade-show site. You then supervise convention personnel as they set up the booths and equipment. Once the show is over, you supervise the packing of the booth and all equipment, and schedule its shipment back to your home office. Once the equipment arrives, you check it into your warehouse to ensure that all pieces of the booth and all equipment are returned. If there are problems because of shipping damage or loss, you handle those problems. Your job is important; at a typical show you are responsible for more than a $250,000 worth of equipment.

You will need to track data about booth components, equipment, shippers, and shipments. Please design a relational database (Access) which includes appropriate tables, queries, forms and reports.

1. Resources: Access is a part of Microsoft Office software; Access is also available in the IT lab in the building of Business. Access tutorial materials are available on D2L course website.

Please submit an Access database including tables, relationships, and forms showing the inventory of booths and equipment, and ordering and shipping information. Please populate tables with some data.

1. Please answer the following questions:
2. Could you use an Excel spreadsheet to keep track of this data? What would be the advantages and disadvantages of using a database vs. using spreadsheets?