answersLogoWhite

0

yep foreign key can have duplicate values

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

Does foreign key alllows null values and duplicate values?

A foreign can have null values and it can have duplicate values.A foreign can have null values and it can have duplicate values.A foreign can have null values and it can have duplicate values.A foreign can have null values and it can have duplicate values.A foreign can have null values and it can have duplicate values.A foreign can have null values and it can have duplicate values.A foreign can have null values and it can have duplicate values.A foreign can have null values and it can have duplicate values.A foreign can have null values and it can have duplicate values.A foreign can have null values and it can have duplicate values.A foreign can have null values and it can have duplicate values.


Duplicates in a excel spreadsheets?

I) To prevent duplicate values (from A2 to A10) when entering data:1) Select the range (eg: A2 to A10)2) Data -> Validation -> Settings -> Custom -> Formula:=countif($A$2:$A$10,A2)=1II) To find duplicate items in combine column:To check whether the data in column C is Duplicate or Unique:-Firstly enter values in column C,then enter the formula in column D:=if(countif($C$1:C1,C1)>1, "Duplicate", "Unique")then copy the formula downwards.


Can domain values repeat?

In the context of databases, domain values can repeat depending on the specific constraints of the database schema. For example, in a relational database, a column that allows duplicate values (like a "city" column) can have repeated domain values, while a primary key column must have unique values. Therefore, whether domain values can repeat depends on how the data is structured and the rules set for that particular dataset.


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 entered.None of above


What is key constraints?

Primary Key is a Constraint Used to avoid Duplicate entries in database table and you define primary key the column doesn't allow NULL values.


What is primary key constraint?

Primary Key is a Constraint Used to avoid Duplicate entries in database table and you define primary key the column doesn't allow NULL values.


In excel what do you do with the second row or column?

There is no particular answer to that. You can do what you want with them. Often though, the first column and first row are kept for headings, so the second column and second row contain the first values on the spreadsheet.


When creating a new field in a table what column is optional?

The "NULL" column in a table is typically marked as optional when creating a new field. It allows for the column to contain null values, meaning it is not required to have a value for every row in the table.


A column chart represents values as what?

The height of the column.


What type of field cannot hold duplicate value in ms access?

A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.


Can the FirstName column be a primary key?

A First name field is not a good one for a primary key. A primary key cannot have duplicate values. A first name field is highly likely to have duplicate values, so it should not be used as a primary key.


What is the main reason to use inheritance?

to avoid the duplicate values