0
A foreign key is a type of constraint. In this example the value in a field must be the same as some value in a defined field in another table.
Example in a Customer Table you might have a Column (field) named StatusID
You would define a foreign key to the table Status, field StatusID.
The value in the Customer table, StatusID column must be an entry existing in the Status Table, StatusID column.
There are many constraints. The fact that a column can not be NULL (Left blank) is a constraint. Defining what KIND of data, or range of data that can be entered in a column is a constraint.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What is unrestricted variable?
Any Equality Constraint constraint in an LP problem is called Unrestricted Variable
What is a many to many relationship in dbms?
Many to many relationship in DBMS is usually a mirror of the real-life relationship between objects that tables represent.
What is the difference between char and varchar2 in dbms?
no diff between varchar and varchar2 char store only chacter type but varchar2 store variable chacters. also varchar2 shirinks the space if not fully filled but char cant.
What is the difference between Hyperion and Essbase?
Essbase is a multidimensional DBMS where Hyperion performance suite is a set of BI tools.
What is the Difference between relation schema and relation instance?
difference between relation sehema and relation instance in dbms
What do you mean by lossiess join in dbms?
what do u mean by lossiess join in dbms
What does a binding Constraint mean?
Binding constraint limits the value of the objective function.
What constraint mean?
limitation or restriction.
Which constraint type enforces uniqueness?
Primary key
What do you mean by Schema in DBMS?
overall design of the database
What is DBMS kernel?
A DBMS kernal is a type of database. It is usually used in the architecture business world and it consists of software and system-level data structures.
What type of database management approach that can handle multimedia?
Object-oriented DBMS
What are the type of DBMS?
RDBMS,network,hirasrchy etc
The type of database management approach that can handle multimedia is the?
Object oriented DBMS
What are highlights of DBMS?
NA_ what are highlights of advanced DBMS what are highlights of advanced DBMS what are highlights of advanced DBMS
What is a redundant constraint?
A constraint which is not required or is extra, presence or absence of such a constraint does not effect the solution of problem
What is social design constraint?
what is social design constraint
