No. 1 and you will foreign keys will be most elementary elements on what relational principle would depend. No. 1 tactics impose organization ethics by distinctively pinpointing entity era. International tips impose referential integrity by the doing an association between one or two organizations. The next step in building might data model in order to
- select and you will determine the primary trick characteristics for every single organization
- verify number 1 secrets and relationships
- move the main keys to expose international tips
Determine No. 1 Trick Qualities
is research products that define an entity. An ended up being an individual worth of an element to possess a situation out of an entity. Such as, Term and you may get day is actually top features of the fresh new entity Personnel. “Jane Hathaway” and you can “age and hire day.
The fresh try a feature otherwise a set of characteristics you to uniquely pick a particular instance of an organization. The organization regarding study design need to have an initial key whoever viewpoints distinctively identify cases of the new entity. Continue reading “A foreign trick is an element that completes a love of the pinpointing the fresh new mother organization”