is a talent-exchanging network. More »
Join the TribeStart with 50 after offering a service.

Database Design and Help Querying

40


40 per unit - Virtual OK - Posted Sep 18, 2017

I will design a relational database schema for you based on your requirements and teach you how to do some basic queries on it if you're unfamiliar with database systems. It will be implemented in Third Normal Form to reduce redundancy of data and avoid issues with data modification later down the road.

You will need to provide a description of the desired database (the more descriptive the better) with the information that you would like to be able to retrieve or calculate. Maybe you want to store usernames, but you want to ensure that they have a max length of 24 characters. That's an example of a useful piece of information to provide.

What you will get:
A relational model and table for visualization
A text file explaining the architecture and different constraints
A file that builds the tables for you using an SQL flavor of your choosing
Optionally I can create some queries for you (up to 5) or teach you how to query it yourself.

If you have questions about the structure of the database in the future after my job is done, I will be available to answer questions. Any further modifications outside of specifications originally given by the client or questions about a database other than the one I created would require an additional fee.

Training & Qualifications


I am currently a senior Computer Science student in the US, preparing to do a masters with specialization in Information Systems. I have experience with MySQL and Oracle as well as embedded database systems with Java.

Availability & Preferences


Early mornings and evenings (EST)

Trading Preference: I’m flexible, just hit me up!

Recommendations


Join the TribeStart with 50 after offering a service.