Using the knowledge in computational language in SQL it is possible to write the code that display for every restaurant the name of the restaurant and for every category of menu item its description.
<h3>Writting the code:</h3><em>INSERT INTO Dish </em><em>Values</em><em>(13, 'Spring Rolls', 'ap');</em>
<em>INSERT INTO Dish Values(15, 'Pad Thai', 'en'); </em>
<em>INSERT INTO Dish Values(16, 'Pot Stickers', 'ap'); </em>
<em>INSERT INTO Dish Values(22, 'Masaman Curry', 'en'); </em>
<em>INSERT INTO Dish Values(10, 'Custard', 'ds'); </em>
<em>INSERT INTO Dish Values(12, 'Garlic Bread', 'ap'); </em>
<em>INSERT INTO Dish Values(44, 'Salad', 'ap'); </em>
<em>INSERT INTO Dish Values(07, 'Cheese Pizza', 'en'); </em>
<em>INSERT INTO Dish Values(19, 'Pepperoni Pizza', 'en'); </em>
<em>INSERT INTO Dish Values(77, 'Veggie Supreme Pizza', 'en');</em>
<em />
<em>INSERT </em><em>INTO MenuItem Values(0, 0, 13, 8.00);</em>
<em>INSERT INTO </em><em>MenuItem </em><em>Values(1, 0, 16, 9.00);</em>
<em>INSERT INTO MenuItem Values(2, 0, 44, 10.00);</em>
<em>INSERT INTO MenuItem Values(3, 0, 15, 19.00);</em>
<em>INSERT INTO MenuItem Values(4, 0, 22, 19.00);</em>
<em>INSERT INTO MenuItem Values(5, 3, 44, 6.25);</em>
<em>INSERT INTO MenuItem Values(6, 3, 12, 5.50);</em>
<em>INSERT INTO MenuItem Values(7, 3, 07, 12.50);</em>
<em>INSERT INTO MenuItem Values(8, 3, 19, 13.50);</em>
<em>INSERT INTO MenuItem Values(9, 5, 13, 6.00);</em>
<em>INSERT INTO MenuItem Values(10, 5, 15, 15.00);</em>
<em>INSERT INTO MenuItem Values(11, 5, 22, 14.00);</em>
See more about SQL atbrainly.com/question/13068613
#SPJ1
