Database Design: ERD Review or Creation
Project details
We are designing the database behind the app described in BringBizBack.com. We are designing a database for MySQL 8.0 using the Entity Relationship Diagram (ERD) tool We need an expert at database design. Look at our design and help us eliminate mistakes and optimize it. Perhaps if what we have now is really bad you just need to remake it from the beginning. We can give you access to our LucidChart ERD but we’ve attached what we have currently. But we want you to finish the design ASAP. We want to do what is the best and most common way to do things using ISO standards if possible.
In particular:
1. Did we create the best tables (entities)?
2. Did we create the best fields to collect or do we need more/less?
3. Did we label fields correctly?
4. Help us label the data types of the fields correctly.
5. Are the links correct (ordinality/cardinality)?
Three ways to win our bid.
A. Reply FAST. Now.
B. Give a GOOD FIXED PRICE for finishing this job. Not hourly. If your price and quality are really we will probably give you more business. Hiring people is hard so we stick with good people.
C. If we work well together we will probably want to work with you more but DON’T TRY TO CHANGE our bid into some other project like building the whole app. We will bid that separately, maybe. Just bid on building our ERD/Designing our database.
Awarded to:

Ievgen T.
(5.0)
Awarded to:

Ievgen T.
(5.0)
Project details
In particular:
1. Did we create the best tables (entities)?
2. Did we create the best fields to collect or do we need more/less?
3. Did we label fields correctly?
4. Help us label the data types of the fields correctly.
5. Are the links correct (ordinality/cardinality)?
Three ways to win our bid.
A. Reply FAST. Now.
B. Give a GOOD FIXED PRICE for finishing this job. Not hourly. If your price and quality are really we will probably give you more business. Hiring people is hard so we stick with good people.
C. If we work well together we will probably want to work with you more but DON’T TRY TO CHANGE our bid into some other project like building the whole app. We will bid that separately, maybe. Just bid on building our ERD/Designing our database.
skills of Ievgen T.
skill ? | level ? | projects ? | ||
---|---|---|---|---|
SQL |
45%
|
46 | ||
Database Administration |
39%
|
15 | ||
Microsoft SQL Server |
39%
|
31 | ||
Database Design |
39%
|
8 | ||
Database Development |
39%
|
8 | ||
Database Programming |
39%
|
8 | ||
MySQL |
36%
|
23 | ||
Database Management |
36%
|
1 | ||
ASP |
35%
|
8 | ||
ASP.NET |
35%
|
8 | ||
PHP |
34%
|
8 | ||
Microsoft |
34%
|
1 |
Some Ievgen T. projects
Project Title | Skills required in the project |
---|---|
MySQL statements | MySQL SQL |
MySQL Table CREATE ALGORITHM (joins) issue | Database Administration MySQL SQL |
Script or utility to export/extract files from varbinary(max) column in SQL | Microsoft SQL Server SQL |
Project in SQL — 2 | Microsoft SQL Server SQL |
Help with small update script | Microsoft SQL Server SQL |
RedGate migration script to migrate data from table in one db to table in another db | ASP ASP.NET Microsoft SQL Server PHP SQL |
optimize a complex mysql query | Database Administration MySQL |
Convert HyperSQL database to SQLite | Database Design Database Development Database Programming |