The original Fabrikam application and code was downloaded from the Microsoft web site and was
supplied ??????as is.??™??™ Any modifications have been made by the author, and Microsoft holds no
guarantees/warranties or support for this case study or sample, implied or explicit.
The first thing to do is to build the database. The script (Fabrikam.sql) to build the database
is available as part of the download for this book. (I thought about including the text here, but
once I saw it was 25 pages, I changed my mind. It??™ll be much easier for you to simply use the
download file.)
So, run Fabrikam.sql in SQL Server Management Studio. This script creates the database, all the
necessary objects, and the data for this case study, so no extra work is needed. The following objects
are created.
Appendix A: Case Study
Object Type Name
Table Countries
Table Customers
Table Deliveries
Table DeliveryDetails
Table Employees
Table Manufacturers
Table OrderDetails
Table Orders
Table Products
Table ProductTypes
Table States
Stored Procedure GetActiveCustomers
Stored Procedure GetActiveDeliveries
Stored Procedure GetActiveEmployees
Stored Procedure GetActiveOrders
Stored Procedure GetActiveProducts
View vLoadMfrs
View vProducts
View vStates
Once the script finishes, you??™re ready to build the Fabrikam demo.
Pages:
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491