Database design

  • How do i make a new database design for sql server 7 from scratch.

    Pls give info on websites/freeonline books etc

  • As a suggestion you could connect Access 2000 and use a wizard.

  • Is that in project mode Neil? Or do you mean the upgrade wizard?

    421, there is some good info here on the site, including a review of SQL 2000 Database Design I wrote a while back - its a good book for a beginner. In general, db design is db design, you might find it easier going though to start out with Access, something designed more for an end user/beginning user.

    Andy

  • I love the sql 2000 database design book from Wrox press.

    Wes

  • Database design will be independent of the platform. If you have the design, then the GUI for SQL 7 will make it easy to add tables, keys, etc.

    for understanding database design, there are any number of good books out there. I don't really know of any good web sites relating design. If you post some information about what you are trying to achieve, perhaps we will write some articles here.

    Steve Jones

    steve@dkranch.net

  • There are a number of good resources available for database design. Joe Celko's Data & Databases is my personal favorite. There is an excellent list at http://www.dama.org in the resources page http://www.dama.org/resource.htm

    Dr. Peter Chen has some of the most referenced materials on database design at his homepage under Paper Online http://www.csc.lsu.edu/~chen/

  • tpantazi

    Thanks for the references.

    Steve Jones

    steve@dkranch.net

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply