Online Recipe and Meal Planner - Essay Example

This info is useful for people who are on a diet and want to control the calories they receive. The manager or administrator is the person who controls the content of the website by adding/editing and removing the information. The administrator also keeps control of other aspects of a website like hosting, databases and technical support. The system is a web application and uses web server technologies. In includes a database (MS Access 2007) that stores the meal recipe, ingredient and costs and a web interface (Asp.

net and C#) that interacts with the database. The final system will have to be uploaded on a real server however in the development and testing process it can be implemented on a local machine and using a virtual web server created by a development tool like Microsoft Visual Studio 2005. Once the development and testing has been successful, it can be uploaded on an actual server for all the internet users to use. The structure of database has to be designed in a way to comply with issues like data integrity.

So the main focus has to be on the relational database and normalisation. Making sure that the query, insert, update and delete commands operate correctly, otherwise that could lead to a loss of data integrity. The reliability of this system will be achieved when all the tables in the relational database are of Third Normal Form (3NF). The reason is that most 3NF tables in relational databases are free of insertion, deletion and update anomalies. There are many different software development techniques used/employed when software is being developed.