Where do you stop? Each EquipmentComponent is a particular ComponentType. Add this document to collection s. Winning Table Topics – Toastmasters District Are these columns all the pieces of information that need to be tracked for each PC? Prepared by Gary B.

I’ve never worked with barcodes in an information system. This makes a one-to-one relationship. But if you mean make sure it is operational and handle sending it in for warranty work, then yes. You requested some samples of the forms we use now out on site. The following completed matrix is one possible solution. Each piece of equipment is given a name.

Case Study CTTS – Milestone 05 Data Model

I know we custom build some PCs. If you buy it as one unit, do you get all the milsetone component information and enter it to the columns? A time field holding the time a technician finished work on a request. The use cases and those forms you brought will be guiding our discussion in this meeting. Your e-mail Input it if you want to receive answer.

case study ctts milestone 4 solution

But still worth it in the long run. Solutiln which attributes are required not nullable. We could generate a whole list of unique numbers and print barcode labels for them.

case study ctts milestone 4 solution

You can add this document to your saved list Sign in Available only to authorized users. And we always have a primary contact person. The primary keys are based on how the user uniquely identifies each entity. With each entity we identify, we will define it in respect to the business. 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.


Sounds like more work.

But I think 20 characters should be sufficient. Upload document Create flashcards.

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

Thanks for taking the meeting. Why do we use different scales. The results of this activity will identify the business data requirements for the proposed system. Not unless you count sticky notes and e-mails. Are these columns all the pieces of information that need to soltuion tracked for each PC? But then we would end up with imlestone equivalent of this spreadsheet filled with identifiers. We would tie every installed component to a specific purchase date with the barcode.

Date field consisting of the date a component was installed into a piece of equipment. Can’t you just view all that information on the router once you login? The identifier is printed just above or below the barcode symbol, so you can actually see what it is. I know sgudy the PC now has. Winning Table Topics – Toastmasters District Add the data attributes for each entity. Another alternative is to start with this sthdy model for Milestone 5 but add additional requirements, such as the Milestone 4 Advanced Option and require that students revise the data model accordingly.


Kathy, how do you check in inventory now? I would say we should have all that data handy in the system. Add this document to saved.

Case Study CTTS – Milestone 04 Data Modeling

A character alphanumeric description of the piece of equipment, if any, for a software configuration record. BarCode is the primary key for both EquipmentComponent and Inventory. Vendor would be a parent table to PurchaseOrder, contributing the VendorID in a non-identifying relationship.

case study ctts milestone 4 solution

The real problem with adding purchase orders to CTTS is that it opens the door on accounting functions.