ACC 340 week 4 Learning Team Assignment Database Tables Exercise


J
Asked by 3 years ago
0 points

Database Tables Exercise

ACC/340

Database Tables Exercise

Design Tables

tbl_ ar_orders

column

Type

Description

invoice_num

text

Primary Key

date

date

customer_id

text

FK -

item_num

text

FK -

description

text

FK -

quantity

number

unit_price

currency

FK-

quantity_price

currency

tbl_ar_customers

column

Type

Description

customer_id

text

Primary Key

customer_name

text

customer_address

text

customer_phone

text

customer_credit

Yes/No

ar_bill_cycle

number

tbl_product_inventory

column

Type

Description

item_num

text

Primary Key

description

text

unit_price

currency

quantity...

ACC 340
jacob

1 Answer

J
Answered by 3 years ago
0 points

Oh Snap! This Answer is Locked

ACC 340 week 4 Learning Team Assignment Database Tables Exercise

Thumbnail of first page

Excerpt from file: Runninghead:DATABASETABLESEXERCISE DatabaseTablesExercise ACC/340 1 DatabaseTablesExercise 2 DatabaseTablesExercise DesignTables tbl_ ar_orders column invoice_num date Type text date customer_id text item_num description quantity unit_price quantity_price text text number currency currency column

Filename: acc-340-week-4-learning-team-assignment-database-tables-exercise-49.doc

Filesize: < 2 MB

Downloads: 10

Print Length: 5 Pages/Slides

Words: 284

Your Answer

Surround your text in *italics* or **bold**, to write a math equation use, for example, $x^2+2x+1=0$ or $$\beta^2-1=0$$

Use LaTeX to type formulas and markdown to format text. See example.

Sign up or Log in

  • Answer the question above my logging into the following networks
Sign in
Sign in
Sign in

Post as a guest

  • Your email will not be shared or posted anywhere on our site
  •  

Stats
Views: 2
Asked: 3 years ago

Related