homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum


10+ Year Member

Msg#: 397 posted 10:15 am on Mar 19, 2006 (gmt 0)

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?



10+ Year Member

Msg#: 397 posted 4:33 am on Mar 20, 2006 (gmt 0)

An XML Schema is a XML language for describing
and constraining the content of XML documents.

In very simple words, XML is code written by you, and defined by you. In order to validate and process that code, a schema is written to support it.

I assume that a schema is a schema is a schema...which probably means that a database schema describes and constrains the content of a database...never heard of it before, but seems to make sense.



WebmasterWorld Senior Member 10+ Year Member

Msg#: 397 posted 11:26 am on Mar 20, 2006 (gmt 0)

Yes a database schema describes the structure (including constraints & domains) of a database.

XML and Data definition Language or DDL(SQL Create,Add,Alter etc) are two common languages for documenting schemas, but can also use an entity relationship diagram or a data dictionary - typically a very large and hard to maintain spreadsheet :)

DDL has one huge benefit over the other methods - when you execute it, it creates the structure for you. But its not very good for communicating the schema to other (non-technical) stakeholders.

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved