Scope Definition Solution Page: Configuration information will be very flexible to handle all the kinds of information that needs to be tracked. Some, but not all, of the configuration records could be associated with a piece of Equipment. Would allow technicians to see what other technicians had done. The service request part of the system should be online. The students should try to identify the causes and effects of the problems identified in Milestone 1. All of the cardinalities of the major entities can be determined from the interview or the forms.
Subject to interpretation, this diagram is in third normal form, which is the bulk of the assignment for Milestone 5. Would lead to better customer satisfaction. A numeric ClientID serves better. The proposed system could provide a customer history that would allow for better service. A piece of Equipment is made up of one or more EquipmentComponents that either have in the past or are now installed. The form that follows illustrates one possible solution.
Causes and Effects Receptionist takes calls and route to technicians with phone transfer or e-mail. Optional Entities A classification of Equipment. Problem Statement Matrix Students should try to identify problems and also opportunities that were mentioned in the narrative. None of the forms hint at a ClientID. The current system does not accurately track configuration information, leading to wasted time for technicians and clients. A computer, printer, or other milesttone of technology equipment that is in use.
A Client submits one or more ServiceRequests, which may related to a piece of Equipment. Each piece of Equipment is a particular EquipmentType.
Case study CTTS milestone 09 application architecture
All of the cardinalities of the major entities can be determined from the interview or the forms. A request for service on Equipment. One approach could be the use of barcode scanning. Would you track accounts payable? A component anything from a stick of RAM to an entire turn-key system that is or has been installed in Equipment. System would allow technicians to record notes on work done on service requests.
Primary keys are shown at the top of the list of attributes and marked with PK. ctgs
Systems Analysis & Design Methods, 7e
Some, but not all, of the configuration records could be associated with a piece of Equipment. Each EquipmentComponent is a particular ComponentType. Each piece of Equipment is owned by a particular Client.
Work done to resolve a SeviceRequest. This diagram was created in Microsoft Visio. Clients, technicians, and management should be able to view unresolved service requests and the history of work performed on them.
If you, the instructor, choose to do your own solution, it may be cawe, depending on your interpretation of the forms provided. The system should allow technicians to view and edit software configuration information in the field. Visio cannot easily produce a Context Diagram exactly like the one shown in chapter 5. The following diagram illustrates one possible solution. Evaluate their thought processes.
If not online, then need to replicate data between master and copy. BarCode is the primary key for both EquipmentComponent and Inventory.
Would lead to better customer satisfaction. But make sure each non-key attribute exists in only one entity. Students should be able to defend their answers with specific statements from the case study exhibits.
Technicians going out to handle the service calls often face incomplete information. The sample RSS provided here represents a general description. In the present system, the computer name acts as a primary identifier.
The Equipment entity has EquipNum as the primary key.