answersLogoWhite

0

A Key field is a field that has little chances of having repeat entries. Usually Name fields are not suitable because many people may have the same name. The basic purpose of having a key is defeated.

Hence having names as keys is not suitable.

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

What is a field that might be used in a database about students?

A simple field in this database would be the name of students, though first and last names are often separated into two fields.


Is it true in access that examples of database field names might be first name last name address and phone?

Yes, in an Access database, typical field names for a table storing contact information could include "First Name," "Last Name," "Address," and "Phone." These field names help organize and categorize the data within the database, making it easier to manage and retrieve information.


What field in a database is identified by a field?

A field in a database is often identified by a unique field or column name. This field name serves as the identifier for that particular data attribute within the database table. Assigning distinct and meaningful field names helps organize and reference the data effectively within the database system.


How many patients in the database have the last name of Smith in medisoft?

To find out how many patients have the last name of Smith in Medisoft, you would need to run a search or query within the patient database. Typically, this can be done by filtering the patient records by the last name field. The specific number of patients with the last name Smith will depend on the data entered in your particular Medisoft database.


What is a field name?

it is something in the database


What is a database field name?

A database field name is a unique identifier for a particular piece of data within a database table. It helps to organize and distinguish different types of information stored in the database. Each field name typically corresponds to a specific attribute or characteristic of the data being stored.


What characteristics in a database fields may have such as data type field name field size and field format?

What characteristics could a database field have, such as data type, field name, field size and field format?


What is a field called in a physical database?

In a physical database, a field is also called a column. It represents a specific piece of data that is stored in a database table, such as a name, age, or address. Each column typically has a data type that defines the kind of data it can hold.


What appears at the top of a database.?

field name


The column headings in a database such as Last Name or First Name are referred to as?

The column headings in a database such as Last Name or First Name are referred to as labels.


What is the difference between fields records files and databases?

A database is a whole load of data set onto a database, it is possible to have more than one database. A field is a record part and the record is the total part. A field is like: first name is a field, last name is another field., Mr/Mrs is another field, the whole records is all of the fields relating to a person. Like the address, the town, the postcode, etc.


Why is having a first and last name field in Microsoft Access better?

It is always better to have them as separate fields. It is very common to sort on last names and if there was a field which held the first name and last name in one field instead of two separate fields, it would not be possible to do that. If you take a phone book, the entries are always sorted by the last name. So in a properly designed database the first name and last name should always be separate fields.