A Synon/2E Data Model is a structured, organized description of a set of data and its relationships of a business or organization. Data models are intellectual and sometimes graphical tools representing logical data relationships. A Data model does not comprise in itself a true representation of all the business's information, but, is a simplified view of it.
Goals Of Data Modeling
A data model must meet three main objectives to be deemed acceptable:
Comprehensive - Every item of information (field) that is relevant to the organization should be identified.
Non-Redundant - Every item of information should appear once and only once. This elimination of
repeating groups of data is one of the elements of what is commonly known as Normalization.
repeating groups of data is one of the elements of what is commonly known as Normalization.
Consistent - There should be no mutually incompatible representations of information (data), nor conflicting rules about what can be done with data. That is, a particular data element should have the same attributes each and every time it is found in the model.
Synon/2E Concepts and Vocabulary
The Edit Database Relations screen allows you to describe the data portion of an application. The data portion consists of entities (files), attributes (fields), and data relations.
Let's define the terms we will be using throughout this course.
Data Relation - A logical association between two Synon entities or a Synon entity and
a Synon field.
Entity - A group or list of Synon Data Relations.
Attribute - A unit or element of information. This is also known as a field.
Condition - A specific value or values associated with an attribute. A condition may
be a discrete value, a comparison, or a range of values.
Let's define the terms we will be using throughout this course.
Data Relation - A logical association between two Synon entities or a Synon entity and
a Synon field.
Entity - A group or list of Synon Data Relations.
Attribute - A unit or element of information. This is also known as a field.
Condition - A specific value or values associated with an attribute. A condition may
be a discrete value, a comparison, or a range of values.
# end
No comments:
Post a Comment