Question 1 PLEASE ANSWER QUICKLY!!!

Scenario:

You have been hired to develop an information system for Marcys Munchies. A small retail food outlet in Auckland owned by Marcy Backhurst. She buys her stock in small quantities, primarily from discount supermarkets like PAKnSAVE. Seeing that everything is now bar-coded, she would like to invest in a system that would allow her to keep track of the stock that she sells, how fast she sells it, and make sure that the computer can automatically let her know when re-orders are necessary. She needs to be able to print out a list of goods that she might require on her next trip.

As such, most of her stock comes in this way, but there are some items which are more regular (such as newspapers, which she is invoiced for), and some others are delivered (after sending an order by email) and payment is (again) by invoice. For the last item, all items ordered come at once.

During her day, she finds that much of the activity is done between rush hours, and so she likes to peruse the local paper and see what bargains the different supermarkets are offering (and from what period). These she would like to keep track of on her computer so that when she does get a printout, it can make a suggestion as to where to purchase goods from. Marcy has no credit customers.

1. Draw an REA diagram based on the assignment scenario and then Create a relational database for Marcys Munchies that is based on your own REA diagram, Create the database using a program e.g. Microsoft ACCESS, Insert two records into each table (create your own data).