Question: Consider the three reports in Figure 5-59. The data are samples of data that would appear in the reports like these. 1) Make a list
Consider the three reports in Figure 5-59. The data are samples of data that would appear in the reports like these.
1) Make a list of as many potential entities as these reports suggest. 2) For each entity, list possible attributes. Note: NOT asking for relationships between entities.

260 PART 2 Database Design FDA REPORT #6272 Date: June 30, 2017 Issuer: Kelly's Corporation Report Title: Product Summary by Ingredient Kelly's Corn Cereal Kelly's Multigrain Cereal Kelly's Crunchy Cereal Corn Corn syrup Kelly's Corn Cereal Kelly's Rice Cereal Kelly's Crunchy Cereal Kelly's Corn Cereal Kelly's Crunchy Cereal Nutrition Information SERVING SIZE 1OZ (284g ABOUT1 CUP SERVINGS PER PACKAGE Malt CALORIES PROTEIN WheatKelly's Multigrain Cereal 110 150 259 319 Kelly's Crunchy Cereal FAT CHOLESTEROL 0 mg Omg 290 mg 350mg 35 mg 240mg POTASSIUM PERCENTAGE OF U.S. RECOMMENDED AILY ALLOWANCES (U.S. RDA PROTEIN VITAMIN VITAMINC THIAMIN RIBOFLAVIN NIACIN SUPPLIERS LIST Date: June 30, 2017 35 35 35 35 10 10 35 Ingredient Supplier Price 2.80 2.83 VITAMIN D VITAMIN B FOLIC ACID 25 35 Wilson J. Perkins 2.72 Pollack McKay Adams 1.19 Kroner Schmidt 1.22 Wilson Pollack 0.84 Corn MAGNESIUM COPPER CALORIES 4GFAT AND 15mg CHOLESTERO ..CONTA NS LESS THAN N. OF THE US RDA OF 2.80 1.19 0.85 THIS NUTRENT INGREDIENTS: RICE, SUGAR, SALT CORN SYRUP VITAMINS AND IRON: VITAMIN C (SODIUM ASCORBATE AND ASCORBIC ACID) NIACINAMIDE, IRON, VITAMIN 8 (PY RIDOXINE HYDROCHLORIDE), VITAMINA PALMITATEL VITAMIN 8, (RIBOFLAVIN VITAMIN B(THIAMIN H FOLIC ACID AND VITAMIN D Wheat Barley FIGURE 5-59 Cereal Product Reports 260 PART 2 Database Design FDA REPORT #6272 Date: June 30, 2017 Issuer: Kelly's Corporation Report Title: Product Summary by Ingredient Kelly's Corn Cereal Kelly's Multigrain Cereal Kelly's Crunchy Cereal Corn Corn syrup Kelly's Corn Cereal Kelly's Rice Cereal Kelly's Crunchy Cereal Kelly's Corn Cereal Kelly's Crunchy Cereal Nutrition Information SERVING SIZE 1OZ (284g ABOUT1 CUP SERVINGS PER PACKAGE Malt CALORIES PROTEIN WheatKelly's Multigrain Cereal 110 150 259 319 Kelly's Crunchy Cereal FAT CHOLESTEROL 0 mg Omg 290 mg 350mg 35 mg 240mg POTASSIUM PERCENTAGE OF U.S. RECOMMENDED AILY ALLOWANCES (U.S. RDA PROTEIN VITAMIN VITAMINC THIAMIN RIBOFLAVIN NIACIN SUPPLIERS LIST Date: June 30, 2017 35 35 35 35 10 10 35 Ingredient Supplier Price 2.80 2.83 VITAMIN D VITAMIN B FOLIC ACID 25 35 Wilson J. Perkins 2.72 Pollack McKay Adams 1.19 Kroner Schmidt 1.22 Wilson Pollack 0.84 Corn MAGNESIUM COPPER CALORIES 4GFAT AND 15mg CHOLESTERO ..CONTA NS LESS THAN N. OF THE US RDA OF 2.80 1.19 0.85 THIS NUTRENT INGREDIENTS: RICE, SUGAR, SALT CORN SYRUP VITAMINS AND IRON: VITAMIN C (SODIUM ASCORBATE AND ASCORBIC ACID) NIACINAMIDE, IRON, VITAMIN 8 (PY RIDOXINE HYDROCHLORIDE), VITAMINA PALMITATEL VITAMIN 8, (RIBOFLAVIN VITAMIN B(THIAMIN H FOLIC ACID AND VITAMIN D Wheat Barley FIGURE 5-59 Cereal Product Reports
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
