Ashton wants to store the following data about s& s’s purchases of inventory: item number date of purchase vendor number vendor address vendor name purchase price quantity purchased employee number employee name purchase order number description quantity on hand extended amount total amount of purchase
a. design a set of relational tables to store this data.
do all of the data items need to be stored in a table?
if not, which ones do not need to be stored and why do they not need to be stored?
b. identify the primary key for each table.
c. identify the foreign keys needed in the tables to implement referential integrity.

Lucido products markets two computer games: claimjumper and makeover. a contribution format income statement for a recent month for the two games appears below: claimjumper makeover total sales $ 30,000 $ 70,000 $ 100,000 variable expenses 20,000 50,000 70,000 contribution margin $ 10,000 $ 20,000 30,000 fixed expenses 24,000 net operating income $ 6,000 required: 1. compute the overall contribution margin (cm) ratio for the company.. 2. compute the overall break-even point for the company in dollar sales. 3. complete the contribution format income statement at break-even point for the company showing the appropriate levels of sales for the two products. (do not round intermediate calculations.)