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 YrBom YrDeath 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 1254 $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 Hire CustAdd CustTel Category# CateDes Discount Date Hire DateDue Return Owner Owner OwnerTel OwnAdd Hobart 03-99887766 CO03 Gold 10% 1/03/2000 30/11/2001 Y 812 LMurdoh 0414123456 Sydney 812 L.Murdoh 0414123456 Sydney Hobart 03-99887766 CO03 Gold 10% 1/09/2010 30/06/2017 Y 812 LMurdoh 0414123456 Sydney Sydney 02-98765432 COO3 Gold 10% 1/09/2017 1/09/2020 N 812 LMurdoh 0414123456 Sydney Sydney 02-98765432 Gold 10% 1/01/2018 1/01/2021 N 364 J.Parker 0425987654 Melbourne Sydney 02-98761234 CO04 Platinum 15% 1/07/2017 30/06/2020 N 812 LMurdoh 0414123456 Sydney Hobart 03-99887766 CO03 Gold 10% 1/12/2001 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 retumed 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.Artist Painting Rent Details Owners 1. Artist# (PK) 1. Painting# (PK) 1. Stock# 1. Owner# (PK) 2. Artist 2. Title 2. Rent 2. Owner 3. YrBorn 3. Theme 3. 3. OwnerTel 4. YrDeath 4. Grade 4. OwnerAdd 5. Artist# (FK) 5. Painting# (FK) HireTable Customers 1. Painting# 1. CustID (PK) 2. Owner# 2. CustName Category 3. Customer# 3. CustAdd 1. Category (PK) 4. Avail for hire from 4. CustTel 2. CateDes 5. Date Due 3. Discount 6. Return to Owner 4. CustID (FK)