Deploying IT resources MIS 533

1
Deploying IT resources(MIS 533)

• MBS in Management Information Systems and
  Managerial Accounting Systems
• (2006 / 2007)

Fergal Carton Business Information Systems
2
Last week

• Course outline
• Introductions
• Assessment dates
• Connolly Begg handout
• DBs for speed, volume, reduction of error
• Its all about managing customers and suppliers
• SMART Telecom, contacting customers when landline
  suspended?
• SAD methodologies
• Data oriented techniques today
• Importance of
• Reality (moves on) versus system design (once
  only)

3
This week

• Assessment dates (updated)
• Practicals confirm groups and times
• Recommended reading
• Homework database examples
• Analysis design listening
• Use data to test your design
• Applications trade off design vs. cost
• Bad system design
• Modelling

4
Assessment dates (updated)

• A practical exam (20) which will be the
  development of a small database from a business
  scenario
• For example, system to support administration of
  Cork Film Festival
• Scenario to be distributed by 15th Nov 2006
• Assessment during lab practical 7th / 8th Dec
  2006
• An MCQ (20) in class on 28th February 2007

5
Recommended reading

• Database Solutions
• A step by step guide to building databases
• Thomas Connolly Carolyn Begg
• Publisher Addison Wesley
• Concepts of Database Management
• Philip Pratt Joseph Adamski, 4th edition
• Publisher Thomson Course Technology

6
Recommended reading
7
Recommended reading
8
Topics covered

• SAD methodologies
• Infrastructure planning
• Strategic dimension of data management
• Requirements analysis and systems design
• Process modelling
• Data modelling
• Enterprise systems
• Database development (MS Access and Oracle).

9
Definitons Analysis Design

• Analysis what users need the system to do
• Design how the system will meet the need

10
Analysis listening
11
Business requirements
12
What is so difficult about Analysis and Design?

• It involves listening, understanding, documenting
  and clarifying
• It takes time, patience and humility
• It works best within a framework (methodology)
• Design always influenced by experience

13
Use data to test your design
14
Applications woodworker
Customer Product Scope Resources Invoice
15
Applications IT
16
Applications IT
Manufacturing
Finance
Sales / CS
HR
Plan
Bill and collect
Recruit
Market
Buy
Approve Pay
Sell
Train
Make
Report results
Install
Reward
Deliver
Maintain
Develop
Budget
Customer Product Scope Resources Invoice
17
Bad systems design?

• Paper based, supporting foreign character sets
• MPRN going digital with intelligent meters
• ESB Customer supply
• Customer identification when address changes
• Customer identification when mobile no. changes
• Customer identification when they have 2 numbers
  (FT)
• Double booking on airline seats
• Difference between customer requirements and
  order
• Sales reporting by customer Excel
• Pharmacy GMS code gives customer history
  confidentiality

18
Building a model

• Functional decomposition
• Data Flow Diagram
• Context diagram
• Processes
• Data Flow
• Data store
• External entities

19
Example www.RyanAir.com
20
Functional decomposition
21
Context diagram
On-line reservation system
Global Airline seat booking
Internet
Users
22
Example www.RyanAir.com

• Input
• Flight details (eg. SNN-BVA, 8 Oct, 10.35)
• Credit card details (eg. VISA no, Expiry date)
• Process
• Confirms price (eg. EUR 79)
• Makes reservation processes payment
• Output
• Reservation reference (eg.CGHKCA)

23
Data Flow Diagram
Lists options
Book now
Confirm price
Makes Reservation payment
Flight details
Outward Inward
Credit card
Stores Flight details
Reservation