The following is an extract from a large spreadsheet. It is one single table which is...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
1 create database A1Artist 2 use A1Artist 3 drop database A1Artist 4 create table ArtistArtistid varchar10 primary keyArtist varchar40YrBorn intYrDeath int 5 create table PaintingPaintingid varchar10 ... View the full answer
Related Book For
Financial Accounting and Reporting
ISBN: 978-0273744443
14th Edition
Authors: Barry Elliott, Jamie Elliott
Posted Date:
Students also viewed these accounting questions
-
The following is an extract from the Financial Reporting Review Panel website relating to the Wiggins Group showing the restated financial results. Revenue recognition The 1999 accounts contained an...
-
The following is an extract from Accountancy Age, 25 January 2001. A powerful and shadowy group of senior partners from the seven largest firms has emerged to move closer to edging control of...
-
The following is an extract from a credit risk spreadsheet. A B E F J K L. 1 Credit Risk Data Loan Purpose Checking Savings Months Customer Small Appliance Months Employed Gender Marital Status Age...
-
Compare sand, die, investment, lost foam, and continuous casting techniques.
-
STL Entertainment is considering the acquisition of a sight-seeing boat for summer tours along the Mississippi River. The following information is available: Cost of boat $500,000 Service life 10...
-
Construct a 90% confidence interval for the population mean in Exercise 1. Interpret the results. Data from Exercises 1 The systolic blood pressures (in mmHg) of 40 persons are shown in the table....
-
What methods are used in (a) the preliminary review and (b) the completion of the review.
-
Della Bee Company purchased a manufacturing plant building 10 years ago for $1,300,000. The building has been depreciated using the straight-line method with a 30-year useful life and 10% residual...
-
Assume that today is January 1,2017. The rate of inflation is expected to be 4% throughout 2013. However, increased government deficits and renewed vigor in the economy are then expected to push...
-
Amazon Wood Products, Inc. is a manufacturer of fine quality tables, chairs, and desks. The following information relates to expected production, sales, and other costs for next year (ended December...
-
Explain how Antiduretic hormone regulates osmotic potential in the body
-
On 21 March 2022, Penny is made redundant by her employer. She receives statutory redundancy pay of 4,750 and an ex gratia compensation payment of 32,000 (none of which ranks as a PILON). Her only...
-
Under the current year basis, for which tax years would the following accounting years form the basis period? (a) year to 31 October 2021 (b) year to 31 March 2022 (c) year to 30 April 2023 (d) year...
-
Throughout 2021-22, Niall is provided by his employer with a diesel-engined motor car which had a list price when new of 24,200. The car was registered in January 2021 and has an emission rating of...
-
Which of the following forms of income from employment would be exempt from income tax in tax year 2021-22? (a) Free meals in the company canteen. (b) Removal expenses of 4,500. (c) 1,000 given to an...
-
Malcolm's gross annual salary is 57,500. He is also entitled to an annual bonus which is based on his employer's profits for the previous calendar year. His bonus for the year to 31 December 2020 was...
-
RULE 1: Self-Check Filing Segment a. b. Latasha Gregory Edward Simmons i. Thi Dien Personnel, Inc. C. d. Greg Simmons Car Company Albert Brown Suit Shop Elbert Albert j. e. f. 9. Thi Dien h.T.F....
-
Find the numerical value of each expression. (a) sech 0 (b) cosh -1 1
-
(a) During 2006, Jack Matelot set up a company, JTM, to construct and refurbish marinas in various ports around Europe. The companys first accounting period ended on 31 October 2006 and during that...
-
The following are the financial statements of White and its subsidiary Brown as at 30 September 20X9 The following information is also available: (i) White purchased its ordinary shares in Brown on 1...
-
In the year to 31 December 20X9, Amy bought a new machine and made the following payments in relation to it: Required: (a) State and justify the cost figure which should be used as the basis for...
-
Explain how creating a process map and internal threat analysis helps in determining the extent to which substantive testing is to be performed on the accounts associated with the supply chain and...
-
Consider the purchases function of a manufacturing company. To overcome a downward profitability trend, management recently instituted a "just-in-time" system of acquiring raw materials for its...
-
Testing for unrecorded liabilities involves vouching a sample of disbursements made after fiscal year end to determine whether the underlying liabilities for the disbursements were recorded at the...
Study smarter with the SolutionInn App