|
|
|
|
A good design of any database is important, and the real question is, how good is
your design? Just knowing that the rating of a database is less then stellar, while
important, is only the first step. Second, you need to know what and where the specific
problems are. Third, and last, you must fix these problems.
SqlTac addresses all of these items. SqlTac will provide an overall rating of your
database (0-100), and identify specific items needing attention. We will classify
each item as an Integrity, Quality, Performance or Readability issue. But wait,
there’s more: SqlTac will fix many of the issues which it uncovers. Do not to wait
until you have completely finished your design. SqlTac should be constantly run
on a database during the Design phase. Run SqlTac after adding or modifying each
table to minimize the impact and localize the possible corrections which might need
to be performed. See the Design for specifics.
|
|
|
|
1) Provides ratings (0-100%) relative your database design.
|
 |
- Overall
- Integrity
- Quality
- Performance
- Readability
|
NOTE: a 65% is not a passing grade; a passing grade is an 90%.
|
|
2) Identifies Integrity issues:
|
|
- Tables without Primary Key
- Tables without logical unique key
- Indexes with questionable uniqueness
- Columns without foreign keys, which should be referencing a reference table
- Columns in need of a constraint
|
|
|
|
3) Identifies Quality issues:
- Tables with an identity column that do not have a Primary Key
- Lonely tables, tables that do not reference any other table nor are referenced by another table
- Column names used in more than one table with an inconsistent type.
- Repeated Column Name appended with a number
|
4) Identifies Performance issues:
- One or more primary key segments are not marked as identity.
- Multiple segmented primary key. Define a single segmented primary key with an identity.
|
|
|
|
5) Identifies Readability issues:
- The column name starts with the name of the table
- A primary key should be the first column for the table
- A column name of “Id” should be reserved for a Primary key
|
|
6) Generate Sql to fix these issues at the click of a button
|
|
|
|
|