questions for database design for data analytics

€10-30 EUR

En curso

Publicado

hace más de 7 años

€10-30 EUR

Pagado a la entrega

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 ?

ID del proyecto: 11351113

Información sobre el proyecto

6 propuestas

Proyecto remoto

Activo hace 8 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@point5nyble

Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: • Expert in SQL Server, Oracle and MS Access Databases • Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) • Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools • Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling • Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. • Basic knowledge of Unix Shell scripting • Web Development using Java, CSS, and HTML ,PHP & Java Script • Expert in excel Macro • Expert in C & C ++ Programming I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14. We recently started our own company “Point5Nyble Your Needs, Our Dream”. We always work to provide Best Delivery with 100 % customer satisfaction Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Ashish-Point5Nyble

€30 EUR en 1 día

4,8

(27 comentarios)

4,9

6 freelancers están ofertando un promedio de €33 EUR por este trabajo

@it2051229

hi there. I went through the requirements and I would like to do this project if given the opportunity. let me know if you are interested.

€50 EUR en 1 día

5,0

(57 comentarios)

5,2

@rashmisingh2990

I am database expert having experience of 3 years.I will complete your work as per requirements and deliver it on time.

€30 EUR en 1 día

4,8

(7 comentarios)

3,2

@biobee

With 6 years plus experience, I stand to be a professional at writing - business academics, literature-related analisis, IT-related academic, engineering, articles, business plans, content writing, blogging, excel, data entring, among others. I love to write blog articles, technical writing, news, Facebook Posts, comments and everything else which you need

€12 EUR en 1 día