A/Create set of relations in 3rd normal form?

B/Create a corresponding schema diagram. Adequately denote foreign keys and integrity constraints

Author Marion un Preparation Ingredients Book Title Page Year 1990 Recipe Name Noels Apine Vegetable Soup Vegetarian Company Rice with Be ans Shrimp and Shells Greek Chicken with Category Dessert Cookies Soup, Entre, pecans, brown sugar Fanny Farmer Cookbook 63 potato, chicken broth, zucchini beans, tomato zucchini, cheese shrimp, shel pasta, min am Jane Brodys Good Food320985 Jane rody Jane Brody Jane Brody 30 min Book Book Book Jane Brodys Good Food Entre Vegetarian 30 min 376198s Jane Brodys Good Food 417 1985 30 min Se afood Entre Poult Entre J rodys Good Food chicken, feta, tomato Jane Brody min cheese 40-clove Garlic Chicken Poult Flounder with Mexican Hot Entre Jane Brody's Good Food319e5 Jane Brody ane Brodys Good Food45 Jane Brodys Good Food 474 1985 Jane Brodys Good Food483 1985 Jane Brody 1988 Best Recipes chicken, garlic vermouth rs Book Book Book Book 20 min fish, tomato, ssa Jane Brody Se afood Entre Sauce Mustard and onion pizza Vegetarian Fritata wth Broccoli andEntre mustard, onion, fontina eggs, potato broccoli, parmesan tomato juice chickpea, potato 40 min Jane Brody min Potatoes Vegetanan Soup, Entre,45 min Idaho Chili Yearbook 16 1988 EH&G anan pork, water chestnuts, tree ears Mrs Chiang's Szea0976 Pork in the Style of FishEntre 45 min Schrecker Ann Chiarn Pork Cookb ook Pork Shreds wth HoisinEntre Sauce pork, scallions, hoisin sauce Mrs Chiang's Szechuan 1061976 Cookbook Schrecker Ann Chian min Pork