3024.S10.HW3 - ISE 3024 Data Management for IEs Spring 2010...

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

View Full Document Right Arrow Icon
1 of 3 ISE 3024 Data Management for IEs Thursday, February 18 Spring 2010 Homework Assignment #3 DUE: Thursday, February 25 (at start of class) (23) 1. You are working in a facility that produces make-to-stock items. Each product is made via a series of operations , each at a different machine . The machines are run by workers . Each product is identified by a unique number, and has a 10-character name. Every operation has a different number, as well as a type identifier (e.g., milling operation). Each machine has a number and is in a particular department: the number and department together identify the machine. Every worker is identified by an employee number: the employee’s name (first and last) and a single phone # MUST also be available. Additionally, you find that - each product requires between 1-6 operations: each operation is for a particular product. - each operation is done at a particular machine, which is dedicated to that operation only. Some machines, however, are not used for the current products. - ten workers have been hired to run the machines. Each worker can operate one or more machines. Some machines are fully automated, however, and hence do not require any workers. Develop a conceptual schema for the above scenario. Specify your schema via three tables , like in your notes (Chapter 8, pp. 34-37). (19)
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/22/2010 for the course ISE 3024 taught by Professor Staff during the Spring '08 term at Virginia Tech.

Page1 / 3

3024.S10.HW3 - ISE 3024 Data Management for IEs Spring 2010...

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

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