1254 The following is an extract from a large spreadsheet. It is one single table which is separate into two. The second table is a continuation of the first table. Avail for Return to Artist Artist YrBorn Yr Death Painting# Title Theme Stock# Rent hire from Owner CustID CustName A101 Sidney Nolan 1917 1992 P109 Pretty Polly Mine Landscape 1254 $1,250 1/01/2000 345 Tim Paine A101 Sidney Nolan 1917 1992 P109 Pretty Polly Mine Landscape $1,250 1/01/2000 30/06/2002 A101 Sidney Nolan 1917 1992 P109 Pretty Polly Mine Landscape 3750 $1,500 1/01/2005 345 Tim Paine A101 Sidney Nolan 1917 1992 P109 Pretty Polly Mine Landscape 3750 $1,500 1/01/2005 179 Steve Smith A101 Sidney Nolan 1917 1992 P305 Inland Australia Landscape 3780 $1,500 1/03/2008 179 Steve Smith A102 Grace Cossington Smith 1892 1984 P599 The Sock Knitter Portrait 2230 $1,200 1/09/2012 250 Dave Warner A102 Grace Cossington Smith 1892 1984 P310 The Reader Portrait 7410 $1,500 1/09/2019 345 Tim Paine CustAdd CustTel Category# CateDes Discount Date Hire Hobart 03-99887766 C003 Gold 10% 1/03/2000 Hobart Sydney Sydney Sydney Hobart 03-99887766 C003 02-98765432 C003 02-98765432 C003 02-98761234 C004 03-99887766 C003 Gold Gold Gold Platinum Gold 10% 1/09/2010 10% 1/09/2017 10% 1/01/2018 15% 1/07/2017 10% 1/12/2001 Hire DateDue Return Owner# Owner Ownertel OwnAdd 30/11/2001 Y 812 L. Murdoh 0414123456 Sydney 812 L.Murdoh 0414123456 Sydney 30/06/2017 Y 812 L.Murdoh 0414123456 Sydney 1/09/2020 N 812 L. Murdoh 0414123456 Sydney 1/01/2021 N 364 J.Parker 0425987654 Melbourne 30/06/2020 N 812 L. Murdoh 0414123456 Sydney 30/11/2019 N 812 L.Murdoh 0414123456 Sydney A local art gallery specialises in Australian paintings which rents out paintings to private individuals and commercial organisations. You are asked to design and implement a database to support the business. You are given a sample of transaction records from a large spreadsheet which has been used to keep all the relevant records, such as owners, paintings, customers, artists and rental details. Customers are categorised as Bronze, Silver, Gold or Platinum. These categories entitle a customer to a discount of 0% to 15%. Any paintings that are not hired within six months are returned to the owner. However, after three months, an owner may resubmit a returned painting. Over time a customer may hire the same painting more than once. You are required to: (a) Normalise the above spreadsheet into tables in the third normal form (3NF) (b) Create an Entity Relationship Diagram (ERD) based on the the tables in (1) above. 1254 The following is an extract from a large spreadsheet. It is one single table which is separate into two. The second table is a continuation of the first table. Avail for Return to Artist Artist YrBorn Yr Death Painting# Title Theme Stock# Rent hire from Owner CustID CustName A101 Sidney Nolan 1917 1992 P109 Pretty Polly Mine Landscape 1254 $1,250 1/01/2000 345 Tim Paine A101 Sidney Nolan 1917 1992 P109 Pretty Polly Mine Landscape $1,250 1/01/2000 30/06/2002 A101 Sidney Nolan 1917 1992 P109 Pretty Polly Mine Landscape 3750 $1,500 1/01/2005 345 Tim Paine A101 Sidney Nolan 1917 1992 P109 Pretty Polly Mine Landscape 3750 $1,500 1/01/2005 179 Steve Smith A101 Sidney Nolan 1917 1992 P305 Inland Australia Landscape 3780 $1,500 1/03/2008 179 Steve Smith A102 Grace Cossington Smith 1892 1984 P599 The Sock Knitter Portrait 2230 $1,200 1/09/2012 250 Dave Warner A102 Grace Cossington Smith 1892 1984 P310 The Reader Portrait 7410 $1,500 1/09/2019 345 Tim Paine CustAdd CustTel Category# CateDes Discount Date Hire Hobart 03-99887766 C003 Gold 10% 1/03/2000 Hobart Sydney Sydney Sydney Hobart 03-99887766 C003 02-98765432 C003 02-98765432 C003 02-98761234 C004 03-99887766 C003 Gold Gold Gold Platinum Gold 10% 1/09/2010 10% 1/09/2017 10% 1/01/2018 15% 1/07/2017 10% 1/12/2001 Hire DateDue Return Owner# Owner Ownertel OwnAdd 30/11/2001 Y 812 L. Murdoh 0414123456 Sydney 812 L.Murdoh 0414123456 Sydney 30/06/2017 Y 812 L.Murdoh 0414123456 Sydney 1/09/2020 N 812 L. Murdoh 0414123456 Sydney 1/01/2021 N 364 J.Parker 0425987654 Melbourne 30/06/2020 N 812 L. Murdoh 0414123456 Sydney 30/11/2019 N 812 L.Murdoh 0414123456 Sydney A local art gallery specialises in Australian paintings which rents out paintings to private individuals and commercial organisations. You are asked to design and implement a database to support the business. You are given a sample of transaction records from a large spreadsheet which has been used to keep all the relevant records, such as owners, paintings, customers, artists and rental details. Customers are categorised as Bronze, Silver, Gold or Platinum. These categories entitle a customer to a discount of 0% to 15%. Any paintings that are not hired within six months are returned to the owner. However, after three months, an owner may resubmit a returned painting. Over time a customer may hire the same painting more than once. You are required to: (a) Normalise the above spreadsheet into tables in the third normal form (3NF) (b) Create an Entity Relationship Diagram (ERD) based on the the tables in (1) above