Homework Assignment 4 It 214

Topics: Relational model, SQL, Database normalization Pages: 3 (432 words) Published: December 20, 2012
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...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • homework Essay
  • Assignment 1 level 4 Essay
  • MAT 540 Week 4 Homework Essay
  • Essay on Homework Assignment
  • Essay on Assignment 4
  • Assignment 4 Essay
  • Assignment 4 Essay
  • Essay on Assignment 4

Become a StudyMode Member

Sign Up - It's Free