Understanding the Notation

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.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.