Please enable JavaScript.
Coggle requires JavaScript to display documents.
2-3 CONCEPTUAL DATA MODELING (WHAT? (IMPORTANCE (P (PREVENTS mistakes and…
2-3 CONCEPTUAL DATA MODELING
WHAT?
CAPTURES
the functional and informational needs of a business
ADDRESSES
the needs of business, but does not address its implementation
IDENTIFIES
important entities and relationships among them // does not specify primary keys
IMPORTANCE
P
PREVENTS
mistakes and misunderstanding
T
TAKES
into account regulations and laws governing this industry
F
FACILITATES
discussion
D
DOCUMENTS
business rules of the business
D
DESCRIBES
exactly the information needs of business
LOGICAL MODELING
WHAT?
Is called an entity relationship model (ERM) and
ILLUSTRATED
in an ERD
SPECIFIES
all attributes for each entity
DETERMINE
attribute optionality
DETERMINES
relationship optionality and cardinality
PHYSICAL MODEL
WHAT
DESCRIBES
how the objects should be implemented in specific database
SHOW
all tables structures
Is an
EXTENSION
to a logical data model
DEFINES
table definitions, data types, and precision
IDENTIFIES
views, indexes, and other database objects
ENTITY RELATIONSHIP DIAGRAM
WHAT
A consistent tool that can be used to represent the data requirements of a business, regardless of the type of database is used, and even in the absence of one
GOALS
C
CAPTURE
all required information
E
ENSURE
that information appears only once