Industrial Engineering
Business and Industry
Project Management
C Sharp

What is a constraint?

Top Answer
User Avatar
Wiki User
Answered 2011-07-03 23:24:35

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


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)


User Avatar

Your Answer

Related Questions

column constraint is for a single column. table constraint is for an entire table.

A geometric constraint is different from a numeric constraint because a geometric deals with non-numerical relationships.

A constraint which is not required or is extra, presence or absence of such a constraint does not effect the solution of problem

Geometric Constraint, Parametric Constraint, and Assembly Constraint

a constraint that deals with the complexity of an object.a constraint that deals with numbers and shapes.a constraint that... oh I don't i just made this all up.A constraint that can be described by a number value etc... 5 feet long, three inches tall

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

Binding constraint limits the value of the objective function.

A constraint is a limitation that is visible and present. The difference between a constraint and risk is that a risk is problem that is not yet seen, or a potential problem.

constraint length for GSM is L=5

Any Equality Constraint constraint in an LP problem is called Unrestricted Variable

A constraint is when a boa constrictor attacks you and cuts of your air supply.

A numeric constraint deals with distances and size. Width, length, and depth are examples of these.

A constraint is a form of restriction or limitation upon a system, process or object. A simple example would be a speed limit. The speed limit acts as a constraint to how fast you can drive.

Limitation of resources is a major constraint in Project Management. Discuss.

Time is a major constraint on the management of a family. Or, He showed great restraint when faced with the threat.

true because that is what it says in the glossary of my science book :)

The word "constraint" is a noun. The word "design" can be either a noun or a verb but in this context it is a noun.

limitation or restriction.

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 completed by a predetermined date. Similarly, a cost constraint would limit the budget available for the project. Every project manager must keep these constraints in his mind during project planning as well as execution.

force, necessity, pressure

foreign key constraint defines a column or combinations of columns whose values match the primary key of another table.

An external constraint is something outside a business that stops the business achieving it's aims and objectives. For example, changing consumer's tastes.

A constraint is used to express a condition, restriction or assertion related to some of the semantics of a model element.Constraint is a condition which must evaluate to true by a correct design of the system. For example, bank account balance constraint could be expressed as:{balance >= 0}Constraint in UML is usually written in curly braces using any computer or natural language including English, so that it might look as:{account balance is positive}UML prefers OCL as constraint language.

something that is restricted within a business

Copyright ยฉ 2021 Multiply Media, LLC. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Multiply.