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 Owner hire from 1/01/2000 Artist# Artist A101 Sidney Nolan Sidney Nolan A101 A101 Sidney Nolan A101 Sidney Nolan A101 Sidney Nolan A102 Grace Cossington Smith A102 Grace Cossington Smith CustAdd CustTel Hobart 03-99887766 C003 Category# CateDes Gold YrBorn YrDeath Painting# 1917 1992 P109 1917 1992 P109 1917 1992 P109 1917 1992 P109 1917 1992 P305 1892 1984 P599 1892 1984 P310 Hobart 03-99887766 C003 Sydney 02-98765432 C003 Sydney 02-98765432 C003 Sydney 02-98761234 C004 Hobart 03-99887766 C003 Gold Gold Gold Platinum Gold Title Pretty Polly Mine Pretty Polly Mine Pretty Polly Mine Pretty Polly Mine Inland Australia The Sock Knitter The Reader Discount Date Hire 10% 1/03/2000 10% 1/09/2010 10% 1/09/2017 10% 1/01/2018 15% 1/07/2017 10% 1/12/2001 Theme Stock# Rent Landscape 1254 Landscape 1254 Landscape 3750 Landscape 3750 $1,500 1/01/2005 Landscape 3780 $1,500 1/03/2008 Portrait 2230 $1,200 1/09/2012 7410 $1,500 1/09/2019 Portrait Hire Return 30/11/2001 Y DateDue 30/06/2017 Y 1/09/2020 N 1/01/2021 N 30/06/2020 N 30/11/2019 N $1,250 $1,250 1/01/2000 30/06/2002 $1,500 1/01/2005 Owner# CustID CustName 345 Tim Paine Owner OwnerTel OwnAdd 812 L.Murdoh 0414123456 Sydney 812 L.Murdoh 0414123456 Sydney 812 L.Murdoh 0414123456 Sydney 812 L.Murdoh 0414123456 Sydney 364 J.Parker 0425987654 Melbourne 812 L.Murdoh 0414123456 Sydney 812 L.Murdoh 0414123456 Sydney 345 Tim Paine 179 Steve Smith Steve Smith 179 250 Dave Warner 345 Tim Paine 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.