IS and Database

    In order for us to keep prices low for our customers, Don't Have a Cow! uses an information system.  This information system allows us to keep track of the purchase and storage of raw materials, our primary activity.  The hardware we use is a PC, scanner, and printer.  Inventory Management Software, Online Supplier Information System, and Order Placement User IS are the software we use to manage the data of raw materials and suppliers. Our manager and database administrator are the two employees who manage our shop's data.

   For raw materials entity, we store in the database the quantity of raw materials each week and the price for bulk from the current supplier.  The key is the Item ID.  For supplier entity, we store in the database the name of the companies and the price for bulk from competing suppliers.  The key is Supplier ID. We use a database instead of a spreadsheet for we have more than one theme.