Database Design and Creation

  • Robin Dewson


Now that you’ve installed SQL Server and examined the main tools you’ll use as a SQL Server developer or administrator, it’s almost time to start building the ApressFinancial database solution. However, you can’t do this yet because you still don’t know what the database will hold. At this point in time, all the information you have is that you’ll be building a database to hold some financial transactions for a personal or corporate financial tool. You’ll gear this database toward a financial tool that a corporation might use because SQL Server can be scaled from one user to thousands of users very easily. The next step is to gather more information about the requirements of the solution and about what data is required to be stored in the database. Once the information-gathering stage is complete, you’ll then be able to create the database within SQL Server throughout the book. The book’s main intent is to demonstrate to you how to build a database solution from the ground up.


Unique Constraint Financial Transaction Business Intelligence Query Plan Service Broker 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Robin Dewson 2015

Authors and Affiliations

  • Robin Dewson
    • 1

Personalised recommendations