Question 3: (30 points) A multinational software company keeps its worksheets in the following spreadsheet. A number of
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Question 3: (30 points) A multinational software company keeps its worksheets in the following spreadsheet. A number of
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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!