A Business Owner want to store information about purchases of inventory:

item number

date of purchase

terms of payment

vendor number

vendor address

vendor name

purchase price

quantity purchased

buyer number

buyer name

purchase order number

item description

quantity on hand

extended amount

total amount of purchase

shipping method

Required:

Design a set of relational tables to store this data. If data does not need to be stored, identify and note why it does not need to be stored.

Identify the primary key for each table.

Identify the foreign keys needed in the tables to implement entity integrity.

Draw an ERD using crows feet formatting to show the relationships and cardinality amongst the tables of the database.