1 / 29

Database development ( MIS 533 )

Database development ( MIS 533 ). MBS in Management Information System s and Managerial Accounting Systems (2007 / 2008). Fergal Carton Bu siness Information Systems. MIS533 Database development. Wednesday 9.00 - 1 1.00 pm, Aras na Laoi 9 Lecturer : Fergal Carton.

breena
Download Presentation

Database development ( MIS 533 )

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database development(MIS 533) MBS in Management Information Systems and Managerial Accounting Systems (2007 / 2008) Fergal Carton Business Information Systems

  2. MIS533 Database development • Wednesday 9.00 - 11.00 pm, Aras na Laoi 9Lecturer : 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 / Database development

  3. 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 business process and management information requirements. MBS (MIMAS) / MIS533 / Database development

  4. Topics covered • Systems Analysis and Design methodologies • Requirements analysis • Process modelling (DFD’s) • Data modelling (ERD’s and normalisation) • SQL and database systems (Data Warehousing) • Single instance database systems • Database development (Access and Oracle) MBS (MIMAS) / MIS533 / Database development

  5. Assessment dates • A practical exam (20%) which will be the development of a database system: • Eg. system to support playlist generation • Scenario to be distributed by mid November • Deadline December • An Oracle and SQL assessment (20%) will take place during lab practical hours in the 2nd term. MBS (MIMAS) / MIS533 / Database development

  6. Tutorials in B.04 • Wednesdays 12.00 - 13.00 • Thursdays 11.00 – 12.00 • Database development • Access (1st term) • Oracle and SQL (2nd term) • SQL Server admin (2nd term) • Tutors: • James Northridge • Jessica Doyle NB: tutorial on Weds 17th Oct at 12.00 will be replaced by a placement preparation workshop (Maire Kavanagh) MBS (MIMAS) / MIS533 / Database development

  7. Database manuals • Available within next 2 weeks • 2007 price was €15 • Katie Dineen to distribute MBS (MIMAS) / MIS533 / Database development

  8. 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 / Database development

  9. Recommended reading MBS (MIMAS) / MIS533 / Database development

  10. Recommended reading MBS (MIMAS) / MIS533 / Database development

  11. This week • Why do we need databases? • Systems Analysis and Design methodologies MBS (MIMAS) / MIS533 / Database development

  12. Why do we need databases? • Reduces possibility of error • Volume of information • Speed of transaction processing MBS (MIMAS) / MIS533 / Database development

  13. 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 / Database development

  14. Definitons : Analysis & Design • Analysis : what users need the system to do • Design : how the system will meet the need MBS (MIMAS) / MIS533 / Database development

  15. Analysis = listening MBS (MIMAS) / MIS533 / Database development

  16. Business requirements MBS (MIMAS) / MIS533 / Database development

  17. Background to SA & SD • Output Oriented • Process oriented : DFD’s • Data-Oriented (ERD’s) MBS (MIMAS) / MIS533 / Database development

  18. 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 / Database development

  19. Your own examples MBS (MIMAS) / MIS533 / Database development

  20. 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 / Database development

  21. 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 / Database development

  22. 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 / Database development

  23. 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 / Database development

  24. Building a model • Functional decomposition • Data Flow Diagram • Context diagram • Processes • Data Flow • Data store • External entities MBS (MIMAS) / MIS533 / Database development

  25. Example : www.RyanAir.com MBS (MIMAS) / MIS533 / Database development

  26. Functional decomposition MBS (MIMAS) / MIS533 / Database development

  27. Context diagram Global Airline seat booking On-line reservation system Internet Users MBS (MIMAS) / MIS533 / Database development

  28. 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 / Database development

  29. 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 / Database development

More Related