MIS 140 Arakawa
You (and a partner if you wish) have been just opened MIS Hot Sauce Factory
company that sells hot sauce. Your primary responsibility is to supervise a team
of sales representatives. Because you are a very organized person, you want to
create a database to keep track of your team members, their sales, as well as
their customers. You also want to be able to search through your information to
help you make decisions about bonuses, purchases, and other issues. So you
have decided to create an Access database. You will create tables, enter in data
from company printouts (I will provide these), and create queries and forms.
Create 3 tables (more will be needed):
Primary Keys Values must be S1,S2,S3,S4,S5
) Include a
name (you make this up yourself) the type of pepper(s) used (jalapeño, scotch
bonnet, cayenne …), heat (mild, medium, hot, WTF
…), and price
(and others you may need).
Primary Keys Values must be E1,E2,E3,E4,E5
First Name, Last Name, Phone, email, address (and others you may need).
Primary Keys Values must be C1,C2,C3,C4,C5
Name, Last Name, Phone, email, address (and others you may need).
These table need to be linked to the other tables.