I cant seem to think at the moment, What is a schema? Its basically the structure of a database, right?

And how do you show your schema for a database? Simply list the breakdown of relations, attributes, etc?

Yes, a schema is your database structure. To view the schema of a database, it differs between databases. There are tools for every database that will allow you to view the schema (tables, indexes, fields, relations, etc...).

__________________
jedicoder
current seo efforts on Website Designer Search Directory and Grand Oak eCommerce Web Designer

Some people might refer to it as an ER model / diagram. An Entity Relationship diagram.

I don't know if your familliar with SSADM, but with any database structure/schema, it works best in the long run if the database structure is "normalised", as they call it.

The idea is to break down the data into sensible little chunks that relate to other sensible little chunks. Originally, the main idea was to save disk space, which was at a premium back in the old days. However, the same ideas still apply today as they allow you interogate and manipulate the data far more readily.

Sorry, I'm probably going a little to deeply into it, but its an appropriate point to consider how your going to structure your data and data relationships.

__________________
www.bsolveit.com
Web Design & SEO for Business Growth