Research Database Constraints

Instructions:

1. Research Database Constraints:

   • Understand what database constraints are and why they are important in database management.

   • Research different types of constraints used in databases, such as:

     • Primary Key Constraint

     • Foreign Key Constraint

     • Unique Constraint

     • Check Constraint

     • Not Null Constraint

     • Default Constraint

2. Brief Explanation of Each Constraint:

   • Provide a brief explanation of each type of constraint mentioned above.

   • Discuss how they ensure data integrity and prevent invalid data from being entered into the database.

3. Example Scenarios:

   • Research and provide real-world examples or scenarios where each constraint would be useful.

   • For example, explain how a primary key ensures that each record in a table is unique or how a foreign key links tables together.

4. Document Your Research:

   • Explain each constraint clearly and provide an example of how each can be applied in a database.

   • include screenshot from your own machine and code snipperts

5. Publish Your Work:

   • Write your research on database constraints and document your understanding on Hashnode.com or Medium.com.

   • Include any diagrams or SQL examples that help illustrate the concepts.

   • Include Referemces

   • deadline Oct 4 2024