deploying it resources ( mis 533 )

Deploying IT resources(MIS 533)

MBS in Management Information Systems and Managerial Accounting Systems

(2006 / 2007)Fergal Carton

Business Information Systems

MBS (MIMAS) / MIS533 / Deploying IT Resources

Last week• Course outline

• Introductions

• Assessment dates

• Connolly & Begg handout

• DB’s for speed, volume, reduction of error

• It’s 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)

MBS (MIMAS) / MIS533 / Deploying IT Resources

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

MBS (MIMAS) / MIS533 / Deploying IT Resources

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

MBS (MIMAS) / MIS533 / Deploying IT Resources

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

MBS (MIMAS) / MIS533 / Deploying IT Resources

Recommended reading

MBS (MIMAS) / MIS533 / Deploying IT Resources

Recommended reading

MBS (MIMAS) / MIS533 / Deploying IT Resources

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).

MBS (MIMAS) / MIS533 / Deploying IT Resources

Definitons : Analysis & Design

• Analysis : what users need the system to do

• Design : how the system will meet the need

MBS (MIMAS) / MIS533 / Deploying IT Resources

Analysis = listening

MBS (MIMAS) / MIS533 / Deploying IT Resources

Business requirements

MBS (MIMAS) / MIS533 / Deploying IT Resources

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

MBS (MIMAS) / MIS533 / Deploying IT Resources

Use data to test your design

MBS (MIMAS) / MIS533 / Deploying IT Resources

Applications : woodworker

CustomerProductScope

ResourcesInvoice

MBS (MIMAS) / MIS533 / Deploying IT Resources

Applications : IT

MBS (MIMAS) / MIS533 / Deploying IT Resources

Applications : IT

CustomerProductScope

ResourcesInvoice

Plan

Buy

Make

Deliver

Bill and collect

Approve & Pay

Report results

Sell

Install

Maintain

Recruit

Train

Reward

Manufacturing

Finance Sales / CS HR

Market

DevelopBudget

MBS (MIMAS) / MIS533 / Deploying IT Resources

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

MBS (MIMAS) / MIS533 / Deploying IT Resources

Building a model

• Functional decomposition

• Data Flow Diagram– Context diagram

– Processes

– Data Flow

– Data store

– External entities

F in an ce S h ipp ing P la nn ing

S a les

MBS (MIMAS) / MIS533 / Deploying IT Resources

Example : www.RyanAir.com

MBS (MIMAS) / MIS533 / Deploying IT Resources

Functional decomposition

T icke t is su ed

P a ym e nt

R e se rva tion

F lig h t in fo rm a tio n e nq u iry

P a ssen g er

MBS (MIMAS) / MIS533 / Deploying IT Resources

Context diagram

On-line reservation

systemInternet Users

GlobalAirline seat

booking

MBS (MIMAS) / MIS533 / Deploying IT Resources

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)

MBS (MIMAS) / MIS533 / Deploying IT Resources

Data Flow Diagram

Flight

details

Lists options

Confirm price

Book now

Outward

Inward

Makes Reservation& payment

Credit

card

Reservation

Stores

Flight

details