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.
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. |
Code10... |