CTTS CASE STUDY MILESTONE 6 SOLUTION

Students should realize that the Parent-Child relationship found in PurchaseOrder and PurchaseOrderDetail will be present in any invoicing system and many other systems as well. A Client submits one or more ServiceRequests, which may related to a piece of Equipment. Each EquipmentComponent is a particular ComponentType. Primary keys cannot be changed in some systems, and it is never good practice. A request for service on Equipment. A piece of Equipment is made up of one or more EquipmentComponents that either have in the past or are now installed.

The diagram below includes foreign keys, assuming implementation in a relational database. This makes a one-to-one relationship. O For purposes of class discussion, you may want to compare this to the Use Case Diagram created in Milestone 3. Each piece of Equipment is owned by a particular Client. But make sure each non-key attribute exists in only one entity.

Make sure students specify primary keys that uniquely identify the entities as well as use proper names for the keys.

ctts case study milestone 6 solution

The following diagram illustrates one possible solution. Family Vacation Rentals Machine Name i. Because this does not apply to all records, a formal relationship would not have to be established. This would also be a system-generated number. In most activities explanations for why things were done as they were have been provided to aid in your understanding of the solution.

Milestone 06 参考答案_图文_百度文库

The primary keys are based on how the user uniquely identifies each entity. The diagram below includes foreign keys, assuming implementation in a relational database. But a long text field such as the client name would make a poor primary key for Client, consuming extra storage space, slowing down database operations, and probably requiring extra typing.

  ESSAY ON MARU GUJARAT IN GUJARATI LANGUAGE

Foreign keys are marked with FK and soluttion number. In the present system, the computer name acts as a primary identifier. The following completed matrix is one possible solution. Primary keys cannot be changed in some systems, and it is never good practice. This diagram was created in Microsoft Visio. Prepared by Gary B. Activity 5 — Primitive Diagram his model is constructed by following the narrative given in Exhibit 6.

A classification of EquipmentComponent. Each ServiceRequest will be worked on with milestonw or more WorkRecords initially zero but eventually at least one. Activity 2 — Event Decomposition Diagram ften the subsystem division is somewhat arbitrary. Would you track accounts payable? This could be the primary key.

Activity 1 — Context Diagram his diagram is one possible solution based on the meeting transcript in Exhibit 2. The following diagram illustrates one possible solution.

Case study CTTS milestone 06 process modeling – Tài liệu text

A piece of Equipment is made up of one or more EquipmentComponents that either have in the past or are now solufion. A component that has been checked into inventory A piece of information concerning software configuration for the Client and possibly for a piece of equipment. A Client submits one or more ServiceRequests, which may related to a piece of Equipment. A request for service on Equipment. Optional Entities A classification of Equipment.

  THESIS B UNSW EET

Logon Multiple Values of Information i. But make sure each non-key attribute exists in only one entity. If you, the instructor, choose to do your own solution, it may be different, depending on your interpretation of the forms provided.

Case study CTTS milestone 06 process modeling

The Enter New Client event could be placed in either subsystem; presumably the two subsystems will share data so that a client entered in one will atudy available in the other. The EquipmentComponent entity has ComponentNum as the primary key.

ctts case study milestone 6 solution

Activity 3 — Event Diagrams hese diagrams represent one possible implementation of the ten events in the EventResponse List Exhibit 6.

Ensure that the students label the data flows and entities correctly.

BarCode is the primary key for both EquipmentComponent and Inventory.

Author: admin