230 likes | 356 Views
Deploying IT resources ( MIS 533 ). MBS in Management Information System s and Managerial Accounting Systems (2006 / 2007). Fergal Carton Bu siness Information Systems. Last week. Course o utline Introductions Assessment dates Connolly & Begg h andout
E N D
Deploying IT resources(MIS 533) MBS in Management Information Systems and Managerial Accounting Systems (2006 / 2007) Fergal Carton Business Information Systems
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 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 • Data Flow Diagram • Context diagram • Processes • Data Flow • Data store • External entities MBS (MIMAS) / MIS533 / Deploying IT Resources
Example : www.RyanAir.com MBS (MIMAS) / MIS533 / Deploying IT Resources
Functional decomposition MBS (MIMAS) / MIS533 / Deploying IT Resources
Context diagram Global Airline seat booking On-line reservation system Internet Users 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 Book now Lists options Confirm price Makes Reservation & payment Flight details Outward Inward Credit card Stores Flight details Reservation MBS (MIMAS) / MIS533 / Deploying IT Resources