Convert an ER Diagram into an Temporal ER diagram

$10-100 USD

已完成

已发布

超过 8 年前

$10-100 USD

货到付款

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: 9108709

关于此项目

3提案

远程项目

活跃8 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@vishaltile

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

$89 USD 在2天之内

5.0

(4条评论)

2.6

3威客以平均价$93 USD来参与此工作竞价

@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天之内

4.9

(33条评论)

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天之内