Information system in a business
(i) Assuming that you are a consultant on the project team, building a data warehouse for a company of
your choice (use a company as an example), list the possible data sources from which you will bring the data into your data warehouse (visit the company’s website for information and where
make your own assumptions).
(Approx. 100 words)
(ii) Using the company of your choice example from (i) above, explain the benefits that data warehousing implementation will bring in to the company. Within this context, what is the role of data
(iii)Many software vendors such as IBM, Adobe and Microsoft offer Enterprise Content Management (ECM) applications software solution to businesses. Using the Internet, search for two such vendors
and check their ECM solution software products. Write a short summary of your findings.
Your summary should include some general as well as main points on what the products offer to businesses. If there are many such products listed by the two vendors of your choice, simply focus on
one or two such products as you see appropriate. Do not forget to provide references.
(Approx. 100 words)
You may consider setting up a table to evaluate the enterprise application software products of the
two vendors and make the comparison by considering the list of most valuable features in the
products. Question 4
(Approx. 100 words)
Write the lecture summary relating to:
Either Week 2 – Topic: Database Structure Models Or Week 7/8 – Topic: Data Warehouse and Data Mining Or Week 10 – Topic: Information Systems Development
(The purpose of this question is to help students with better focusing in lectures through note taking
and learn to summarise subject contents.) Question 5 (The topics for this question will be covered by week 11/12)
(Approx. 200 words)
(i) Explain the benefits from adopting a structured approach to analysis and design of an information
(ii) What is the purpose of systems design and what fact finding methods and techniques are available to
the systems analyst? Identify the strengths
and weaknesses of each fact finding method you list.
(iii) A systems analyst uses a number of techniques including charts, diagrams etc. to document the
operation of a system being investigated and as
an aid to subsequent analysis and design. Identify and briefly describe those techniques that are most
(Total: 15 marks)
(i, ii & iii – Approx. 300 words)
Question 6 (The topics for this question will be covered by week 11/12)
The policy for admission to a University department dealing with applicants, who may possess Advanced
levels, a part-professional qualification, or both, is as follows:
• applicantswithbothadvancedlevelsandapart-professionalqualificationareeligiblefora professional course or the course their advanced level qualifies them for.
• Courserejectionlettersaresenttoapplicantsfailingtosatisfytheadmissionrequirements. Construct a decision table for the above scenario.
(You may make your own assumptions if necessary.)
Database Implementation (using Access 2010/2016) (The topics for this section including Access 2010 will be covered by week 10)
Using your 3rd normal form tables from exercise 2 under part 1;
(a) Design the database and call it: ‘your full name’. Using MS Access 2010, design the tables obtained from above, and enter the records. Give the tables appropriate names. Use data validation and
input mask at least in two of your tables.)
(b) Create the appropriate relationships between the tables. (c) Design and run two multi table queries of your choice.
(a + b, 9 marks)
(You may also like to check unit ‘K’ “Creating Advanced Queries” on page 261- recommended Access book.)
(Word count is not necessary)
(d) Design and produce a report of your choice with appropriate design enhancement elements. (e) Design a form with appropriate command buttons and any other design enhancement elements.
(f) Construct a form of your choice to include appropriate fields, a sub-form and a calculated field (use own assumptions if necessary).
(g) Additional marks will be awarded for inclusion of lookup, combo box, attachment, as well as the use of macro (or macros) & switchboard as appropriate. (Macros- unit ‘M’, page 313 & Switchboard-
page 336, ‘Creating a Switchboard’ is on page 372- recommended Access book.)
(c+ d+ e+ f+ g, 18 marks) (Total: 27 marks) (Total for Part 2: 70 marks)