None of the forms hint at a ClientID. For complaints, use another form. Each piece of Equipment is a particular EquipmentType. Would you also have payments? The following tables contain the attributes identified from each form and the interview. Work done to resolve a SeviceRequest. Prepared by Gary B.
KS1 skills web SPR A date field holding the date a service request was reported. A date field consisting of the date a technician did work on a request. Logon Multiple Values of Information i. The following diagram illustrates one possible solution. This would also be a system-generated number.
An inspection of past forms shows no quantity exceeding A character alphanumeric field consisting of last name of the client contact person.
Case Study CTTS – Milestone 05 Data Model
A character alphanumeric identifier of the model number of the component. The real problem with adding purchase orders to CTTS is that it opens the door on accounting functions.
Clean Technology Investment Programs. The Equipment entity has EquipNum as the primary key.
Case Study CTTS – Milestone 04 Data Modeling Solution_图文_百度文库
A date field holding the date a service request was resolved. If you will be doing Milestone 5 as a separate assignment, you may want to withhold this solution. However, Jeff Summers states that the computer sooution is sometimes changed.
All of the cardinalities of the major entities can be determined from the interview or the forms. Make assumptions where necessary. A character field holding the name of the vendor from whom a component was purchased. A character alphanumeric description of the piece of equipment, mliestone any, for a software configuration record.
You can add this document to your saved list Sign in Available only to authorized users. Milestkne Model Normalization Page: A character description of the component. Subject to interpretation, this diagram is in third normal form, which is the bulk of the assignment for Milestone 5.
This is always a whole number. 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. A date field holding the date a service request was reported. Some, but not all, of the configuration records could be associated with a piece of Equipment.
Each piece of Equipment is owned by a particular Client. Logon Multiple Values of Information i. Specify all primary and foreign keys.
A classification of EquipmentComponent. BarCode is the primary key for both EquipmentComponent and Inventory. You can add this document to your study collection s Sign in Available only to authorized users.
The following tables contain the attributes identified from each form and the interview.
A character alphanumeric postal code of a client. In the present system, the computer name acts as a primary identifier.
A date field consisting of the date the piece of equipment was placed in service. Each ServiceRequest will be worked on with zero or more WorkRecords initially zero but eventually at least one. Prepared by Gary B.
Date field consisting of the date a component was removed from a piece of equipment. A large alphanumeric field describing the work done on a work vtts. A Client submits one or more ServiceRequests, which may related to a piece of Equipment.