BSc IT - Database Management System

In SQL, domain constraints  and unique constraints  are used to make sure that the data stored in a database is accurate and follows specific rules. 

    A domain constraint  makes sure that the value stored in a column is of the correct type or within a valid range. For example, you can set a domain constraint so that the Age column only accepts numbers greater than 0, or that the Gender column only accepts values like 'Male', 'Female', or 'Other'. This helps keep the data meaningful and consistent. 

    A unique constraint  ensures that all the values in a column (or a group of columns) are different. For example, if you apply a unique constraint on the Email column in a Users table, no two users can have the same email address. Unlike a primary key, a unique constraint can allow one or more NULL values, depending on the database system.