Advertisement

Database Design and Creation

  • Robin Dewson

Abstract

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 so far 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 information 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. Its main intent is to demonstrate to you how to build a database solution from the ground up.

Keywords

Unique Constraint Store Procedure Child Table Referential Integrity Database Solution 
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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Robin Dewson 2012

Authors and Affiliations

  • Robin Dewson

There are no affiliations available

Personalised recommendations