Question: Task 5. Normalize a database Suppose Mike is the owner of a small store. He uses the following database (mike.db) to store monthly sales of


Task 5. Normalize a database Suppose Mike is the owner of a small store. He uses the following database (mike.db) to store monthly sales of his store. .Sales(name, discount, mouth, price) %load-ext 8sql sqlite:///mike.db In [3]: sql The sql extension is already loaded. To reload it, use: 8reload ext sql u Connected: Imike.db Out[ 3 In [4]. tsqi select * from sales limit 5 *sqlite:///mike.db sqlite:///sfu.db Done. Out [ 4]: name discount month price bar10.15 bar80.15 gizmo3 0.15 apr 19 gizmo7 0.15 apr 19 mouse1 0.15 apr 19 apr 19 apr 19 However, Mike finds that the database is difficult to update (i.e., when inserting new data into the database). Your job is to help Mike to normalize his database You should do the following steps(a-d): Task 5. Normalize a database Suppose Mike is the owner of a small store. He uses the following database (mike.db) to store monthly sales of his store. .Sales(name, discount, mouth, price) %load-ext 8sql sqlite:///mike.db In [3]: sql The sql extension is already loaded. To reload it, use: 8reload ext sql u Connected: Imike.db Out[ 3 In [4]. tsqi select * from sales limit 5 *sqlite:///mike.db sqlite:///sfu.db Done. Out [ 4]: name discount month price bar10.15 bar80.15 gizmo3 0.15 apr 19 gizmo7 0.15 apr 19 mouse1 0.15 apr 19 apr 19 apr 19 However, Mike finds that the database is difficult to update (i.e., when inserting new data into the database). Your job is to help Mike to normalize his database You should do the following steps(a-d)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
