Data Modeling
Conceptual Modeling
Logical Modeling
Standards
Acronyms & Symbols
100
According to Steve Hoberman: “It is the set of techniques and activities that enable us to capture the structure and operations of an organization… The process requires many skills, such as listening ability, courage to ask lots of questions, and even patience.”
What is data modeling?
100
This model shows important data elements (a.k.a. entities) and how they relate to one another. It is not concerned with the attributes of the entities, nor the data types, nor naming standards. The modeler often interrogates a Business process.
What is a conceptual model (ERD or SAM)?
100
This model includes all the needed entities, attributes, data types, and relationships - fully normalized.
What is a logical model?
100
_______________ is a benefit that allows Tyson Foods to adhere to best practices and maintain a consistent look and feel regardless of database or platform.
What is standardization?
100
This analysis deliverable, also called a "Conceptual Model" is the abbreviation for "Entity Relationship Diagram"
What is ERD?
200
__________ are words or phrases that describe the importance and role of an entity and attribute. There is a limitless number of values for these.
What are definitions?
200
A person, place, thing, event, or idea on which an enterprise has both the will and the ability to track data.
What is an entity?
200
These are all the various data components that we care about for an entity.
What are attributes?
200
The 2 part Tyson Foods standard to keep in mind when creating data models.
What is all caps & underscore in place of spaces?
200
A data model is often compared to this when building a house.
What is a blue print?
300
Steve Hoberman says this is a “wayfinding tool for both business and IT professionals.” Credit Purdue says this is “a graphical representation illustrating data-related business requirements in the context of a given application.”
What is a data model?
300
A word or phrase that describes how two entities interact with each other.
What is a relationship?
300
An attribute/column (or combination) which the business has chosen to be the unique identifier for an entity. These keys prevent duplicates and are useful in enforcing referential integrity (RI).
What are primary keys?
300
Modified date written using Tyson standards.
What is MOD_DATE?
300
At Tyson, we use this symbology for labeling relationships
What is crows foot?
400
Data Modelers must take care to… (1) Limit ____ ____________ and (2) enforce Referential Integrity
What is data redundancy?
400
This process is what the model is supposed to represent. Defining this process is a key part in the conceptual modeling stage.
What is the business process?
400
The table(s) that resolve many to many relationships.
What is an associative (cross reference (XREF)) table?
400
Document where you can find most of the standards for column names in a database
What is the standard word glossary?
400
This person has in-depth working knowledge and should be called on to validate that a data model accurately represents a business process.
Who is a SME?
500
We use this type of modeling when the primary concern is to capture data to facilitate a business process.
What is relational modeling?
500
This refers to the maximum number of times an instance in one entity can be associated with instances in the related entity.
What is the cardinality?
500
This concept keeps data mismatching from creeping in between parent and child tables.
What is referential integrity?
500
Of the 3 forms of normalization (1NF, 2NF, 3NF), this one is the most important according to Tyson standards.
What is third normal form (3NF)?
500
Rounded corners on an entity indicate that it is this type.
What is a weak entity?
M
e
n
u