- Mr. Frumble, a great childrens character that alwaysgets into trouble, designed a simple database to record projectedmonthly sales in his small store. He came up with the followingschema:
Sales(name, discount,month, price)
He inserted his data into thedatabase, then he realized that there is something wrong with it:it was difficult to update! He hires you as a consultant to fix hisdata management problems. He gives you this file,mrFrumbleData.txt, and says: “Fix it for me!”. Help him bynormalizing his database. That will make his updates mucheasier.
Unfortunately, you cannot sit down andtalk to Mr. Frumble to find out what functional dependencies makesense
OR
OR