I will design a relational database, er diagram and mysql script
IT and Data Specialist, Content Writer
About this Gig
Need a clear, well-structured database for your app, startup or project? I design relational databases from the first idea to a working MySQL script.
WHAT YOU GET (depends on the package)
ER diagram (ERD) with entities, keys, relationships and cardinalities
MySQL script with primary and foreign keys, UNIQUE and CHECK constraints, ENUMs and indexes
Sample data and example SQL queries
Short documentation with the reasoning behind key design decisions
HOW I WORK
I ask the right questions first, then model, then test the script on a real MySQL server, so what you receive actually runs.
PORTFOLIO EXAMPLE
A taxi dispatch database with customers, orders, drivers, vehicles, payments, reviews, order history and GPS tracking. See the portfolio images.
TO START
Send a short description of your system, who will use it and what data it must store. Not sure which package fits? Message me before ordering.
Database type:
Centralized database
•
Relational database
Platform:
MySQL
•
Oracle
•
PL/SQL
•
PostgreSQL
Expertise:
Design
•
ERD
•
Normalization
•
SQL
My Portfolio
FAQ
What do I need to provide to start?
A short description of your system, who will use it and what data it needs to store. Existing diagrams, spreadsheets or sample documents are a bonus.
Which databases do you work with?
MySQL is my main focus, and every script is tested on a real MySQL server before delivery. I can also work with PostgreSQL and Oracle. Please message me first so we can agree on the scope.
Will the script run without errors?
Yes. I run every script on a real MySQL server before I deliver it.

