Using the following database code:

USE MenuDatabase CREATE TABLE [dbo].[Menu]( [ID] INT PRIMARY KEY, [MenuTitle] [nvarchar](50) NULL, [MenuDescriptionText] [nvarchar](50) NULL) CREATE TABLE [dbo].[MenuGroups]( [ID] INT PRIMARY KEY, [MenuID] INT NOT NULL, [MenuGroupText] [nvarchar](50) NOT NULL, [MenuGroupDescriptionText] [nvarchar](50) NULL, FOREIGN KEY (MenuID) REFERENCES Menu(ID)) CREATE TABLE [dbo].[MenuItems]( [ID] INT PRIMARY KEY, [MenuGroupsID] INT NOT NULL, [MenuItemTitle] [nvarchar](50) NOT NULL, [MenuItemDescriptionText] [nvarchar](50) NULL, FOREIGN KEY (MenuGroupsID) REFERENCES MenuGroups(ID)) CREATE TABLE [dbo].[Ingredients]( [ID] INT PRIMARY KEY, [IngredientTitleText] [NVARCHAR](50) NOT NULL, [IngredientDescriptionText] [NVARCHAR](200) NULL ) CREATE TABLE [dbo].[IngredientsInItems]( [ID] INT PRIMARY KEY, [IngredientsID] INT NOT NULL, [MenuItemID] INT NOT NULL, [DescriptionText] [NVARCHAR](200), FOREIGN KEY (IngredientsID) REFERENCES Ingredients(ID), FOREIGN KEY (MenuItemID) REFERENCES MenuItems(ID))

Create a stored procedure sp_InsertIngredient that INSERTS an ingredient and places it in a Menu Item.