Cereals RUS is a company that distributes cereal products to small grocery businesses across the country. They maintain information for the cereal products in the cereal.csv file. The company deals directly with the different manufacturers to get the products delivered to their customers (a separate customer file is maintained, but out of the scope of this problem). They use the data in this file to provide the customer information about the cereals (e.g. cord or hot cereal, calories, nutritional information) and to maintain an average customer rating for each product.

The companys owner would like to easily maintain the data in this file using a database. She will be the only one using the system (at least for now!).

cereal.csv (spreadsheet file)

The only user of the system is the owner (actor).

Write the uses cases for the database. Describe your assumptions.

Using the data provided in the spreadsheet, split the list into tables such that each has only one theme (separate entities or objects). Create appropriate ID columns in each table and the appropriate fields (properties) in each tables columns. . THINK SIMPLE.

Complete the ERD diagram for the database following the examples in this Thursdays Session.

Create a new Access database. Build your tables in the database with fields and appropriate field properties. Add 5 (five) records to each of your tables

AL name D E G 1 name Imanufact manufact manufact, manufacti manufacttype 2 100% Bran Nabisco S9NGroe Austin TX 78731 Cold 3 100% Nati Quaker O/20 S Babcd Fairbanks AK 99712 Cold 4 All Bran Kelloges 201 Hawk Providen RI 72904 Cold 5 All-Bran Kellogrs 201 Hawk Providend RI 72904 Cold 6 Almond D Ralston P70 W Mair Beachwo. OH 44122 Cold 7 Apple Cin General M4 Otis St Van Nuys CA 91405 Cold 8 Apple Jadi Kellorgs 201 Hawk Providenc RI 72904 Cold 9 Basic 4 General M4 Otis St Van Nuys CA 91405 Cold 10 Bran Chex Ralston P70 W Mair Beachwoc OH 44122 Cold 11 Bran Flake Post 2664 Lewi Littleton Co 80126 Cold 12. Cap'n'Crui Quaker O/20S Babc Fairbanks AK 99712 cold 13 Cheerios General 14 Otis St Van Nuys CA 91405 Cold 14 Cinnamor General M4 Otis St Van Nuys CA 91405 Cold 15 Clusters General 14 Otis St Van Nuys CA 91405 Cold 16 Cocoa Puf General 14 Otis St Van Nuys CA 91405 Cold 17 Corn Chex Ralston PL 70 W Mair Beachwoc OH 44122 Cold 18 Corn Flake Kelloges 201 Hawk Providenc RI 72904 Cold 19 Corn Pops Kelloggs 201 Hawk ProvidencRI 72904 Cold 20 Count Ch General 14 Otis St Van Nuys CA 91405 Cold 21 Cracklin'Kelloggs 201 Hawk Providenc RI 72904 Cold cereal(1) H calories protein fat 20 4 120 3 70 4 50 4 110 2 110 2 110 2 130 3 90 2 90 3 120 1 110 6 120 1 110 3 110 1 110 2 100 2 110 1 110 1 110 3 OONNNO-NONNO sodium fiber 1 130 5 15 1 260 140 200 180 125 210 1 200 210 220 M N P carbo sugars vitamins rating 10 5 6 25 68.40297 2 8 8 0 33.98368 9 7 5 25 53.42551 14 8 0 25 93.70491 1 14 8 25 34.38484 1.5 10.5 10 25 29.50951 1 11 14 25 33.17409 2 18 8 25 37.03856 4 15 6 25 49.12025 5 13 5 25 53.31381 0 12 12 25 18.04285 2 17 1 25 50.765 0 13 9 25 19.82357 2. 13 7 25 40.40021 0 12 13 25 22.73645 0 22 3 25 41.44502 1 21 2 25 45.86332 1 13 12 25 35.78279 0 12 13 25 22.39651 4 10 7 25 40.44877 290 210 140 180 280 290 90 180 140 0 1 3 + Type here to search O RE 1 Page Layout Formus Dat Review 1 Get Addins Pivottable Recommended to be Recommended My Addins - Maps PorChart 10 line Column Win Pivottable Slicer Tuneline Link Charts Map Low Addins Charts Tour Sparklines Filters Links POSSIBLE DATA LOSS Some features might be lost you save this workbook in the comma-delimited (w) loma lo preserve these features, save in an cel de format Don't show again Comment Comments Save As Al X name H 1 K M N O R 0 1 0 21 21 0 1 0 1 100 110 100 100 110 110 100 120 3 2 2 2 2 1 3 3 3 1 0 SO 220 140 190 125 200 0 160 240 135 2 1 1 1 3 5 5 0 2 1 F 78731 Hot 72904 Cold 91405 Cold 44122 Cold 72004 Cold 72904 cold 72900 Cold 80126 Cold 72904 Cold 80126 Cold 80126 Cold 91405 Cold 80126 Cold 80126 Cold 80126 Cold 99712 Cold 91405 Cold 80126 Cold 72901 Cold 72904 Cold 91405 Cold D E 22 Cream of Nabisco S9NGroe Austin TX 23 Crispix Kelloggs 201 Hawk Providenc RI 24 Crispy Wh General N4 Otis St Van Nuys CA 25 Double C Ralston P70 W Mair Beachwoc OH 26 Froot Loo Kelloggs 201 Hawk Providenci 27 Frosted FI Kellos 201 Hawk Providend RI 28 Frosted M Kelloggs 201 Hawk Providence 29 Fruit & Fit Post +2664 Lewi Littleton co 30 Fruitful BrKellores 201 Hawk Providenci 31 Fruity Pet Post 2664 Lewi Littleton Co 32 Golden Post 2664 Lewi Littleton co 33 Golden GrGeneral 4 Otis St Van Nuys CA 34 Grape Nut Post 2664 Lewi Littleton Co 35 Grape-Nu Post 2564 Lewi Littleton co 36 Great Gral Post 2564 Lewi Littleton CO 37 Honey GriQuaker O/20 5 Babce Fairbanks AK 38 Honey Nu General 4 Otis St Van Nuys CA 39 Honey.coPost 2664 Lewi Littleton Co 40 Just Right Kelloge 201 Hawk Providenci 41 Just Right Kelloges 201 Hawk Providenci 42 Klix General M4 Otis St Van Nuys CA cereal(1) 3 10 5 13 11 7 10 12 12 15 1 2 1 0 1 1 280 0 64.5332 25 46.29564 25 36.1762 25 44.33086 25 12 2075 25 31.43597 25 58.3514 25 40.91705 25 41,01549 25 28.02577 2535.25244 25 23.30404 25 52.0769 25 53.37101 25 45.81172 25 2187129 25 31.07222 25 28.74241 100 36.52368 100 36.47151 25 39.24111 3 3 120 110 100 110 100 110 120 120 110 110 110 140 110 0 11 14 14 12 14 13 11 15 15 17 13 12 11.5 14 17 20 21 9 5 3 4 3 3 3 3 1 1.5 3 2 1 140 170 75 220 250 180 170 170 260 3 1 11 10 0 1 1 2 3 2 1 1 11 6 9 3 Type here to search O 9 1 A1 name M N O R 21 150 2 12 4 2. 4 1 6 12 H 100 110 150 150 160 100 120 1 2 12 16 3 3 11 11 4 3 2 2 3 2 1 16 12 15 3 2 0 13 6 140 95 150 150 220 190 220 170 170 200 1 2 0 3 3 3 F G 99712 cold 91405 Cold 44122 cold 44122 Cold 72904 Cold 91405 Cold 720 Cold 72004 Cold 72901 Cold 91405 Cold 80126 Cold 7290 Cold 99712 Cold 99712 Cold 99712 Cold 99712 Hot 72904 Cold 91405 Cold 72904 Cold 46122 Cold 72904 Cold 21 18 15 E 43 Life Quaker O 20 5 Rabce Fairbanks AK 44 Lucky Cha General 4 Otis St Van Nuys CA 45 Muesli Ra Ralston P70 W Mair BeachwocOH 46 Muesli Ra Ralston P70 W Mair Beachwod CH 47 Mueslix C Kelloggs 201 Hawk Providenci 4 Multi-Gral General N4 Otis St Van Nuys CA 49 Nut&Hon Kelloggs 201 Hawk Providence 50 Nutri Graikellones 201 Hawk ProvidencRI 51 Nutrigral Kellos 201 Hawk ProvidencRI 52 Oatmeal General 4 Otis St Van Nuys CA 53 Post Nat. Post 2664 Lewi Littleton co 54 Product Kelloggs 201 Hawk Providenc RI 55 Puffed Ric Quaker OL 20 S Babe Fairbanks AK 56 Puffed wi Quaker O 20 5 Baboc Fairbanks AK 57 Quaker O Quaker / 20 5 Baboc Fairbanks AK S& Quaker O Quaker OI 20 Babe Fairbanks AK 59 Raisin Bra Kellogas 201 Hawk ProvidencRI 60 Raisin Nut General 4 Otis St Van Nuys CA 61 Raisin Squ Kelloggs 201 Hawk ProvidencRI 62 Rice Chex Ralston PL 70 W Mair Beachwoc OH 63 Rice Krisp Kelloggs 201 Hawk Providenci cereal(1) 7 2 10 14 3 2 1.5 3 320 3 25 45 0 25 26.73452 25 37.1366 25 24.11977 25 1011115 25 40 10597 25 1924 25 40.69212 25 59.042 25 30.4503 2537.00 100 41.50154 0 60.75611 0600565 2551187 050.82839 25 39.2592 25 39.7034 25 55.33314 25 41.99893 25 40.56016 1 0 0 O 1 3 1 2 11 20 13 10 14 O 130 120 100 SO 50 100 100 120 100 90 110 110 1 0 1 2 2.7 0 0 6 -1 4 5 2 1 12 3 3 2 1 2 5 25 135 0 210 140 0 240 290 2 0 -1 14 10.5 15 23 22 8 6 2 0 . 0 0 2 3 N Type here to search O g AI name E 1 K N H 110 0 0 3 0 2 O 290 0 0 80 90 90 3 4 3 0 0 0 3 2 1 3 1 1 0 15 110 110 D 63 Rice Krisp Kelloges 201 Hawk Providenc Ri 64 Shredded Nabisco 59 N Groe Austin TX 65 Shredded Nabisco 59 N Groe Austin TX 66 Shredded Nabisco 59 N Groe Austin TX 67 Smacks Kelloggs 201 Hawk Providenc RI 68 Special K Kelloggs 201 Hawk Providenc RI 69 Strawberr Nabisco 59 N Groe Austin TX 70 Total Cor General 14 Otis St Van Nuys CA 71 Total Raisi General M4 Otis 5t Van Nuys CA 72 Total Whc General 14 Otis St Van Nuys CA 73 Triples General N4 Otis St Van Nuys CA 74 Trix General N4 Otis St Van Nuys CA 75 Wheat Ch Ralston PL 70 W Mair Beachwoc OH 76 Wheaties General M4 Otis St Van Nuys CA 77 Wheaties General M4 Otis St Van Nuys CA 78 0 G 72901 Cold 78731 Cold 78731 Cold 78731 Cold 72904 Cold 72904 Cold 78731 Cold 91405 Cold 91405 Cold 91405 Cold 91405 Cold 91405 Cold 44122 Cold 91405 Cold 91405 Cold M 22 16 19 20 9 16 15 21 15 16 0 1 1 0 70 230 15 200 190 200 250 140 230 200 200 6 2 2 3 3 2 1 3 90 110 140 100 110 110 100 100 110 3 0 4 3 5 3 14 3 2 12 25 40.56016 068.23589 0 74.47295 0 72.80179 25 31.23005 25 53.13132 25 59.36399 100 38.81975 100 28.59279 100 46.65884 25 39.10617 25 27.7533 25 49.78M5 25 51.59219 25 36.18756 1 1 1 0 21 13 17 1 3 3 3 3 3 1 1 17 16 2 1 8 79 80 81 82 22 corea (1) Type here to search o HI e