3024.S10.HW1 - ISE 3024 Data Management for IEs Spring 2010 Homework Assignment#1 DUE Thursday February 4(at start of class(9 Thursday January 28 1

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

View Full Document Right Arrow Icon
ISE 3024 Data Management for IEs Thursday, January 28 Spring 2010 Homework Assignment #1 DUE: Thursday, February 4 (at start of class) (9) 1. Many different things (e.g., type of data) must be considered in developing an effective data management solution. List and briefly describe three things (besides type of data) that should be considered. (10) 2. You have the following list of items in inventory: ITEM LOCATION QUANTITY A S1 14 B S4 28 C S3 15 D S1 30 E S2 5 What do the terms field , data , record type , record , and file correspond to for this list? (9) 3. Consider again the list of inventory items from problem 2. You now have an additional list specifying the corresponding purchasing data as follows: ITEM UNIT COST VENDOR A 5.45 V3 B 1.10 V1 C 6.50 V1 D 9.99 V4 E 4.69 V6 Considering both lists, provide an example of (a) simple record retrieval. (b) a single-file query involving multiple records. (c) a cross-referenced query. (9) 4. (a) What are the two main components of database systems? Briefly defined the role of each component. (b) What is the main difference between the database approach and file-based methods, in terms of how data is modeled and stored? (8)
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.HW1 - ISE 3024 Data Management for IEs Spring 2010 Homework Assignment#1 DUE Thursday February 4(at start of class(9 Thursday January 28 1

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