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

 

12 Comments

  • This is a great find scott. Thanks!

  • 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.

  • 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.

  • 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

  • Somebody Knows a similiar site for UML diagrams?

  • 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

  • Thanks a lot for the excellent pointers.

  • Wow! Excellent find scott.

  • This is great, everytime I come to your blog I learn something new or I get a great resource. This is brilliant.

    Al

  • 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?

  • 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

  • Database Schema Samples Library
    Scott, this is an excellent resource. Thanks for the tip!

Comments have been disabled for this content.