| Throughout this project, I have had to create a database which held all of the types of foods which were going to be part of this project, including my three new database records (SEE BELOW). I had to validate the database which I made on Microsoft Access 2003, and fields like field length and data types needed to be validated, so that no anomalous results could be entered. I was also instructed about other fields which needed to validated after my project was checked. Some of the things I did was choosing a primary key, which was Food item, and it nwas vital I had it, as it made sure no food had the same name. |
| To make my database, I needed different food groups, and within that there were different foods, so for instance, in the meats sections, there were different meats like chicken breast. To enter this, I used a text file which was on the DiDA website, which I copied to my files. There were no rejected records from this, so it went very successfully. |
| In my database there are many foods, ranging from a variety of food groups. Meats, fish, dairy etc. I decided to add three new types of foods which were obscure and abstract, and I assumed that the database would not include them. My first food type was grilled octopus. I decided this because it was going to be my only fish group, which meant that there was a bit of variety in my choices, unlike me selecting three different meats. The second food I chose was Elk meat, and I chose this as one, it was not in my database already, and two, because Elk meat sounded very rare, and expensive, and this meat could be a firm favourite if this menu was used. My final food was Ostrich, which like the Elk meat, sounds like a rare food, and could be a favourite among the foods in my database. I also choose all these foods as they were foreign, and like the Olympic spirit, it brings the entire world together, through sport and food |
| For this part of the project, I had to create a list of three foods which were to be used in the course of events. To determine which ones to use, I collected data from my questionnaire, to work out which foods people liked and which ones people ate very little of. From these results I was able to determine that for a Main Course Meat was a very popular course (Though it was not the most popular overall, I chose it as it gave me a wider variety of foods then 'Fruit' did. For the least favourite foods, I chose Fish for the Main course, and for Dessert Cereal and Grains. Fro this point, I needed to narrow down my choice of foods for the Meal Cards later on in the project. To do this, I used my database and made three queries to find all of the meat, then all of the fish and then all of the CG. I had to chose a criteria for what I wanted to chose, and this is explained ion the document to the left. ' |
