270 likes | 409 Vues
Deploying IT resources ( MIS 533 ). MBS in Management Information System s and Managerial Accounting Systems (2006 / 2007). Fergal Carton Bu siness Information Systems. MIS533 Deploying IT resources. Wednesday 9.00 - 1 1.00 pm, Boole 6 Lecturer : Fergal Carton.
E N D
Deploying IT resources(MIS 533) MBS in Management Information Systems and Managerial Accounting Systems (2006 / 2007) Fergal Carton Business Information Systems
MIS533 Deploying IT resources • Wednesday 9.00 - 11.00 pm, Boole 6 Lecturer : Fergal Carton Name: Fergal Carton Phone: 021-490 3734 Office: Room 2.113, O’Rahilly Building E-mail: f.carton@ucc.ie Web: http://afis.ucc.ie/fcarton/default.htm MBS (MIMAS) / MIS533 / Deploying IT Resources
Course Objective This course deals with planning, developing and managing database environments. It will introduce students to the ways in which database management systems (DBMS) can support the management of data/information. 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
Assessment dates • 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 17th November 2005 • Deadline 8th December 2005 • An MCQ (20%) on the 28th February 2006 MBS (MIMAS) / MIS533 / Deploying IT Resources
Tutorials 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
MIMAS Coffee Session • 11am Wednesday • On second floor open area (block B end) near MBA room MBS (MIMAS) / MIS533 / Deploying IT Resources
This week • Systems Analysis and Design methodologies 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
Understanding requirements • Why do we need information systems? • Reduces possibility of error (eg. same seat not allocated to 2 passengers) • Volume of information (eg. all possible flights and connections) • Speed of transaction (eg. immediate confirmation at point of sale) MBS (MIMAS) / MIS533 / Deploying IT Resources
Background to SA & SD • Output Oriented • Process oriented : DFD’s • Data-Oriented (ERD’s) MBS (MIMAS) / MIS533 / Deploying IT Resources
What’s the best approach? • Failings of these methods • Maintenance • Lack of flexibility • Resilience • Quality • Re-usability of code • Backlog (visible and invisible) MBS (MIMAS) / MIS533 / Deploying IT Resources
What is Systems development Systems development refers to all activities that go into producing an IS solution : • Systems Analysis • Modeling • Design • Implementation • Testing • Maintenance 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
Bad systems design • SNCF : ticketing system • Bank of Ireland on-line (what direct debits are on my account?) • ERP systems: getting reports out • Your own examples? MBS (MIMAS) / MIS533 / Deploying IT Resources
Understanding requirements ... • Analysing problems • Functional decomposition • Process specification • Flow Charts • Use case • Activity diagrams • Designing solutions • Data flow diagrams • Entity relationship model 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