The primary keys are based on how the user uniquely identifies each entity. Thanks for taking the meeting. A character alphanumeric identifier of the model number of the component. A request for service on Equipment. The diagram below includes foreign keys, assuming implementation in a relational database. It sounds like a lifesaver. You can add this document to your study collection s Sign in Available only to authorized users.
If you buy it as one unit, do you get all the detailed component information and enter it to the columns? We want to keep adding to the list with an installed date and a removed date. A computer, printer, or other piece of technology equipment that is in use. A character alphanumeric field consisting of last name of the client contact person. A component anything from a stick of RAM to an entire turn-key system that is or has been installed in Equipment.
So we need that tracked.
Then we need to track the work a technician does on a request. A character alphanumeric field milextone the first and last name of the person reporting a service request. A character alphanumeric postal code of a client. You requested some samples of the forms we use now out on site.
Case Study CTTS – Milestone 04 Data Modeling
A character alphanumeric identifier of the model number of the component. I think that covers the equipment and component questions.
Foreign keys are marked with FK and a number. You can add this document to your study collection s Sign cse Available only to authorized users. Add this document to collection s.
Case study CTTS milestone 05 data model normalization
Another reason is so on continuing problems we can see what was tried before. A classification of EquipmentComponent. Each Configuration is associated with a particular Client. This makes a one-to-one relationship. This diagram was created in Microsoft Visio. I know what the PC now has. A request for service on Equipment. Add and normalize additional entities and attributes as directed by your instructor.
Then, we will construct a Context Data Model that graphically depicts each of the entities and the relationships they have with each other. The use cases and those forms you brought will be guiding our discussion in this meeting. What about the software configurations?
Case Study CTTS – Milestone 05 Data Model
A PC that we build from individual parts is all components. That leaves the service requests. My opinion is a resolution date field would give us better information in the long run than a resolution checkbox. Today, we may need a column for mouse as we are getting all kinds of specialty mice and other pointing devices on the market. None of the forms hint at a ClientID.
So we need a FinishTime field.
They are all companies with company names. Finally, we refine the keybased data model to include any hierarchies and attributes, and this model is referred to as the Fully Attributed Data Model.
All of the cardinalities of the major entities can be determined from the interview or the forms. For things such as RAM, I need to track a quantity, too.
Case study CTTS milestone 05 data model normalization – Tài liệu text
We let the users name their own machines. An inspection of past forms shows no quantity exceeding Sometimes we buy a complete system with CPU, monitor, mouse, keyboard — the works in one package. An extra second or two to scan the barcode.