Conceptual models and data-flow views
On This Lesson 4 topics
This lesson is planned. The outline below lists the topics it will cover. The full lesson has not been published yet.
In this lesson
produce a conceptual data model and a data-flow view readable by business and IT.
Planned topics
- Conceptual model: the business things (Customer, Order, Product, Shipment) and how they relate, with no tables or types.
- Data-flow view: boxes for systems, arrows for data moving, labeled with data set and trigger.
- Mark the system of record on each entity; arrows into a non-record system are copies.
- Keep one page each; detail belongs in the data dictionary.
Draft outline details
Demonstration
a sketch: Customer 1-many Order, Order 1-many OrderLine many-1 Product, Order 1-many Payment; beside it a flow from stores and web to platform, ERP, and warehouse.
Check your understanding
What distinguishes a conceptual from a physical model?
Show answer
The conceptual model shows business entities and relations without tables, columns, or technology.
Practice
Apply this lesson with the module's lab, exercises and quiz.
Marking a lesson complete is optional and you can undo it any time. Your progress stays in this browser.