There's a 2.0 version of the .NET PetShop application. They added support for distributed transactions and a Web Service façade for getting order information.
If you are wondering if the database design was improved, it wasn't. It really got worse, as they dropped some referential integrity constraints that were right.
Now you can, for example, delete the 'Account' information for a registered user, without deleting the 'Profile' information for it, so you'll have 'phantom' users in the 'Profile' table.
12:57:13 PM
|