Adding Constraints to the Course Schedule

Introduction

In this project, you will learn how to add constraints to the course schedule in a database. Specifically, you will learn how to add a check constraint to the course table, ensuring that the credits field value is greater than or equal to 3.

🎯 Tasks

In this project, you will learn:

• How to start the MySQL server and import a database
• How to add a check constraint to a table in the database
• How to run a SQL script to apply the constraint

🏆 Achievements

After completing this project, you will be able to:

• Understand the importance of adding constraints to a database schema
• Implement check constraints to enforce data integrity
• Apply SQL scripts to modify the structure of a database