Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2006
    Posts
    4

    Unanswered: Need help with question

    Here is an extract from a case study for an exam I have got on Friday. I am guessing that the question will be based around database structure with attributes. Just wondered if anyone had any ideas and pointers. I am totally panicking at the moment.

    Mike Webb is the Stock Controller at Topping Food for Animals Ltd. His job is to ensure that there is always enough of each of the raw materials (see table 2) to make the required amount of pet food. At present, Mike has an office outside the storeroom and he keeps track of his stock in a large book, which has a section for each ingredient. As he has been doing the job a long time he knows what the lead times are for the various raw materials and when he would need to order more. He keeps track of how much of each ingredient he has by updating his book when a particular ingredient is delivered (e.g. 200 Χ 50 kg sacks of Micronised Peas). Each time ingredients are taken to the production line Mike updates his book. When the level in his book drops below what he thinks is the minimum quantity he orders some more. Recently Mike has made a couple of mistakes and the factory has run out of various ingredients.

    Furthermore orders for both dog and cat foods have doubled over a three-month period. Mike is due to retire in a year’s time and the charity hopes to replace him with an automatic ordering system and has asked the systems analyst to advise them.

    Table 2

    Ingredients for Topping Food for Dogs– Dried Chicken Meat
    – Ground Rice
    – Corn Gluten
    – Rice Bran
    – Wheat Flour
    – Poultry Fat (min 7%)
    – Beet Pulp
    – Sunflower Oil (min 2.0%)
    – Potassium Chloride
    – Dried Egg Product
    – Dried Kelp

    Ingredients for Topping Food for Cats– Dried Chicken Meat
    – Ground Rice
    – Corn Gluten
    – Poultry Fat (min 12%)
    – Beet Pulp
    – Rice Flour
    – Rice Protein
    – Dried Herring
    – Sunflower Oil (min. 1.0%)
    – Dried Alfalfa
    – Oat Fibre
    – Dried Yeast
    – Potassium Chloride
    – Menhaden Fish Oil
    – Dried Egg Product
    – Dried Bacillus Licheniformis Fermentation Extract
    – Dried Bacillus Subtilis Fermentation Extract
    – Chicory Extract
    – Cranberry Powder

    Ingredients for Topping Food for Horses– Micronised Barley
    – Micronised Maize
    – Micronised Peas
    – Grass Pellets
    – Mineral Vitamin Pre-Mix
    – Linseed Pellets
    – Oatfeed Pellets
    – Molasses
    – Soya Oil
    – Bruised Oats

  2. #2
    Join Date
    Jan 2006
    Posts
    5
    So what is the question?

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    and equally what have you tried so far...

    you may get an answer on coursework questions, but you do need to show what you have done, and in some cases why you have done.....

    The only way you are going to learn is by applying the knowledge you have (alledgedly) learned over the last few months. By all means ask here if you have hit an 'oh shaggy' moment, a roadblock, but the point of your exercise is for you to learn. Learn by doing, and perhaps more rewarding learn from any mistakes you make. People providing answers here don't neccessarily give the concepts behind the answers they give (they don't have time, they assume a level of knowledge) so by asking gernal questions you leave yourself exposed to having an answer, but not understanding that answer, and not being able to apply that understanding to other problems.

    In short, do yourself a favour, have a go at trying to solve the problem yourself - where you go wrong, those are the places you need to work on.
    HTH
    Last edited by healdem; 01-24-06 at 06:08.
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Nov 2003
    Posts
    1,487
    Hmmm....perhaps consider this:

    Automated Inventory and Odering control with relational emphasis on present and projected production goals.

    .
    Environment:
    Self Taught In ALL Environments.....And It Shows!


  5. #5
    Join Date
    Nov 2003
    Posts
    1,487
    Hmmm....perhaps consider this:

    Automated Inventory and Odering control with relational emphasis on present and projected production goals.

    The panic continues...

    .
    Environment:
    Self Taught In ALL Environments.....And It Shows!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •