Transcript Course Outline

Deploying IT resources
(MIS 533)
MBS in Management Information Systems and
Managerial Accounting Systems
(2006 / 2007)
Fergal Carton
Business Information Systems
• Course outline
Last week
• 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
Customer
Product
Scope
Resources
Invoice
MBS (MIMAS) / MIS533 / Deploying IT Resources
Applications : IT
MBS (MIMAS) / MIS533 / Deploying IT Resources
Applications : IT
Manufacturing
Finance
Sales / CS
HR
Plan
Bill and collect
Market
Recruit
Buy
Approve & Pay
Sell
Train
Make
Report results
Install
Reward
Deliver
Budget
Maintain
Develop
Customer
Product
Scope
Resources
Invoice
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
Sales
Finance
• Data Flow Diagram
–
–
–
–
–
Context diagram
Processes
Data Flow
Data store
External entities
MBS (MIMAS) / MIS533 / Deploying IT Resources
Shipping
Planning
Example : www.RyanAir.com
MBS (MIMAS) / MIS533 / Deploying IT Resources
Functional decomposition
Passenger
Flight information enquiry
Reservation
Payment
Ticket issued
MBS (MIMAS) / MIS533 / Deploying IT Resources
Context diagram
Global
Airline seat
booking
On-line
reservation
system
Internet
MBS (MIMAS) / MIS533 / Deploying IT Resources
Users
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
Book
now
Flight
details
Lists
options
Outward
Inward
Confirm
price
Credit
card
Makes
Reservation
& payment
Stores
Flight
Reservation
details
MBS (MIMAS) / MIS533 / Deploying IT Resources