3024.S09.HW4 - Management ISE 3024 Data Management for IEs...

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

View Full Document Right Arrow Icon
1 of 4 ISE 3024 Data Managem ISE 3024 Data Management for IEs ent for IEs ent for IEs ent for IEs Thursday, Thursday, Thursday, March 26 March 26 March 26 Spring 2009 Spring 2009 Homework Assignment # Homework Assignment #4 DUE: Thursday, DUE: Thursday, April 2 April 2 April 2 April 2 (at at at start start start of class of class) (18) 1. Consider the following E-R diagram for a machine shop: (a) Apply the rules of Chapter 10 to translate the above into a relational schema. Show each step of the process (i.e., like pp. 79-81, Chapter 10). (b) Present the final relational schema via textual notation (p. 82). (c) What information in the E-R diagram does not appear in your relational schema of part (b)? (d) How is this missing information used in establishing your relational database design? Where do you specify how the information is used? (20) 2. A job shop makes use of a variety of different cutting tools. Each tool is of a certain type and configuration (single cutting point, drill, or multiple cutting teeth). Additionally, a tracking ticket is used to track the location of each tool during use. The shop has asked you to design a tool management database. As
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 04/13/2009 for the course ISE 3204 taught by Professor Staff during the Spring '08 term at Virginia Tech.

Page1 / 4

3024.S09.HW4 - Management ISE 3024 Data Management for IEs...

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