 For example, the "Doctor Last Name" field might be assigned as a primary key of the Doctor table with all people having same last name organized alphabetically according to the first three letters of their first name.A table can also have a foreign key which indicates that field is linked to the primary key of another table.A complex data model can involve hundreds of related tables.