Convert an ER Diagram into an Temporal ER diagram

$10-100 USD

Concluído

Publicado

há mais de 8 anos

$10-100 USD

Pago na entrega

Review the pdf documents attached. Use the theory (specifically what is covered between slides 4-24 to 4-63) to convert the provided ER Schema into a temporal ER Schema. Every decision needs to be DOCUMENTED: Phase I Start with Temporal Normalization (start with identifying time variant vs. time invariant entities, attributes, relationships and why then normalize). What Time Domains you are going to be using and their definitions (event time, transaction time, etc.), what is the your Chronon for each temporal element and why, State or Event modeling for each temporal element and why, instant or interval timestampings where and why. Phase II Grouping of time-variant attributes (temporal denormalization). Examine the Lifespan of your objects and determine if you are having any Parallel Histories. The project file attached has the ER diagram and was created in SQK Workbench

Database Administration

Database Development

ID do Projeto: 9108709

Sobre o projeto

3 propostas

Projeto remoto

Ativo há 8 anos

Quer ganhar algum dinheiro?

Endereço de e-mail

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo

Seja pago pelo seu trabalho

Descreva sua proposta

É grátis para se inscrever e fazer ofertas em trabalhos

Concedido a:

@vishaltile

we are sql professionals and can deliver in less time . so please let us know if we can help you .

$89 USD em 2 dias

5,0

(4 avaliações)

2,6

3 freelancers estão ofertando em média $93 USD for esse trabalho

@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

$111 USD em 1 dia

4,9

(33 avaliações)

5,0

@vipul102

1. 3 year of extensive experience in Database(modelling, creation) 2. Rich experience in writing complex SQL queries to create tables, views etc. 3. Extensive experience in writing PL-SQL queries for procedures, functions etc. 4. Completion of task on or before time. 5. No compromise policy with quality of work. 6. High preference for customer satisfaction.

$80 USD em 2 dias