final2004

final2004 - 1.264 Final Exam Fall, 2004 Name: _ Exam...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
1 of 12 1.264 Final Exam Fall, 2004 Name: ______________________________________________ Exam guidelines: 1. 3 hours are allowed to complete the exam. 2. Open notes, open book. 3. No laptop computers or calculators are allowed. You have some arithmetic to do by hand in one question. 4. No cell phones or messaging devices are allowed. Please turn off any that you have brought. 5. Short answer questions: Your answers are limited to a maximum of 2-4 sentences or phrases. Two sentences or phrases are completely adequate to answer any of these questions; 4 sentences are not necessary. Demonstrate that you understand the principles and key points. You will receive full credit for an answer if you make the principal observation(s) that the question is asking for. Details are not necessary.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 of 12 1. Data exchange between supply chain partners (35 points) You wish to exchange shipment notices with a supply chain partner. Each of you sends product to the other, and you have agreed that the contents of a shipment notice are: 1. Transaction: a. Transaction number (unique, generated for this transaction) 2. Shipment level detail (transaction may have multiple shipments): a. Shipper number (unique identifier) b. Receiver number (unique identifier) c. Weight (pounds) d. Cube (cubic feet) e. Date/time shipped f. Carrier number (unique identifier) g. Carrier bill of lading (shipment) number (unique,generated by carrier) 3. Item level detail within shipment: a. Purchase order number (unique, generated by shipper) b. Item ID (unique within a purchase order) c. Quantity d. Measure (item, case, pallet, or container—these are the only choices) a. Draw a data model for these entities and attributes. (10 points) Draw a box for each entity; give each an appropriate name. List the attributes in the box for each entity. Indicate the primary key for each entity by placing the phrase (PK) next to its name. Draw all relationships between the entities in the model. Indicate foreign keys by placing the phrase (FK) next to attributes that are foreign keys. Indicate the cardinality of each relationship: many-many, many-one or one-one. Use crows foot notation; if you use another notation, define it. Do not include tables that would be useful but beyond the scope of the data defined above. For example, do not include a table that gives the shipper name associated with the shipper number.
Background image of page 2
3 of 12 Data model: Shipment PK,FK1 TransactionNbr PK CarrierBillOfLading ShipperNbr ReceiverNbr Weight Cube Date_Time CarrierNbr Item PK,FK2 TransactionNbr PK,FK2 CarrierBillOfLading PK PurchaseOrderNbr PK ItemID Quantity FK1 Measure_Type Measure PK Measure_Type Transaction PK TransactionNbr
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
4 of 12 b. Assume that you are using XML for data transfer. Write out a DTD file that corresponds to your Data Model. This DTD should validate the XML document that will be sent. (10 points) Assume that all fields are mandatory and are parsed character data The DTD must enforce all the business rules contained in your data
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 12

final2004 - 1.264 Final Exam Fall, 2004 Name: _ Exam...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online