Matrix Organization Types of data Org structuretypes of

Matrix Organization – Types of data Org. structure/types of data Reservations and tickets Controller C Office for reservation and ticket purchase C Paper ticket and sms C User profile Structure of trains Timetable of trains U U % of occupation of seats in trains in the last 10 years Marketing office U Pricing and discount campaigns office U Train composition office U C Taxi reservation U Fidelity card office Standard and special trains division U Statistical office U C C means creates & updates the type of data U means uses ther type of data 1

Information Systems 2018 -19 Prof. C. Batini Exercise 3 – Second exercise with reward correspondes to 0. 5 points 2

Starting from requirements (types of data, org. Structures, processes) referred to the railway study case, produce Types of data refer to • Seat reservation and ticket purchase • Paper tickets and sms • User profile • Structure of trains in terms of coaches and seats • Time table of train travels • % of occupation of seats in trains in the last 10 years • Taxi reservation at arrival in a station Organizational structures refer to • Controllers • Office involved in reservation and ticket purchase • Marketing office • Pricing and discount campaigns office • Train composition office • Fidelity card office • Standard and special trains division • Statistical office 1. Entity Relationship Schema For those of you that studied ER before 2. Organizational structures in rows – types of data in columns (C & U) Processes • Ticket control - Control - Fine (multa) • Seat reservation and ticket purhase • Reservation and purchase • Change of reservation • Marketing • Long term marketing • Short term marketing • Pricing • Fidelity card management • Train composition • Standard trains • Special trains • Timetable design and production • Statististics 3