answersLogoWhite

0

A non-key field can be any field in the table that is not the primary key. During the process of normalisation identifying non-key fields is important, as they and other fields may be moved and new tables created. Foreign keys will be left in the table.

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

What are the requirements for a relation to be in Second Normal Form?

A relation is in second normal form (2NF) if any of the following conditions apply: The primary key consists of only one attribute No non-primary key attribute exists in the relation Every non-primary key attribute is functionally dependent on the full set of primary key attributes


What key do you push to get out your scope as a scout on battle field 1942?

Your non-primary mouse key.


What is a non key attribute in normalization?

An attribute is another name for a field in a table. Some attributes are used as keys to help specifically identify individual records,like a code number or reference number for example. Most attributes are not used as keys. Any of those are non-key attributes.


What is the difference between a Primary Key and a Secondary Key?

A Primary Key is a unique identifier for each record in a database table and is used to enforce entity integrity. A Secondary Key is a non-unique index that is used for querying and organizing data efficiently but does not have the constraint of uniqueness.


How do you Avoid missing column values for non primary key columns?

Use Default and Not NULL


Is Primary and non contributory the same as general liability additional insured endorsement?

NO


Difference between foreign key and composite key?

primary key: primary creates a clustered index on the column and it doesn't allow null values. unique key: unique key creates non clustered index by default.it allows "one null value". foreign key: A foreign key (FK) is a column or combination of columns used to establish and enforce a link between the data in two tables. Fore More information, you can visit this website:http://www.iyogibusiness.com


What are types of colors?

primary and non primary


What type of colors?

primary and non primary


What is the super key in database management system?

the super key is the windows key (the flag) in non-windows OS


What A non-tower satellite airport within the same Class D airspace as that designated for the primary airport requires radio communications be established and maintained with the?

primary airport''s control tower.


What is the difference between a candidate key an a secondary key?

A candidate key is a unique key that can uniquely identify each record in a database table, whereas a secondary key is a non-unique key used for data retrieval and indexing purposes. Candidate keys can be chosen as the primary key for the table, while secondary keys provide alternate ways to access and organize the data.