CTTS CASE STUDY MILESTONE 5 SOLUTION

This would also be a system-generated number. A character alphanumeric classification of the type of component. Each piece of Equipment is owned by a particular Client. In the present system, the computer name acts as a primary identifier. The real problem with adding purchase orders to CTTS is that it opens the door on accounting functions. Use feedback from your the ERD solution of Milestone 4 as well as the data dictionary provided at the end of this milestone to prepare the new data model. This could be the primary key.

Add to collection s Add to saved. A character alphanumeric field consisting of the first name of the client contact person. This diagram was created in Microsoft Visio. A character alphanumeric field holding the identifying name for the piece of equipment A system-generated numeric value unique to each piece of equipment. Data Model Normalization Page: Each ServiceRequest will be worked on with zero or more WorkRecords initially zero but eventually at least one.

Case Study CTTS – Milestone 05 Data Model

A character alphanumeric field consisting of the first name of the client contact person. A character alphanumeric field holding the first and last name of the person reporting a service request.

A component anything from a stick of RAM to an entire turn-key system that is or has been installed in Equipment. A request for service on Equipment.

  LANCIA THESIS 2.4 JTD SPALANIE

Some, but not all, of the configuration records could be associated with a piece of Equipment. Foreign keys are marked with FK and a number. Would you track accounts payable?

Case Study CTTS – Milestone 05 Data Model

stduy The Equipment entity has EquipNum as the primary key. A character alphanumeric description of the information stored in a software configuration record. A system-generated large integer numeric value unique to each client.

ctts case study milestone 5 solution

Specify all primary and foreign keys. The primary keys are based on how the user uniquely identifies each entity. But make sure each non-key attribute exists in only one entity. Upload document Create flashcards. A Client submits one or more ServiceRequests, which may related to a piece of Equipment. The diagram below includes foreign keys, assuming implementation in a relational database. 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 large alphanumeric field describing the work done on a work record.

Case Study CTTS – Milestone 04 Data Modeling Solution_图文_百度文库

Each Configuration is associated with a particular Client. A 3-character alphanumeric field consisting of the initials of the technician performing work.

ctts case study milestone 5 solution

A date field consisting of the date the piece of equipment was placed in service. A time field holding the time a technician began work on a request. Add this document to collection s. None of the forms hint at a ClientID.

  JENNIFER ROWLEY AND FRANCES SLACK. CONDUCTING A LITERATURE REVIEW

This diagram was created in Microsoft Visio. Vendor would be a parent table to PurchaseOrder, contributing the VendorID in a non-identifying relationship.

ctts case study milestone 5 solution

Add to collection s Add to saved. A character alphanumeric information value stored in a software configuration record. Another alternative is to start with this data model for Milestone 5 but add additional requirements, such as the Milestone stuey Advanced Option and require that students revise milewtone data model accordingly. This would also be a system-generated number. A date field holding the date a service request was reported.

A date field holding the date a service request was resolved. Date field consisting of the date a component was installed into a piece of solktion. An inspection of past forms shows no quantity exceeding This could be the primary key.

Date field consisting of the date a component was removed from a piece of equipment.