http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Configurator, as I was there (a very big government office) to write an Office Automation application (*), I wouldn't be surprised if you are right, although I never even enquired .. I was already too shellshocked from what I was seeing, I guess .. (*) no, I don't do that anymore, it has been way more than 10 years now ;) http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment16http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment16Fri, 20 Feb 2009 17:38:34 GMTMSSQL Product Sample Databases @ CodePlex: [http://www.codeplex.com/MSFTDBProdSamples](http://www.codeplex.com/MSFTDBProdSamples) However, it seems only to be AdventureWorks, not all the other fictious companies they use commonly (Wingtip Toys, Woodgrove Bank, Northwind Traders, etc.) - Johan http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment15http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment15Fri, 20 Feb 2009 09:09:41 GMTWhat about Chinook Database? [http://www.codeplex.com/ChinookDatabase](http://www.codeplex.com/ChinookDatabase) It is a sample database available for SQL Server, SQL Compact, Oracle and MySQL. You could demo using different database servers. It is based on iTunes store including tables for artists, albums, media tracks, invoices and customers. It is a small, simple and can be created by executing a single SQL script. You can even generate the SQL script using the data from your own iTunes library if you want. http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment14http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment14Fri, 20 Feb 2009 06:11:19 GMTAlessandro, was that `previous platform` MS Word? These guillemets sure look like Word form fields :P http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment13http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment13Thu, 19 Feb 2009 18:01:35 GMTFrom time to time, I have seen DBs without a single foreign key declared (now that I think about that, wasn't the one of SAP R/3 one of those?). Probably the worst was having a table, with a single column acting as primary key, holding strings of guillemets enclosed substrings (as in "«A234..»«B234..»«E454..»"), the latters being the logical foreign key to max 3 tables (min 0) from a collection of 10 available, and the table being referenced was decided from the initial character of the substrings. I was said this "design" decision was taken because the application had been ported from some previous platform .. http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment12http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment12Wed, 18 Feb 2009 17:05:29 GMTIf you know Assyst!!! Surely it's database came from hell!!! They use hibernate for their mapping though. :0 http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment11http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment11Wed, 18 Feb 2009 17:00:05 GMTAdventureWorksLT, small enough to avoid dizziness, but "Relational" enough to show NHibernate coolness ;) http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment10http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment10Wed, 18 Feb 2009 16:38:16 GMTIn the history of databases, there have always been rumblings of a DB which was so poorly designed, so poorly maintained, and just plain evil. Well good sir, I have come into contact with such a DB, and I am clutched within its dark fingers. A putrid design created deep within the bowels of hell; some say forged by the evil one himself. This is a DB which has wreaked its evil on it's users for years slaying anyone who has come into contact with it - DBA, developer, architect; none stood a chance. But alas, I cannot share its design. Letting such vile loose in the world would be a travesty and a cross which I just could not bear. You shall have to look elsewhere on your search of a database from hell... this one is just too malevolent. http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment9http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment9Wed, 18 Feb 2009 14:40:57 GMTI wish I could hook you up with this DB2/AS400/ISeries hell-hole we have... http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment8http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment8Wed, 18 Feb 2009 14:07:04 GMTWell you've seen ours and it has some quirks. Too big to use but I would say it would be nice to throw in some composite key stuff because that's the one thing we really struggled with when trying to use NHibernate. http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment7http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment7Wed, 18 Feb 2009 13:21:00 GMTIf you've got a copy of a Remedy database. They still give me nightmares. http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment6http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment6Wed, 18 Feb 2009 12:43:01 GMTit seems most accounting packages have terrible db schemas which reflect flat files more than anything else. not that you want to recreate a db, but maybe harvesting some segments of an accounting db schema is the way to go. http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment5http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment5Wed, 18 Feb 2009 12:09:32 GMTI have used AdventureWorks previously for that type of thing.It works for sqlCE (so easy to port your examples without having a dependency). It also contains some "interesting" scenarios like string primary keys etc. http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment4http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment4Wed, 18 Feb 2009 11:59:44 GMTI'm currently using the EVE ( [http://www.eve-online.com/](http://www.eve-online.com/)) database to teach my little brother C#/ASP.NET MVC/NHibernate and create an app for his clan. It's an interesting database: [http://wiki.eve-id.net/CCP_Database_Dump_Resources](http://wiki.eve-id.net/CCP_Database_Dump_Resources)http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment3http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment3Wed, 18 Feb 2009 09:38:45 GMTNorthwind, AdventureWorks? http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment2http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment2Wed, 18 Feb 2009 09:22:08 GMTIngres? http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment1http://ayende.com/3883/challange-the-sample-legacy-database-from-hell#comment1Wed, 18 Feb 2009 08:56:14 GMT