questions for database design for data analytics

€10-30 EUR

Đang triển khai

Đã đăng vào

hơn 7 năm trước

€10-30 EUR

Thanh toán khi bàn giao

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 ?

Mã dự án: 11351113

Về dự án

6 đề xuất

Dự án từ xa

Hoạt động 8 năm trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

Đã trao cho:

@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 trong 1 ngày

4,8

(27 nhận xét)

4,9

6 freelancer chào giá trung bình €33 EUR cho công việc này

@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 trong 1 ngày

5,0

(57 nhận xét)

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 trong 1 ngày

4,8

(7 nhận xét)

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 trong 1 ngày