Data Modelling and Postgres Views/Programming

Closed Posted Nov 26, 2015 Paid on delivery
Closed Paid on delivery

Design a database to log phone call metadata, and associate a given call to the owner of the phone number and also associate the phone call to a specific legal case and associate it with a specific item/billing code that is associated with rates that change. The call also has to keep a human manually added narrative.

We have the court jurisdiction reports properly formatted and working, now all we need a means to have a proper system design to store millions of phone calls and keep the associations straight.

Your job is to design the tables and associations and generally have a well thought through DB design to handle millions of records

Desired Skills Data Modeling, PostgreSQL Programming, Relational Databases, Database Modeling

Database Administration Database Programming PostgreSQL

Project ID: #8976224

About the project

9 proposals Remote project Active Jan 2, 2016

9 freelancers are bidding on average $764 for this job

rainbow

A proposal has not yet been provided

$555 USD in 10 days
(7 Reviews)
3.0
bhawin91

A proposal has not yet been provided

$277 USD in 10 days
(3 Reviews)
2.4
Onlance

Please list field types, range of values for all and expected rate of new records insertion. Likely to require more columns later? Error response on possible field error/typos in report? If possible post a samp More

$277 USD in 10 days
(1 Review)
1.0
yakubpune

WISHING YOU PEACE IN YOUR LIFE. I have more than 8 years of experience in JAVA. The breakup of experience as per best of my knowledge Web Scraping(httpClient,JSoup,HTMLUnit): 1 year 2 months. Spring2.x - 3.x : More

$400 USD in 10 days
(0 Reviews)
0.0
dzdzegc

Предложение еще не подано

$400 USD in 3 days
(0 Reviews)
0.0
pushar71

Hello I am quoting higher than your project limit because this seems like a big work, i have done more than 20 years in DB programming and database work keen to help youw ith this project , please connect with me i More

$3333 USD in 30 days
(0 Reviews)
0.0
NextGWEB

I have more then 10 years of experience in postgreysql.I will do it.

$833 USD in 15 days
(0 Reviews)
0.0
kirti1961

I am very good in database design as I can normalize the database top make it robust and processing efficient

$250 USD in 10 days
(0 Reviews)
0.0
klinesh

A proposal has not yet been provided

$555 USD in 10 days
(0 Reviews)
0.0