A foreign trick is actually a characteristic one finishes a love of the pinpointing the fresh new mother or father organization

A foreign trick is actually a characteristic one finishes a love of the pinpointing the fresh new mother or father organization

First and you may foreign tactics will be most elementary section on which relational theory is based. Primary tips impose organization stability from the exclusively distinguishing entity occasions. Foreign tips enforce referential stability by completing a connection anywhere between a few agencies. The next step from inside the strengthening might data design in order to

  1. choose and you can identify the key key functions for every entity
  2. examine primary points and you may dating
  3. migrate the key keys to introduce international points

Define Top Key Services

is actually research products that establish an organization. A was actually just one worth of a characteristic to own an incident of an entity. Including, Label and hire date is actually attributes of the latest entity Personnel. “Jane Hathaway” and you can “elizabeth and you will hire day.

The latest is an element or a set of attributes one to distinctively select a specific illustration of an entity. All the entity throughout the research design must have a first key whoever thinking exclusively identify instances of this new organization.

  • it must enjoys a low-null well worth per illustration of the fresh new organization
  • the benefits should be book for each and every exemplory case of an organization
  • the values must not change otherwise getting null for the lifetime of any organization such as for instance

Often times, an entity get multiple attribute that may serve due to the fact an initial trick. Any key or minimum selection of secrets that could be an excellent no. 1 key is named a candidate secret. After candidate tips try known, pick one, and only one to, first trick for every organization. Find the identifier most frequently employed by the consumer for as long as it adapts for the properties in the above list. Candidate points that are not chose due to the fact no. 1 trick are known as approach tactics.

A good example of an entity that’ll possess numerous you can easily no. 1 tips is actually Worker. Assuming that each worker during the an organisation discover around three applicant secrets: Personnel ID, Social Safeguards Matter, and Identity.

Name is minimum of popular applicant. Although it might work to own a little agencies in which it could feel unlikely one two people would have equivalent label, it would maybe not benefit a giant organization that had many or a huge number of group. Moreover, you’ve got the options one a keen employee’s name you may transform just like the from relationships. Staff member ID is good applicant so long as for every single staff member was basically assigned yet another identifier during hire. Social Safety works most useful due to the fact all personnel is required to have one before becoming rented.

Compound Keys

Often it means one or more feature to help you uniquely pick an enthusiastic entity. An initial key one to comprised of several attribute is named a mixture key. Profile step one shows an example of a substance key. For every single example of the new entity Really works are uniquely recognized just from the a compound key including Worker ID and you will Investment ID.

Phony Points

A fake keyis one which doesn’t have meaning towards business otherwise organization. Phony keys are permitted when step one) zero trait enjoys most of the number 1 key attributes, otherwise 2) the primary trick is actually large and you will cutting-edge.

No. 1 Secret Migration

Mainly based entities, entities that depend on the clear presence of various other organization for their personality, inherit the entire number 1 key about father or mother organization. All the entity inside a great generalization steps inherits the main key out-of the underlying common entity.

Explain Trick Properties

Once the secrets have been known on the design, it is time to label and define new features having become utilized while the important factors.

There isn’t any simple opportinity for symbolizing prie of your number one trick followed closely by the notation (PK) is created within the organization box. An example is found in Contour 2A.

Examine Tactics and Matchmaking

  • Most of the entity regarding the analysis design will features a first trick whose viewpoints uniquely select entity occasions.
  • The primary trick attribute cannot be optional (i.age., provides null opinions).
  • An important trick dont provides recurring opinions. That is, the newest trait might not have multiple worth at the a going back to a given organization instance is actually prohibited. This will be referred to as No Recite Laws.

Foreign Points

Overseas secrets provide a method for keeping integrity regarding studies (named referential ethics) and for navigating anywhere between more cases of an organization. The relationship regarding the model must be supported by a different secret.

Determining Overseas Tips

All created and classification (subtype) organization regarding the design should have a different key for every dating in which they gets involved. International important factors try molded for the centered and you may subtype entities because of the moving the whole top trick from the mother or father otherwise simple organization. In the event the top trick was ingredient, it may not getting broke up.

Foreign Key Possession

Foreign secret qualities are not considered to be owned by the new entities to which it migrate, since they are reflections off characteristics throughout the moms and dad organizations. Ergo, per feature during the an entity is actually often belonging to that organization or is part of a different type in you to definitely entity.

In the event the number one key regarding a kid entity contains all of the characteristics for the a different secret, the little one organization is considered is “identifier established” for the mother or father organization, together with dating is named a keen “pinpointing matchmaking.” Or no features when you look at the a different secret do not get into the fresh kid’s primary secret, the child is not identifier influenced by the brand new parent, in addition to matchmaking is named “non distinguishing.”

Diagramming Overseas Tips

International points characteristics is conveyed from the notation (FK) at the side of him or her. An example was found within the Profile dos (b) a lot more than.


Top and international tactics are definitely the most basic portion on what relational concept depends. Each entity have to have a great trait otherwise features, the key secret, whose beliefs distinctively select each exemplory case of the fresh entity. The man organization should have an element, the newest overseas trick, one to completes brand new connection into the father or mother entity.

History up-to-date , It Features at the University away from Texas at the Austin. All liberties booked. Getting privacy inquiries comprehend our privacy.

Compartir en redes sociales

Share on facebook
Share on twitter
Share on whatsapp
Share on linkedin
Share on email

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *