Homework Assignment 4 It 214

Only available on StudyMode
  • Download(s) : 308
  • Published : December 20, 2012
Open Document
Text Preview
HOMEWORK ASSIGNMENT 4
IT 214

Assigned Problems:
 
Chapter 5 (p. 185 – 189):

• Problems 1 - 4

• Problems 15 - 17

Note: you are required to use MS Visio for all the problems

Submission Instructions:

• Answering a question, please use complete sentences
• Please type your answers into this document (see next page), save the file and print it out • Submit your completed assignment file to Blackboard AND turn in a hard copy in class before the lecture begins • Homework assignments will be accepted up to 48 hours past the time it was due for 80% credit. After that time, late homework will not be accepted.    

IT 214, Section: 002
Name: Faisal Ehsan

IT 214
Homework Assignment 4

Chapter 5:

1. Using the INVOICE table structure shown in Table P5.1, write the relational schema, draw its dependency diagram and identify all dependencies (including all partial and transitive dependencies). You can assume that the table does not contain repeating groups and that any invoice number may reference more than one product. (Hint: This table uses a composite primary key.)

1NF (INV_NUM, PROD_NUM, SALE_DATE, PROD_LABEL, VEND_CODE, VEND_NAME, QUANT_SOLD, PROD_PRICE)

PARTIAL DEPENDENCIES:
(INV_NUM SALE_DATE, QUANT_SOLD)
(PROD_NUM PROD_LABEL, VEND_CODE, VEND_NAME, PROD_PRICE)

TRANSITIVE DEPENDENCIES:
(VEND_CODE VEND_NAME)
[pic]

Table P5.1 Sample INVOICE Records
|Attribute Name |Sample Value |Sample Value |Sample Value | |MEMBER_NUM |214 |235 |214 | |MEMBER_NAME |Alice B. VanderVoort |Gerald M. Gallega |Alice B. VanderVoort | |MEMBER_ADDRESS |325 Meadow Park...
tracking img