Political Science

CTTS CASE STUDY MILESTONE 5 SOLUTION

A time field holding the time a technician finished work on a request. The EquipmentComponent entity has ComponentNum as the primary key. Logon Multiple Values of Information i. The following completed matrix is one possible solution. Specify all primary and foreign keys.

You can add this document to your study collection s Sign in Available only to authorized users. For complaints, use another form. None of the forms hint at a ClientID. Logical Data Model in 3rd Normal Form: This makes a one-to-one relationship.

Primary keys are shown at the top of the list of attributes and marked with PK. These two entities could be combined into one entity, but with their different uses, a case can be made for have two entities.

ctts case study milestone 5 solution

A date field consisting of the date a technician did work on a request. If you will be doing Milestone 5 as a separate assignment, you may want to withhold this solution.

Another alternative is to start with this data model for Milestone 5 but add additional requirements, such as the Milestone 4 Advanced Option and require that students revise the data model accordingly. Work done to resolve a SeviceRequest. A system-generated large integer numeric stydy unique to each software configuration record. A classification of EquipmentComponent. This diagram was created in Microsoft Visio. An inspection of past forms shows no quantity exceeding 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.

  HOMEWORK CAFE SUKHUMVIT 31

A character alphanumeric field holding the solutino and last name of the person reporting a service request. Each piece of Equipment is a particular EquipmentType. Primary keys cannot be changed in some systems, and it is never good practice. Each ServiceRequest will be worked on with zero or more WorkRecords initially zero but eventually at least one. Foreign keys are marked with FK and a number.

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

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. None of the forms hint at a ClientID. A numeric ClientID serves better.

Logon Multiple Values of Information i. Add this document to saved. A 3-character alphanumeric field consisting of the initials of the technician performing work.

This is always a whole number. A character alphanumeric field holding the identifying name for the piece of equipment A system-generated numeric value unique to each piece of equipment. You can add this document to your saved list Sign in Available only to authorized users.

  RGUHS DISSERTATION TOPICS 2005

Case Study CTTS – Milestone 05 Data Model

A computer, printer, or other piece of technology equipment that is in use. Specify all primary and foreign keys. A character alphanumeric field identifying the equipment as PC, Printer, Scanner, etc. A time field holding the time a technician began work on a request.

Case Study CTTS – Milestone 05 Data Model

A character alphanumeric classification of the type of component. You can add this document to your study collection s Sign in Available only to authorized users. Date field consisting of the date a component was removed from a piece of equipment. A Client submits one or more ServiceRequests, which may related to a piece of Equipment. Some, but not all, of the configuration records could be associated with a piece of Equipment.

ctts case study milestone 5 solution

A character field holding the name of the vendor from whom a component was purchased.