Essay on Databases
You are tasked with data model design for a fast-food chain internal system. You gathered every accessible fact on food and drinks it sells, sale points, food preparation process and inventory management. CIO mentioned rumors on MongoDB superiority (which store data in JSON documents instead of tables) over old relational databases and asked, how do you plan to store data – normalized or not.
Write a paper (up to 2 pages) on relative strengths and weaknesses of relational data modelling in normalized tables for this project. Why do you prefer normalization? Why do you prefer denormalization? Which use cases became possible/impossible/quick/slow due to which properties of both ways?