1) (20) Following is a database for products and sales for a wholesale power equipment company called
PowerSalesco.
Company: PowerSalesCo
Database: SALES
Table 1: PRODUCTS
Product No PName Manufacturer Unit price
ww1 Electric drill Makita 124.95
ww5 Skill saw Philips 231.95
xy6 Screwdriver set Dexter 34.95
bb9 Fire extinguisher Waddell 50.00
Table 2: ORDERS
Customer Name Product No Units Ordered Order Date
McDowell’s ww1 50 18/Jan/18
McDowell’s xy6 125 19/Jan/18
McDowell’s bb9 250 19/Jan/18
Clearmont bb9 500 18/Jan/18
Clearmont ww1 75 19/Jan/18
SuperSave ww1 100 18/Jan/18
SuperSave ww5 56 19/Jan/18
a) (15) From the above database, design formal reports, with appropriate headings, according to the
requirements above. Each report will be on a new page and will contain some data from the above
database in appropriate format.
i) (10) Design the output (including layout and information details) for one (1) operational report*
and one (1) managerial report*.
* In designing your reports focus on the characteristics of the report and the audience you are
servicing. You may make assumptions on any additional data that may provide more meaningful
information – so long as you state your assumptions.
2 | Page
ii) (5) Describe (point form) each of the two types of reports in terms of how the information is used
to support the decisions by each level of management.
b) (5) Assume these reports (from (a) above) are used as input to an executive information system.
Provide examples of the types of decisions made by this level of management. What additional insights
could be derived from this information at this strategic level of reporting? Consider both hard data and
soft data. Explain clearly , using examples, what the specific hard data and soft data would be and how
the data would be used.
2) (11) Now consider you are the business analyst for the HR Department of PowerSalesCo. You have been
asked by the company CEO to review the Recruitment and Hiring process as part of the company’s Human
Resources Information System (HRIS). The following detail process map and modeling diagram using
Business Process Modeling Notation (BPMN) has been developed and documented by a third-party
consultant. The processes include:
a) Advertise for the Position
b) Source and Screen Applicants
c) Hire the New Resource
i) Review all three processes of the Recruitment and Hiring (above) including the Detail Process Map for
Recruiting and Hiring (See Page 4). Utilize the BPMN* template to map the processes as part of your
analysis. Identify the specific tables in the HRIS DBMS that are impacted by the process step. Write a
brief narrative using Business Process Narrative approach and annotate (by underlining) the key
procedures as part of the current As Is process.
* A Business Process Map Notation (BPMN) Organizer