Chapter 5 (p. 185 – 189):
• Problems 1 - 4
• Problems 15 - 17
Note: you are required to use MS Visio for all the problems
• 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
Homework Assignment 4
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)
(INV_NUM SALE_DATE, QUANT_SOLD)
(PROD_NUM PROD_LABEL, VEND_CODE, VEND_NAME, PROD_PRICE)
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...