![\"930-title.jpg\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/imported\/930-title.jpg\")
<\/div>\nCTL10.04.001<\/p>\n
Revision 11\/10\/2009 A<\/p>\n
SQL Server 2008 <\/p>\n
Database Design<\/p>\n
CRITICAL TASK LIST PROGRAM<\/b><\/p>\n
This document contains steps that will assist you in designing a database for SQL Server 2008 RTM Enterprise Edition (non-clustered) operations. It defines the basic steps for creating a database design, and should be used as a starting point.<\/p>\n
Review each item, placing a check in the “Confirmed” column when the task line is complete. Any line not marked “Confirmed” should stop the process until you have completed that line item.<\/p>\n
This CTL is not meant to be a replacement for the official documentation from the product manufacturer. <\/p>\n
CTL NUMBER <\/b><\/p>\n
This Critical Task List is identified by a CTL number in the upper right-hand side of this document. You should use the latest CTL (identified by the date and an alpha-numeric code. <\/p>\n
HOW TO BE ASSURED OF HAVING LATEST DATA <\/b><\/p>\n
You can add additional information to this checklist based on your organization’s need.<\/p>\n
CONTENT <\/b><\/p>\n
Critical Task List 10.04.001<\/u><\/b> contains steps required to create a good database design on a SQL Server 2OO8 system. Other system and environmental factors will dictate changes to this CTL as well as additional steps that you should follow for your database design tasks.<\/p>\n
All content is the sole responsibility of the server owner; Microsoft Corporate provides no warranties implied or implicit in this document. This document is not a product of the Microsoft Corporation. <\/p>\n
SUPPLEMENTS <\/b><\/p>\n
Official Site Link: http:\/\/www.simple-talk.com\/author\/buck-woody\/<\/a><\/p>\n Whenever you receive a supplement affecting your checklist, write in the appropriate information. Printed replacement checklist pages will be made available to you as quickly as possible. A notation on the bottom inside corner of these pages will indicate that they reflect certain supplements. <\/p>\n COMMENTS AND QUESTIONS <\/b><\/p>\n Comments and questions should be directed through buck.woody@microsoft.com<\/a>. <\/p>\n Critical Task Lists Managers <\/b><\/p>\n Buck Woody “Real World DBA”(MSFT U.S.).<\/p>\n
| \n Task<\/b><\/p>\n<\/td>\n | \n References<\/b><\/p>\n<\/td>\n | \n Confirmed<\/b><\/p>\n<\/td>\n<\/tr>\n Obtained Business Requirements from submitting organization<\/p>\n<\/td>\n Developed further questions from Business Requirements.<\/p>\n<\/td>\n Submitted questions to originator and received responses.<\/p>\n<\/td>\n Meeting held with development and organization team to agree on final requirements.<\/p>\n<\/td>\n Nouns decomposed from finalized Business Requirements document.<\/p>\n<\/td>\n Nouns grouped into logical entities.<\/p>\n<\/td>\n Verbs Decomposed from finalized Business Requirements document.<\/p>\n<\/td>\n Initial logical Entity Relationship Diagram (ERD) created.<\/p>\n<\/td>\n Logical ERD developed into 3rd Normal Form (3NF).<\/p>\n<\/td>\n Data Types Determined for each entity.<\/p>\n<\/td>\n Primary and Foreign Keys defined.<\/p>\n<\/td>\n Unique and other constraints defined from finalized Business Requirements document. <\/p>\n<\/td>\n Security plan developed from finalized Business Requirements document.<\/p>\n<\/td>\n Physical design created from finalized ERD.<\/p>\n<\/td>\n File Storage choices created and finalized.<\/p>\n<\/td>\n Finalized design tested with top-20 queries from each entity.<\/p>\n<\/td>\n There is nothing like a checklist to make sure you’ve completed all the tasks in designing a database, and there is absolutely nothing like Buck Woody’s military-style Critical Task List…<\/p>\n","protected":false},"author":221875,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[143527],"tags":[5140,5139,4168,4170,4197,4150],"coauthors":[],"class_list":["post-835","post","type-post","status-publish","format-standard","hentry","category-database-administration-sql-server","tag-buck-woody","tag-critical-check-list","tag-database","tag-database-administration","tag-database-design","tag-sql"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/835","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/221875"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=835"}],"version-history":[{"count":3,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/835\/revisions"}],"predecessor-version":[{"id":92268,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/835\/revisions\/92268"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=835"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=835"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=835"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=835"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} |