⚙️How to use MySQL database answer environment

Introduction

Students interact with CodeChum’s coding environment whenever they answer programming items in the activities you create.

It’s helpful to encourage your students to become familiar with how CodeChum’s MySQL database environment works. Understanding how to use it effectively will help them feel more confident and prepared for upcoming database-related activities.

MySQL Database Coding Environment Anatomy

CodeChum's MySQL database environment looks like this and has the following parts in it:

  1. Item Description - Located on the leftmost side of the screen. This section displays the item name and detailed problem description.

  2. Query Editor - Located at the center of the screen, this is where students write their queries to solve the given test cases. Each test case is presented as a card, and students must provide the appropriate MySQL queries to meet its requirements.

  3. Check Code- A button located at the bottom of the query editor. When clicked, it submits the students’ queries to the system and returns a score based on the correctness of their output.

  4. Item Navigation - Displayed as a card in the top right corner. This shows all the items in the activity and enables smooth navigation between them.

  5. Test Cases - A tab on the far right side of the screen. It displays sample outputs used to determine the score. If a student’s output matches the expected result for a test case, they earn a point.

  6. Bottom Navigation - Located at the bottom of the screen. It provides “Prev” and “Next” buttons to easily switch between items.

  7. Messenger Support - Found in the bottom left corner. This feature allows your students to contact CodeChum’s Customer Support Team for any technical issues or platform concerns.

Last updated