A character alphanumeric postal code of a client. But I think 20 characters should be sufficient. This is giving me lots of good information. I know we custom build some PCs. But it isn’t relevant to inventory. The EquipmentComponent entity has ComponentNum as the primary key. As you can see from the spreadsheet, some of our data is pretty sketchy.

Each Configuration is associated with a particular Client. A system-generated large integer numeric value unique to each work record. Upload document Create flashcards. Foreign keys are marked with FK and a number. You can add this document to your study collection s Sign in Available only to authorized users.

A request for service on Equipment. A system-generated large integer numeric value unique to each work record.

Case study CTTS milestone 05 data model normalization – Tài liệu text

For one thing, clients like us to tell them about PCs that are causing problems over and over. I notice this sheet tracks the user. Thanks for taking the meeting. The following diagram illustrates one possible solution.

Case Study CTTS – Milestone 05 Data Model

A system-generated large integer numeric value unique to each client. Make assumptions where necessary. Logon Multiple Values of Information i.

case study ctts milestone 4 solution

That was to see if a particular drive was still under warranty. Some, but not all, of the configuration records could be associated with a piece of Equipment. But make sure each non-key attribute exists in only one entity. No, because if we bought it as a unit we let the vendor service it as a unit under warranty.


A character alphanumeric field holding the identifying name for the piece of equipment A system-generated numeric value unique to each piece of equipment. This system is about client service requests and client equipment dtudy client configurations. Suggest us how to improve StudyLib For complaints, use another form.

When I was talking to Ben and Doug about it the other week, they thought we could use barcodes to speed the entry process and tie the information back to when we check it into inventory. Whether or not they identify the optional entities will depend on how they interpret the user requirements and on their experience level with database normalization.

Upload document Create flashcards. Each piece of Equipment is owned by a particular Client. Every barcode symbol is associated with a numeric or alpha-numeric identifier. Are these columns all the pieces of information that need to be tracked for each PC?

The Equipment entity has EquipNum as the primary key.

case study ctts milestone 4 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 component that has been cttd into inventory A piece of information concerning software configuration for the Client and zolution for a piece of equipment.


A barcode would tie each entry to a specify model number. A character field holding the name of the vendor from whom a component was purchased. I would say we should have all that data handy in the system.

Case Study CTTS – Milestone 04 Data Modeling

How long are those identifiers? You can add this document to your saved list Sign in Available only to authorized users. I think that covers the equipment and component questions.

case study ctts milestone 4 solution

The meeting room at Coastline Systems Consulting. A piece of Equipment is made up of one or more EquipmentComponents that either have in the past or are now installed.

Your instructor will specify additional system requirements for this part of the system. Earlier we had talked about a mechanism for marking requests as resolved. Add this document to saved. From a component standpoint, I just need to see a list of all components that have ever been in the PC, when those components were added, and when they were removed.