The following activity consists of looking at an invoice and coming up with the entities, attributes...

Transcribed Image Text:

The following activity consists of looking at an invoice and coming up with the entities, attributes and relationships. Identify each of these from the invoice, identify potential attributes not shown on the invoice that you may require. List each item and explain your rationale to declare the item an entity and/or attribute. Identify relationships between possible entities. GERBING'S Gerbing's Heated Clothing, Inc. 750 E Dalby Road Union, WA 98592 800.646.5916 www.gerbing.com Sold To Dave Gerbing Somewhere Street Vancouver, WA 98664 ID Name C34795 Dave Gerbing C34795 Dave Gerbing C34795 Dave Gerbing Ship To Dave Gerbing Somewhere Street Vancouver, WA 98664 Itm Description JLT Jacket Liner, Thin GTM Gloves, Men's TXO Coax Troller, Portable Color Black Black Black Date 01/02/03 Order# R81918 Customer C34795 Size INVOICE Original 5236 L Price Qty Ext'd $199 1 $199.00 $139 1 $139.00 $69 1 $69.00 The following activity consists of looking at an invoice and coming up with the entities, attributes and relationships. Identify each of these from the invoice, identify potential attributes not shown on the invoice that you may require. List each item and explain your rationale to declare the item an entity and/or attribute. Identify relationships between possible entities. GERBING'S Gerbing's Heated Clothing, Inc. 750 E Dalby Road Union, WA 98592 800.646.5916 www.gerbing.com Sold To Dave Gerbing Somewhere Street Vancouver, WA 98664 ID Name C34795 Dave Gerbing C34795 Dave Gerbing C34795 Dave Gerbing Ship To Dave Gerbing Somewhere Street Vancouver, WA 98664 Itm Description JLT Jacket Liner, Thin GTM Gloves, Men's TXO Coax Troller, Portable Color Black Black Black Date 01/02/03 Order# R81918 Customer C34795 Size INVOICE Original 5236 L Price Qty Ext'd $199 1 $199.00 $139 1 $139.00 $69 1 $69.00