Transcript Course Outline

Database development
(MIS 533)
MBS in Management Information Systems and
Managerial Accounting Systems
(2007 / 2008)
Fergal Carton
Business Information Systems
MIS533 Database development
• Wednesday 9.00 - 11.00 pm, Aras na Laoi 9
Lecturer : Fergal Carton
Name:
Phone:
Office:
E-mail:
Web:
Fergal Carton
021-490 3734
Room 2.113, O’Rahilly Building
[email protected]
http://afis.ucc.ie/fcarton/default.htm
MBS (MIMAS) / MIS533 / Database development
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
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
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
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
Database manuals
• Available within next 2 weeks
• 2007 price was €15
• Katie Dineen to distribute
MBS (MIMAS) / MIS533 / Database development
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
Recommended reading
MBS (MIMAS) / MIS533 / Database development
Recommended reading
MBS (MIMAS) / MIS533 / Database development
This week
• Why do we need databases?
• Systems Analysis and Design
methodologies
MBS (MIMAS) / MIS533 / Database development
Why do we need databases?
• Reduces possibility of error
• Volume of information
• Speed of transaction processing
MBS (MIMAS) / MIS533 / Database development
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
Definitons : Analysis & Design
• Analysis : what users need the system to do
• Design : how the system will meet the need
MBS (MIMAS) / MIS533 / Database development
Analysis = listening
MBS (MIMAS) / MIS533 / Database development
Business requirements
MBS (MIMAS) / MIS533 / Database development
Background to SA & SD
• Output Oriented
• Process oriented : DFD’s
• Data-Oriented (ERD’s)
MBS (MIMAS) / MIS533 / Database development
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
Your own examples
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
Student name
Horgan, Shane Christopher
Dillon, Damien
Creighton, Glenn
Kenny, Clive
Crowley, Micheal
Hourigan, Brenda
Kavanagh, Fiona Marie Claire
Kearney, Tara
Holland, Tadhg
REYHANI, PEYMAN
11
12
FONZI, Kenneth Christopher
LI, Yan
System experience
Dunnes Stores, Tesco?
Quality control, food mfg
MBS (MIMAS) / MIS533 / Database development
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
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
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
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
Building a model
• Functional decomposition
Sales
Finance
• Data Flow Diagram
–
–
–
–
–
Context diagram
Processes
Data Flow
Data store
External entities
MBS (MIMAS) / MIS533 / Database development
Shipping
Planning
Example : www.RyanAir.com
MBS (MIMAS) / MIS533 / Database development
Functional decomposition
Passenger
Flight information enquiry
Reservation
Payment
Ticket issued
MBS (MIMAS) / MIS533 / Database development
Context diagram
Global
Airline seat
booking
On-line
reservation
system
Internet
MBS (MIMAS) / MIS533 / Database development
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 / Database development
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 / Database development