**Class Project Description: Creating a Simple Table in MySQL**

In this hands-on project, you’ll learn how to create a basic table in MySQL, focusing on designing a table structure with appropriate data types. You’ll create a table named `countries` to store essential data, such as country IDs, country names, and region IDs. This project will strengthen your understanding of table creation and data organization in SQL databases.

Project Steps:

Set Up Your MySQL Environment:
- Ensure you have MySQL installed and set up. If you’re using a local MySQL server, open the MySQL command line or a MySQL workbench application.
Connect to Your Database:
- Start by connecting to your database or creating a new one for practice
Create the countries Table:
- Write a SQL query to create a table named countries with three columns: country_id, country_name, and region_id. Specify appropriate data types for each column:
  - In this query:
    - country_id: an integer column designated as the primary key to ensure each entry is unique.
    - country_name: a string column with a maximum length of 50 characters.
    - region_id: an integer column to categorize countries by region.
Run the Query and Verify the Table Structure:
- Execute the query and then use the following command to check the structure of your new table:
- This command will display the table columns, data types, and constraints to confirm they were correctly set.
Document Your Query and Results:
- Copy your query and the output of the DESCRIBE command. Take screenshots if you’re using a MySQL workbench, or copy the results if using the command line.
Final Submission:
- Compile your SQL query, the DESCRIBE output, and an explanation of each column’s purpose in a Word or PDF document. Include any challenges you encountered and how you resolved them.

Final Submission:

including screenshots of your MySQL Code , and document your personalized configuration in a Word or PDF file. Include explanations for each customization choice.
Table Structure Verification: Provide the output of the DESCRIBE countries; command.
Documentation: Briefly explain each part of your SQL query and the purpose of the table design.

Project Benefits: Completing this class project will empower you to:

Develop skills in table creation and defining column properties in MySQL.
Understand the importance of primary keys and constraints for data integrity.
Gain experience with SQL commands to design and describe table structures.
Build a foundation for organizing and managing data in relational databases.

By the end of this project, you will have successfully created a simple, structured table, which is a key step in mastering database management with MySQL.

Megan Stokes

--

2