|www.sum-it.nl > Courses|
> DB Design course > Method > 2. Logical Design > Test
Nederlands · Search...
Test the logical modelAre all functions possible with this logical model?
Run through all functions, using the UNF sources, that the system must be able to handle.
A CRUD matrixA CRUD matrix (Create, Read, Update, Delete) is a handy tool for the completeness check. Put tables on one axes, and functions on the other one.
|Introduction 1. Scope Normalisation steps Make ERD 3. Technical Optimisation 4. Implementation End|
|Street name change||U|
|Print route for newspaper boy||R||R||R||R|
TipStart filling the matrix with the C's (create). You'll quickly have a good completeness check.
The CRUD matrix forces you to have a deep thought about the design. It's an excellent preparation for the next step: 3. Technical Optimisation
|Next: 3. Technical Optimisation|