questions for database design for data analytics

1 (A) - explain the following , giving the derails of its role and purpose - online transaction processing system operation data store data mart clearly distinguish the differences between them - (B) you have been employed by a stock market investment company to design a dimensional model to represent and analyse their trading behavior use the following 5 steps of the process defined by ralph kimball, listed below , to the design your dimensional model : 1 - define the process 2- define the grain 3- define the dimension 4- define the facts 5- define the pre-calculated fields (c) explain what a snowflake schema is . show how the dimensional model developed in your answer to part (b) can be expanded into a snowflake schema . 2 (a) Draw an ER diagram you for a mobile phone text messaging application, your diagram should represent the date for sending and receiving of multiple pictures and video within the same message. (b) extend the ER digram you developed in your answer for part (a) to allow for multimedia type messages . These will include the sending and receiving of multiple picture and videos within the same message. (c) explain the suitability and practicality of using a database fir the text messaging application on a mobile phone ? (d) explain what is meant by a primary key of an entry. Explain how it is related to a foreign key on a different ?