preview

Workshop 8 Questions

Better Essays

300585 - Systems Analysis & Design

Workshop 8
Workshops will run to cover the practical aspects of the topic each week with two workshop case studies that runs across the whole semester and some other examples time to time. The workshop runs in two parts 


Workshop slides
Workshop questions o This document contains two parts o Part A contains two case studies and questions that are to be done in workshop with the help of tutor (to be done in Group of 2 students). Task 1 of this part would always refer to
Willow brook Case study and rest of the tasks may relate to a continuous (UWS Transport
Management System) or some additional case studies o Part B contains questions and tasks related to case studies that individual students need
to …show more content…

The entities are account, customer and transaction
The customer:
• has a name and customer id (the primary key)
• can have one and only one account linked
The account:
• has a balance
• can have zero or more transactions
The transaction:
• has an amount and a date
• can involve only one account
Question
Create an ERD for the UWS Transport Management information system with relationships and cardinalities Part B: Portfolio exercises to be included in Portfolio submissions
Please note that Task1 of Part B is a continuing case study
Task 1
On the Spot Courier Services
As On the Spot Courier Services continues to grow, Bill discovers that he can provide much better services to his customers if he utilizes some of the technology that is currently available.
Bill is now thinking his process flow for his same day delivery system and how it is tracked. The following is his explanation:
This involves use of an RFID device known as sapphire to scan bar code of each shipment at customer site and thereafter download the data stored in the sapphire to the computer server in the office. Consequently, the various means of checking the status of shipment includes web based tracking using a unique bill number and use of mobile SMS where a customer sends an SMS to a particular telephone number and the details of the shipment sent as a reply after few minutes. Telephone

Get Access