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)
29 people found this useful

What is a business constraint?

rules for business or system development in terms of resource availability, dependencies, timescales, or some other factor.

What are the constraints to agriculture?

There are a number of constraints to agriculture. Some of theminclude climate, soil topography, water retention abilities of thesoil, 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 cannot start b

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 are constraints and criterias?

Constraints are holding back or regulation. There are constraints on the government in the Bill of Rights. A criteria is a set of standards or specifications. The criteria for

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

What is constraint as a noun?

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

What is multiplicity constraint?

The no. of entities that can be associated with another entity. For eg. 1-1, 1-many, many-1 and many-many
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
In Uncategorized

What is the meaning of Constraints?

a limitation or restriction.. "the availability of water is the main constraint on food production". synonyms:. restriction, limitation, curb, check, restraint, control,da