1 / 11

Healthy Cuisine Database

Healthy Cuisine Database. CS 3310 Semester Project. Executive Overview.

dylan
Download Presentation

Healthy Cuisine Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Healthy Cuisine Database CS 3310 Semester Project

  2. Executive Overview A healthy cuisine website wishes to create a web application that allows users to search for recipes by criteria such as ingredients, tools used, and meal category. The web application frontend will access the main table which will contain individual recipe details. It will also access the supplementary ingredients, utensils, and meal category tables which will be linked to it by intersection tables, in order to facilitate searching by criteria. Additional functionality in the form of cross-referenced nutritional information and a grocery inventory system is planned as well. In the interest of agile development, the recipe system will be the initial focus, with the secondary systems incorporated at a later date.

  3. E-R Diagram

  4. Relational Schema

  5. Data Dictionary

  6. SQL statements for creating tables and inserting records into the tables SQL statements SQL statements SQL statements SQL statements SQL statements SQL statements SQL statements SQL statements SQL statements SQL statements SQL statements ...

  7. List of Tables

  8. Tables Recipes, Utensils, and Categories tables, with intersection table relating rows.

  9. Tables - 2 • Recipes & Ingredients Tables, with intersection tables relating rows

  10. Queries Ingredient Search Query Utensil Search Query Category Search Query

  11. Appendix Future Work A cross-referenced nutritional information system and a linked grocery inventory system would be added at a later date. This would entail finding a way to access a nutritional information database (or data warehouse) as well as possibly linking UPC codes for easier information retrieval.

More Related