Deloitte Procurement Fraud Case Study - YourTech

Question

Hi everyone,
Does anyone have the solution for Deloitte's YourTech procurement case study? Would appreciate if someone could explain it too.

Technology Innovation-Database (30%): o The company is using excel and want to embrace into database (access), design a database for the procurement system for this company. You have to plan and decide what kind of possible queries that the managements need.
o Your design should also consider any potential data mistake hence set the control to prevent the errors. Write down the summary of the advantageous using your design and show that your database is working by converting the excel dataset to access db. If you need to create additional “mock” data, please write down on your report and submit your final excel dataset.
o Create 10 potential queries and the syntax of each of the queries. For example: Who is the biggest supplier that have business with this company?
o Design one database form for the company if there is a new supplier

Answer 1

Hi there,

I spent 4 years IT Consulting experience and have designed and built multiple large-scale databases (some at more than 100 tables). Feel free to reach out for support here.

This can't be answered in a Q&A.