Publisher's Synopsis
SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system. However, unless a database is designed correctly the powerful features of SQL Server 2000 are redundant. Database design is an essential skill that is often not adequately mastered by those who design databases as part of their jobs.;This book presents the most widely used methodology (IDEF1X) in an easily accessible form and provides exhaustive information and examples on the process of designing and implementing a database application from the backend database programmer's standpoint. It takes the reader through the process of designing a database from conception to documentation. Subjects include: information and requirements gathering; modelling methodologies; normalization; reporting and de-normalization; writing the database documentation; implementing business rules; implementing the database in SQL Server 2000; and creating an operational data store.