Database Design Jobs

I have a Sage 50 (Canadian edition) company that stores its data in MySQL-style *.frm files. After repairing corruption outside of Sage, all tables now exist only as clean exports—both *.sql dumps and matching *.csv files. My challenge is getting that data back into the working Sage50 MySQL repository so the program will recognise the company and let me complete the fiscal year-end rollover. I would like this project completed as soon as possible. Here’s the current state: • Schema files: original Sage-generated *.frm files still sitting in the data folder. • Data files: full content available in *.sql and *.csv formats. • Problem: attempts to re-import keep failing because Sage50 expects its exact table structure, indexes, triggers and constraints. Error...

CORE-103 Data & SQL Foundations. 10 topics. Almost every system these students build or support will store its data in a relational database, and almost every serious production incident involves one. From what a database is for through querying, joins and aggregation to schema design, transactions and indexing. Real time goes to reconciliation - checking that a query returned the RIGHT answer rather than a plausible one - because a wrong number delivered confidently is worse than no number at all. Note: this course shares ground with DB-101, the Databases track foundation, at a much shallower depth. You will be asked to coordinate with that trainer so the two reinforce rather than repeat each other. THE 10 TOPICS — FIXED 1. What a database is for (6 h) - persistence, con...

Develop a chess website & app 1. PROJECT SUMMARY Kings For Chess will be developed as a complete online chess platform for Website, iOS and Android, built with a scalable architecture and designed to support the client's long-term vision. The project will include the following major components: ● Online competitive and casual chess ● Chess games against bots ● Standard and Advanced Post-Match Analysis ● Stockfish-powered chess engine ● AI Chess Coach and player improvement insights ● Comprehensive tournament system ● Chess variants including; game 1: EV Chess (No check nor checkmate) and game 2: Draw-Penalty Chess (lower ranked player gains greater points while the higher ranked player loses more points) ● Player profiles, ratings, rankings and statistics ● Puzzle (import from L...

MVP Build — Quote Request We're looking for a freelance developer or small team to quote an initial MVP build. This is a rough-scope request to get a ballpark quote — not a full technical spec. Additional phases/tiers will be scoped separately once we're underway. What we're building (high level) A web platform that connects to third-party business software a client already uses (accounting/ERP-type systems, CRM/marketing platforms, etc.), pulls their data into a secure cloud environment, and gives the client a simple portal to log in and view/query that data — including an AI-assisted question-answering feature over their own data. Core skills required Backend development (Node.js/Express or equivalent) — building and hardening API routes, workin...

My MySQL 5.5.18 instance is limping along after a corruption event—system tables open, but every InnoDB table throws errors. The server is only “partially functional,” so I have powered it down and kept all data files intact (ibdata, ib_logfile*, .frm, .ibd, relay/binlogs, ). Remote log-in isn’t possible; you will need to walk me through everything step-by-step while I work directly on the box. What I need is a complete, reliable FULL backup of every database, including the damaged InnoDB tables, so I can spin up a fresh 5.7+ server later. I am comfortable following detailed terminal commands; I just need an expert plan and real-time guidance to: • Mount the data directory in a safe environment (ideally using Percona XtraBackup, mysqlbackup, or a comparable t...

I need an end-to-end iGaming solution aimed at the Chinese-speaking market. The job covers both the customer-facing front end and the operational back-office. I can provide URLs and credentials to our current sites so you can mirror the best features that already exist in the industry. Front-end scope • Build three responsive templates: Sports Betting, Casino Games, and Poker Room. • Each template must support live streaming, user profile pages, and full multi-language toggling (with Chinese as the default locale). • Templates should share a component library so future skins can be added quickly. Back-office scope • User management (KYC workflow, role/permission matrix, player segmentation tools). • Payment processing that accommodates common Asian gateways...

I need a solid PostgreSQL-backed RESTful API to drive the Solar TwinPro web application. Your task is to design the database schema and expose clean, versioned endpoints that cover full CRUD functionality for each core resource in the system. The web front-end will consume JSON, so consistent status codes and clear error handling are important. Please structure the project so it can be deployed easily (Docker preferred, but I am open to other simple approaches) and include concise documentation; an OpenAPI/Swagger spec is ideal so the front-end team can plug in without guesswork. Deliverables • PostgreSQL schema (DDL) and seed data • REST endpoints covering create, read, update, delete for all defined entities • Environment and run instructions (e.g., Dockerfile or...

I need a cloud-hosted CRM built from the ground up for a growing laundry franchise. The core priority is robust multi-store franchise management, so every branch can operate independently while still feeding real-time data to head office. Key workflow: • Each store logs in through its own portal to record orders, update statuses, and see today’s targets. • A live sales dashboard rolls those numbers up instantly so I can compare performance across branches from any browser or mobile device. Billing & invoicing must be friction-free. The system should generate fully customizable invoices that reflect our branding and service codes, then trigger automated payment reminders until a balance is cleared. From the central admin console I want the power to: • Add or ...

I need a complete, production-ready accounting system built from the ground up for small-business use. The core of the application must revolve around an intuitive cashbook, with seamless links to the General Ledger, Accounts Receivable/Payable, and an automated Bank Reconciliation workflow. Beyond day-to-day entries, I expect a solid reporting engine that can quickly generate the standard financial statements small companies rely on—think balance sheet, income statement, cash flow, and any custom summaries management may request. While those reports weren’t pre-selected in the questionnaire, please architect the platform so adding or modifying report templates is straightforward. The flow I have in mind: • Transactions land in the cashbook → post to the GL in...

Industrial AI Integration Platform – ERP & Manufacturing Systems Connectivity If your work rate is not 2-3$ per hour, please don’t apply!!!! Project Overview We are developing an advanced industrial software platform focused on improving operational efficiency within manufacturing environments. We are looking for an experienced developer/architect who can help us build the integration layer between our platform and existing enterprise manufacturing systems. The project involves connecting our solution with widely used industrial software ecosystems, enabling secure data exchange, real-time communication, and scalable integration with different production environments. This is a long-term and strategically important project for us, and we are looking for someone who und...

I’m working on a university assignment that calls for a fully-functional Microsoft Access (.accdb) database. The scenario revolves around three core entities—Products, Customers, and Orders—so those will be the three related tables, each with its own primary key and enforced referential integrity. I already have partial field lists in mind but need a bit of guidance on tightening data types and any additional fields that would make the relationships robust. The assignment requirements are straightforward: • Three related tables (Products, Customers, Orders) with primary keys and proper relationships • 15–20 sample records in every table • At least two meaningful queries that demonstrate the relationships • One clean data-entry form for da...

**Project Title:** Complete Cab Booking App (Customer, Driver & Admin) I am looking for an experienced mobile app developer or development team to build a production-ready cab booking solution for Android and iOS. The project should include three separate interfaces connected to a single secure backend: **Customer App** * User registration/login * Book a cab * Real-time driver tracking * Ride scheduling * Secure in-app payments * Ride history * Push notifications **Driver App** * Registration and verification * Accept/Reject ride requests * Live GPS navigation * Trip management * Earnings dashboard * Availability (Online/Offline) **Admin Panel** * Dashboard with real-time ride monitoring * User & driver management * Fare management * Analytics and reports * Payment & tr...

I am looking for an experienced full-stack PHP developer or development team to build a modern, secure, and scalable web platform similar to VoteNaija, but with significantly more features. The platform will allow organizers to create voting contests, sell event tickets, reserve VIP tables, sell music, and manage everything from a single dashboard. The system must be professionally developed, responsive, SEO-friendly, secure, and optimized for high traffic. # Preferred Technology * Core PHP 8.x (or Laravel if justified) * MySQL / MariaDB * HTML5 * CSS3 * JavaScript * Bootstrap or Tailwind CSS * jQuery/AJAX * REST API * Paystack Integration * Flutterwave Integration * QR Code Generation * GitHub Repository * cPanel Deployment Main Features 1. User Management * User Registration * Lo...

I need a web developer who can create a site that functions very much like the core of the project is a loyalty program, not a traditional e-commerce storefront. Members must be able to earn and redeem rewards seamlessly, with referral rewards generated after each completed transaction, just as we discussed. Here is what I expect to see: • A clean, responsive front end that mirrors the smooth user flow of the reference site. • A loyalty engine that supports my preferred “repeated” reward style, so customers keep accumulating benefits the more they interact. • Automatic referral crediting on every successfully finished purchase or service transaction. • An intuitive admin dashboard where I can monitor points, referrals, user tiers and adjust reward r...

I need a well-structured database focused on storing customer details for my company. I have not locked myself into any single platform, so I’m open to either a traditional SQL solution (MySQL, PostgreSQL, SQL Server) or a NoSQL option (MongoDB, Firestore) if you can explain why it’s the better fit. Scope of work • Analyse my current customer information flow and recommend the most suitable database architecture. • Design the schema to hold core customer data—at minimum names, phone numbers, and email addresses—plus space for additional fields such as purchase history or demographic insights that we may add later. • Build the database, populate it with a small sample dataset, and document the structure. • Provide clear instructions (or sim...

Manejo una solución en Claris FileMaker Pro llamada ServiTech y necesito refinarla cuanto antes. El trabajo incluye: • Formularios: agregar nuevos campos, modificar campos existentes y ajustar la impresión para que cada layout salga limpio y alineado. • Campos relacionados y validaciones: asegurar que las nuevas estructuras se integren sin romper los scripts actuales. • Órdenes de trabajo y reportes: revisar los layouts vinculados, optimizar el flujo de datos y garantizar que los formatos de salida (PDF/impresión) reflejen los cambios anteriores. Trabajo 100 % remoto, aunque es ideal que residas en Chile para facilitar la coordinación horaria y, de ser necesario, una reunión presencial puntual. Si dominas FileMaker Pro, env&ia...

Saya memerlukan sebuah database terstruktur untuk merekam Kegiatan Pelaksanaan dan Pengeluaran Biaya di lapangan. Fokusnya sederhana—saya cukup bisa memasukkan data harian, lalu menarik laporan ringkas kapan saja. Lingkup pekerjaan: • Rancang skema tabel yang memuat minimal: tanggal kegiatan, deskripsi singkat pekerjaan, nama petugas, rincian biaya, serta kolom lampiran (foto/bukti). • Buat antarmuka input yang mudah diisi—boleh berbasis Excel, Google Sheets, atau aplikasi database ringan seperti Airtable; pilih solusi yang cepat saya pelajari. • Sertakan filter dasar dan template laporan (mis. rekap mingguan/per bulan) agar saya dapat melihat total biaya serta daftar kegiatan secara real-time. • Lengkapi dengan panduan penggunaan singkat agar tim lap...

Saya ingin membangun sebuah aplikasi akuntansi berbasis desktop yang fokus pada pengelolaan gaji karyawan di perusahaan teknologi dan mampu meminimalkan potensi penipuan (salary scam). Gambaran singkat • Platform: desktop software (Windows diutamakan, cross-platform akan menjadi nilai tambah). • Lingkup: modul payroll lengkap—perhitungan gaji pokok, lembur, tunjangan, potongan, pajak; pencatatan jurnal akuntansi otomatis; serta dashboard audit internal untuk mendeteksi anomali pembayaran. • Fitur kunci: – Login berbasis peran (HR, Finance, Auditor). – Enkripsi data sensitif dan rekam jejak aktivitas pengguna (audit trail). – Ekspor laporan keuangan bulanan dan tahunan dalam format PDF/Excel. – Integrasi opsional dengan A...