MySQL database design, impelmentation and 15 SQL queries
€30-250 EUR
Paid on delivery
Looking for SQL Database Designer
We are building athlete management system (AMS) using MySQL database. We have some basic structure ready for the information. Next we would need MySQL database designer to complete next tasks:
1) DESIGN DATABASE, TABLES AND CONTENT (MySQL)
2) BUILD SCRIPT TO CREATE DATABASE
3) HELP FILLING TEST DATA TO CRETED DATABASE
4) CREATE 15 SQL QUERIES TO GET RESULTS FROM DB
1) DESIGN DATABASE, TABLES AND CONTENT (MySQL)
-------------------------------------------
Tables are (estimation and/or draft)
01) Organizations
02) Athletes
03) Users
04) User roles (support table for Users)
05) Organization types (support table for Organizations)
06) Teams
07) Training modules
08) Module categories (support table for module categories9
09) Training program
10) All tests
11) Test log
NOTE: There might be need to re-define these and add more data and/or information.
2) BUILD SCRIPT TO CREATE DATABASE
-------------------------------------------
For building database structure for example to Google Cloud is quite simplete, but needs to be done.
3) HELP FILLING TEST DATA
-------------------------------------------
There needs to be test data in the databases to get thing tested. Test data will be provided at .xls (Microsoft excel format).
4) CREATE 15 SQL QUERIES TO GET RESULT
-------------------------------------------
After database is created, there needs to be verified results go get information from database. Next 15 SQL queries needs to be completed.
1 Create new club to the system
2 Update club information to the system
3 Suspend club activities by turning club status from active to deactive
4 Activate club by turning club status from deactive to active
5 List all clubs from the system with the status of the club
6 List all clubs from the system with the status of the club and club managers
7 List all system admins from the system
8 Create new administrator account to the system
9 Suspend administrator account by changing administrator account from active to deactive
10 Register new uses to the sytem
11 Verify user login
12 List all roles at different clubs for one user
13 Create new training module
14 List all trainings at calendar for defined athlete
15 List all trainings what athlete has done during past month
PROJECT MANAGEMENT & GUIDELINES
- We only use Freelancer.com. Other requests will automatically rejected
- We only provide payment after tested end results. No upfront payment
- We can create account to the MySQL which is created to be able to set up the db
Project ID: #27799705
About the project
Awarded to:
Hello employer, I would like to bid for your project work pertaining to database design and SQL queries. Here is my linkedin profile: [login to view URL] I am data engineer and worki More
28 freelancers are bidding on average €168 for this job
Hello, I am a MySQL expert. I read the job description carefully and complete the 15 queries. I can design the database well. I can start immediately. Looking forward to hearing from you. Thanks.
Hello, I am ready to discuss project with you. Being experienced in designing and writing scripts for database creation, manipulation and SQL queries based on different complexities in the project, based on that I ca More
I m a database administrator with 9 years of experience in this industry. I read your project details and I understood your needs ,I can create the athlete database and also queries you want in the deadline just conta More
I can efficiently implement all described stages. I am Senior SQL Developer with 10+ years of exceptional experience. I have a highly advanced expertise in database design, development, troubleshooting and performance More
Hello, I have read the job description and I am interested in this job. I can create this database with the queries you need. I need to know the purpose of the tables to be created so that we can decide more tables ar More
hello I'm an expert web developer, I have read your job description and I'm ready to help you create this script with PHP Mysql Please feel free to contact me Regards
ReactJS,Angular,Ionic, wordpress , mysql DatabaseExpert. Hi, I am a web professional developer who has rich experience in Frontend (React JS/Redux/Vue/Angular/Bootstrap/CSS/HTML/SEO) and backend (PHP, Nodejs, ) for mor More
Hi Client, I have experience working database design and writing complex queries in MySQL. I can help you with this task. please reach out to me on chat we can discuss further details. Thanks. Regards, Vinod
Hello, my name is Elom, i am I am core SQL Server Production DBA. My background: - strong knowledge of relational databases, skills in SQL query design and development. - 5+ year of experience leading own projects. - 5 More
1) DESIGN DATABASE, TABLES AND CONTENT (MySQL) ------------------------------------------- Tables are (estimation and/or draft) 01) Organizations 02) Athletes 03) Users 04) User roles (support table for Users) 05) Orga More
How are you?? Sir I am a professional Php/Laravel developer with a years of good and professional experience both on and off the market. I mostly work in vue + Laravel and Wordpress. I also develope investory web app More
Hi, there I checked your project description carefully, and i am sure I can do it my database programming is dynamic database design and management. so I can complete your project perfectly as you want. Please message More
Hi! I have a solid experience in database development (MSSQL, MySQL). Ready to start. Thanks.
I have over 25 years of experience as Software Solution Architect responsible for the design of large applications. I can fulfill all your requirement. Let us have a discussion to take this forward. skype nk_sundaram w More
Hy, i have gone through your requirements and can complete this as soon as possible .IM MPhil in Computer science and DB Designer and developer by professional. i have been working on DB development (MySQL,Oracle,Sql More
Greeting, Hope you are doing well, as I had have over 7 years of experiences on the database development, I am assure that will deliver this project in time with met all requirements. Many thanks and best regards, S More