Applying Design Patterns

Most of these tables now only have an ID, Name, and Primary Key. We need to give them functional elements by adding Design Patterns.

The UML schemas for these Patterns can be found in Chapter 2, Architectural Patterns and Chapter 3, Design Patterns.

The Bed and Breakfast setup

In this example application, we need the Setup table to store the Number Series for the Stay table. Other than these, we don't have fields to add anything to this table.

The Bed and Breakfast setup

Here's how I usually put table definitions in design documents:

Field No

Field Name

DataType

Comments

1

Primary Key

Code10

This is the Primary Key for this table

20

Stay Nos. ...

Get Microsoft Dynamics NAV now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.