What would you like to do?

What is a constraint?

already exists.

Would you like to merge this question into it?

already exists as an alternate of this question.

Would you like to make it the primary and merge this question into it?

exists and is an alternate of .

Constraint, in Project Management terms, means a factor that affects when an activity can be scheduled.
It can be some kind of a limitation or restriction.

webmaster at service.ztronics.com

Since this question has been categorised in Database Design, I will assume you mean what is a a constraint within a database...

You can have primary key, foreign key, alternate key and domain (aka check) constraints.

Domain contraints apply to a single field in a single row - e.g. whether or not nulls are allowed, or an enumerated list of allowed values.

Primary keys and alternate keys ensure that a for the column(s) in the key each row in the table has a unique value (or set of values if the key is composite).

Foreign keys ensure that if one table references another, that the reference exists in the parent table. This is normally linked to the primary key

e.g. this example (Oracle syntax) demonstrates these

create table employee (
employee_id number not null,
first_name varchar2(100) not null,
middle_names varchar2(100) null,
last_name varchar2(100) not null,
sex char(1),
ni_number varchar2(10) not null,
CONSTRAINT pk_employee PRIMARY KEY (employee_id),
CONSTRAINT ak_national_insurance UNIQUE (ni_number),
CONSTRAINT cc_sex CHECK sex in ('M', 'F')

create table emp_salary_hist (
employee_id number not nul,l
pay_review date not null,
pay_grade number not null,
salary number not null,
CONSTRAINT pk_emp_sal_hist PRIMARY KEY (employee_id, pay_review),
CONSTRAINT fk_employee FOREIGN KEY (employee_id) REFERENCES employee(employee_id)
27 people found this useful
Thanks for the feedback!

What are the constraints to agriculture?

There are a number of constraints to agriculture. Some of them  include climate, soil topography, water retention abilities of the  soil, market for goods and so much more.

What is a constraint of a project?

A constraint is a restriction (or a limitation) that can affect the performance of the project. For example, there could be a schedule constraint that the project must be comp

What is the definition of constraint?

In Project Management constraints are those elements that affect the scheduling of an items.   These could be any of:   * Activity constraint:  * ** **  ** Activity ca

What is voluntary constraints?

A voluntary constraint is when a company voluntary says they will never do this or they will always do that, an example of this would be always recycling there used materials

What is an evolutionary constraint?

We've seen that arthropods have some powerful tools for success, and they've succeeded in many ways - in terms of longevity, number of individuals, number of species, and vari

What are assembly constraints?

In computer modeling, assembly constraints are parameters that define geometric relationships between components in an assembly of parts. When applied between certain parts, t

What is ideological constraint?

Siding with a party or conservatives/liberals constrains your ideologies so that they are not random. i.e. conservative ideologies: low taxes, less government

Why you need constraint?

The purpose of contraints is not to curtail or abolish freedom but to preserve and enlarge it. Where there is no contraints, violence and anarchy will prevail jeoperdising thd
In Grammar

What is constraint as a noun?

Constraint is the noun. The verb is to contrain, the adjective  constrained.
In Uncategorized

What is the function of constraint?

It prevents certain types of inconsistent data values from being entered. / It assign a row(s) nullable values. / It assign a column(s) duplicate data values from being entere