Tip/Trick: Online Database Schema Samples Library

Problem:

You are building a web application, and are trying to figure out how to best model the particular database schema you need for the application.

Solution:

One great resource I found recently on the web that I recommend checking out is a really nice library of free database models.  You can browse the library online here.

The library includes hundreds of sample database schemas for tons of topics – ranging from “Airline Reservations” to “Organizations and People” to “Car Servicing” to “Pizza Delivery”.  A sample schema for modeling “Clients and Fees” can be seen below:

The next time you start creating a new database, I'd recommend checking out the library to garner a few thoughts on how to think about the topic-space, and how to structure the table schema.

 

How Do I ASP.NET Data Video

To learn more about how to create new databases and tables within Visual Web Developer or Visual Studio, I’d recommend watching this “Create Data Driven Websites Video” that is listed on the www.asp.net web-site’s new Video Tutorials section (if you haven’t checked this out yet you should – in now contains dozens of videos with great content, with weekly new videos coming).  This particular video demonstrates how to use the database explorer within Visual Web Developer to create new tables, enter data, and build a simple three-tier data access app against it.

 

ASP.NET Data Tutorials

I’d also strongly recommend checking out the great ASP.NET 2.0 Data Tutorials series on the www.asp.net website which now includes 23 unique tutorials that walkthrough how to create three-tier data access applications using ASP.NET 2.0 (they cover everything from creating a new DAL, creating master/details reporting UI, creating data entry and editing pages, implementing optimistic concurrency, etc). 

Each tutorial is written in both VB and C#, and includes full sample source code to review.  There are also PDF versions of each sample that you can download to print out as well.  We still have another 20 data tutorials still to publish -- so make sure to keep an eye on the site for updates.

Hope this helps,

Scott

 

Published Wednesday, July 12, 2006 10:59 PM by ScottGu

Comments

# re: Tip/Trick: Online Database Schema Samples Library

Thursday, July 13, 2006 3:12 AM by Chris Ongsuco
This is a great find scott. Thanks!

# re: Tip/Trick: Online Database Schema Samples Library

Thursday, July 13, 2006 3:53 AM by SoftMind
Thanks for the excellent reference. Pl. do a little more favour. I am looking for a trick/tutorial to show advertisement banner between the repeat region of database. e.g------data data data ADVERTISEMENET BANNER data data so on... I have seen plenty of sites with Advt Banner between database. Can you pl. show us a trick for this.

# re: Tip/Trick: Online Database Schema Samples Library

Thursday, July 13, 2006 4:01 AM by DotNetGuy
VERY VERY HAPPY WITH EXCELLENT RESOURCE ON DATABASE SCHEMA. THANKS A BUNCH. ------------------------------------------ Hello, You had announced to blog atleast once a month regarding " whats comming up next month ". This blog is suddenly closed at your end. Pl. focus more on new starterkits also. You had mentioned few months back there are many starterkits on the way. No news about this since long. Can you spend some time for this topics.

# re: Tip/Trick: Online Database Schema Samples Library

Friday, July 14, 2006 1:55 AM by Kamran Shahid
Gordious Scott What a link For Online Database Schema Samples Library. Data Tutorials are also Rocking. I have watched all the videos.They are good for the kick start. It will be nice If you can prepare videos for these Data Tutorials

# re: Tip/Trick: Online Database Schema Samples Library

Friday, July 14, 2006 3:52 AM by Dani
Somebody Knows a similiar site for UML diagrams?

# A better resource for data models ..

Friday, July 14, 2006 9:28 AM by Stefan Broenner
Hi Scott, nice link for the sample database schemas but a, IMHO, better resource is the "The Data Model Resource Book" book series by Len Silverston. They do cost money but the level of quality (and especially documentation) is really great. Saved me tons of money and time. But Barry's model are a nice second option! Cheers Stefan

# re: Tip/Trick: Online Database Schema Samples Library

Friday, July 14, 2006 1:53 PM by yam
yeah, does someone know a similar site with vidoes and samples for UML diagrams?????????????????

# re: Tip/Trick: Online Database Schema Samples Library

Friday, July 14, 2006 10:39 PM by Srinivasa Raghavan
Thanks a lot for the excellent pointers.

# re: Tip/Trick: Online Database Schema Samples Library

Friday, July 14, 2006 10:57 PM by JohnySmith
Wow! Excellent find scott.

# re: Tip/Trick: Online Database Schema Samples Library

Saturday, July 15, 2006 4:17 PM by Albert Pascual
This is great, everytime I come to your blog I learn something new or I get a great resource. This is brilliant. Al

# re: Tip/Trick: Online Database Schema Samples Library

Monday, July 17, 2006 4:20 AM by fesadfeafr
Hello Scottgu I have a question. some days ago,I download ASP.NET Starter Kits(V2.0). I find almost these Starter Kits use Database schema to connect database. but,in ASP.NET1.1,from ASP.NET Starter Kit(V1.1),we see connect database like follow SqlConnection con=new SqlConnection(); con.CommandType=CommandType.SP; SqlCommand cmd=new SqlComand(); ... ... Does .net has changed the tradtion thinking?

# re: Tip/Trick: Online Database Schema Samples Library

Monday, July 17, 2006 6:58 PM by ScottGu

Hi fesadfeafr,

You can still definitely create and use the ADO.NET connection objects directly.  We do also have a few higher-level data abstractions that are now supported with .NET 2.0 that can make life easier as well.  They are built on top of the ADO.NET connection objects - so take advantage of that too.

Hope this helps,

Scott

# re: Tip/Trick: Online Database Schema Samples Library

Monday, December 18, 2006 8:03 AM by Steve

Database Schema Samples Library

Scott, this is an excellent resource. Thanks for the tip!