Convert an ER Diagram into an Temporal ER diagram

$10-100 USD

Suoritettu

Julkaistu

yli 8 vuotta sitten

$10-100 USD

Maksettu toimituksen yhteydessä

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

Projektin tunnus (ID): 9108709

Tietoa projektista

3 ehdotukset

Etäprojekti

Aktiivinen 8 vuotta sitten

Haluatko ansaita rahaa?

Sähköpostiosoite

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu

Saa maksu työstäsi

Kuvaile ehdotustasi

Rekisteröinti ja töihin tarjoaminen on ilmaista

Myönnetty käyttäjälle:

@vishaltile

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

$89 USD 2 päivässä

5,0

(4 arvostelua)

2,6

3 freelancerit tarjoavat keskimäärin $93 USD tätä projektia

@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 1 päivässä

4,9

(33 arvostelua)

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 2 päivässä