Question 3: (30 points) A multinational software company keeps its worksheets in the following spreadsheet. A number of
Posted: Thu Jul 14, 2022 2:06 pm
Question 3: (30 points) A multinational software company keeps its worksheets in the following spreadsheet. A number of anomalies show up. Normalization is needed. Staff currency: currency of the staff country IT Staff rate: staff hourly payment in his/her local currency Staff currency rate: against the Euro Hours: worked by that staff on the specific project Total Due Local: The hours * Staff rate Total Due Euro: Total Due Local / Staff currency rate Decompose into a number of 3NF tables.