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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!