CTTS CASE STUDY MILESTONE 5 SOLUTION

CTTS CASE STUDY MILESTONE 5 SOLUTION

An EquipNum is a number that could be generated by the system and stays unchanged forever. A character alphanumeric barcode ID that is either pre-printed on each component package or added via a label at Coastline Consulting. A time field holding the time a technician finished work on a request. If you, the instructor, choose to do your own solution, it may be different, depending on your interpretation of the forms provided. Primary keys are shown at the top of the list of attributes and marked with PK.

Add this document to collection s. A date field consisting of the date the piece of equipment was placed in service. The following diagram illustrates one possible solution. A character alphanumeric postal code of a client. Prepared by Gary B. A time field holding the time a technician finished work on a request.

A date field milestoe the date a component was purchased. Add to collection s Add to saved. A date field consisting of the date the piece of equipment was placed in service.

Case Study CTTS – Milestone 05 Data Model

A date field holding the date a service request was reported. A character alphanumeric identifier of the model number of the component. Clean Technology Investment Programs. Solutoon 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.

  AWEBER BOX FOR THESIS

Specify all primary and foreign keys.

You can add this document to your study collection s Sign in Available only to authorized users. Logical Data Model in 3rd Normal Form: Family Vacation Rentals Machine Milesone i.

A system-generated large integer numeric value unique to each work record. This could be the primary key. A character alphanumeric information value stored in a software configuration record. A system-generated large integer numeric value unique to each service request. None of the forms hint at a ClientID.

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

This is always a whole number. The following diagram illustrates one possible solution. A date field consisting sstudy the date a technician did work on a request.

ctts case study milestone 5 solution

A Client submits one or more ServiceRequests, which may related to a piece of Equipment. Specify all data types your instructor will specify the target database or allowable set of data types. Vendor would be a parent table to PurchaseOrder, contributing the VendorID in a non-identifying relationship.

Some, but not all, of the configuration records could be associated with a piece of Equipment. Each piece of Equipment is a particular EquipmentType.

Case Study CTTS – Milestone 05 Data Model

These two entities could be combined into one entity, but with their different uses, a case can be made for have two entities. If you will be doing Milestone 5 as a separate assignment, you may want to withhold this solution. A component anything from a stick of RAM to an entire turn-key system that is sopution has been installed in Equipment.

  CCEA GCSE HOME ECONOMICS COURSEWORK

ctts case study milestone 5 solution

However, Jeff Summers states that the computer name is sometimes solutioj. Optional Entities A classification of Equipment. Each EquipmentComponent is a particular ComponentType. 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 diagram was created in Microsoft Visio.

This makes a one-to-one relationship. Would you also have payments? A large alphanumeric field describing the work done on a work record. Each piece of Equipment is owned by a particular Client.

ctts case study milestone 5 solution