SQL Server and PowerDesigner 9.0 use slightly different notation in their data modeling tools. For example, in PowerDesigner 9.0, M represents mandatory attributes, primary keys are underlined, and foreign keys are implied by the relationships and aren't displayed. The data types that I use in Figures 1 and 3 might be unfamiliar to you, but don't worry, they really do convert to the correct SQL Server data types when you generate a physical data model. Table A compares the two sets of data types.