Part A - 1000 words
1/ Produce Conceptual Data model for a scenario of a company. Use either the extended Crow’s Foot notation or Chen’s notation but do not mix the notations (i.e. use either one or the other but not both). Use any design tool that you feel most familiar with (i.e. Visio)
2/ Produce a Logical Data model for a scenario of a company. Carry out normalisation to 3rd normal forms and discuss the progression through 1st, 2nd and 3rd normal forms. This mapped model also should additionally include all attributes and foreign keys.
3/ Under what circumstances would you denormalise you data model. Give an example from the the scenario of ABC Ltd.
4/ What were the problems you encountered and how you endeavoured to solve them.
1000 words for Part A
Part B - 800 words
What are the most appropriate Data model to use for the above scenario. Evaluate whether this application should be built on Relational Database, or on NoSQL Database, Document Data model. What are the advantages and disadvantages of each solution using approximately 800 words for this part.