Gig Overview:

The goal is to design a robust and scalable database architecture schema for a Learning Management System (LMS). The system is divided into the following core modules:

-Course Management: Structure for courses, lessons, content, and schedules.

-User Management: Tracking user profiles, roles, and progress.

-Authentication and Authorization: Role-based access control with secure user authentication.

-Certificates: Issuance and validation of course completion certificates.

-Quizzes: Configurable quizzes for knowledge assessment.

Microservice Architecture: 

These modules are going to be service oriented architecture driven and what this means is that they are going to be decoupled and built differently, but still remain connected to each other with field(s) that will be used to make appropriate calls from these services whenever data is needed from them. You need to have in mind that microservice architecture will be represented as stated below:

-Course Management Microservice Database

-User Management Microservice Database

-Learning Management Microservice Database

-Certificate Management Microservice Database

-Quizz Management Microservice Database

Expertise Required:

-Backend Developer: Strong backend development skills to ensure schema integration with application logic.

-Database Administrator: Proficiency in optimizing and managing relational databases.

Required Skills:

-MySQL Schema Design: Deep understanding of relational database principles and MySQL best practices.

-Normalization and Optimization: Expertise in designing normalized and performance-efficient schemas.

-Database Relationships: Ability to design one-to-many, many-to-many, and hierarchical relationships effectively.

-SQL Proficiency: Crafting complex queries and stored procedures.

Software/Design Requirements:

-Database Management System: MySQL.

Expectations: As a Techo chosen to participate in this gig, we have some expectations.

-Timely Completion: complete each gig within the given timeframe. If the gig has not been completed within this frame, the project will be re-assigned.

-Communication: Stay in touch with the Community Manager for guidance, support and feedback throughout the project. This can be done through the chat box in the My Gigs section underneath the gig description.

-Work-Ethic Alignment: Make a concerted effort to comply with our standards.