Gig Overview: You are provided with 2 links to UI designs (figma file) for a Legend Academy User and

Admin profiles. Legend Academy is a Academy is an online learning platform that uses technology to revolutionise learning and empowers individuals with digital skills to thrive in the 4IR and beyond.  You are to design a secure and scalable database schema to store the information on the UI.

Expertise: Back- End Development, Database Schema Development

Required Skills: Proficiency in MySQL and database design are required to participate in this project.

So

- DBMS: MySQL

Gig Description:

● Task

○ Analyse the data requirements and design tables that capture all necessary data fields.

○ Define data types, relationships, and constraints for all tables:

● Deliverables:

○ Database schema design document (ERD) with tables, fields, and relationships clearly

defined.

○ SQL scripts to create and populate tables for testing.

○ Documentation explaining the schema, data types, relationships, and constraints.

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 and follow our

brand guidelines.

Resources:

https://www.figma.com/design/42RDsiVmyiVtMwAVzVZS0d/Final-LMS-User-Web?node-id=2032-

4900&t=roym7iRgOWqwILzd-1

https://www.figma.com/design/VJGTXNEReerJIwU1Sl40Tr/Final-LMS-Admin?node-id=2008-8955

&t=PCTrt3zARNjiR8JB-1