Schema?
And how do you show your schema for a database? Simply list the breakdown of relations, attributes, etc?
[217 byte] By [bconnor] at [2007-11-11 8:15:57] 
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?
# 1 Re: Schema?
Yes, a schema is the definition of the structure of a database.The method for extracting schema information varies amongst databases. It would depend upon the database and (programming) tools you are working with.
pclement at 2007-11-11 23:47:07 >
# 2 Re: Schema?
Another way I was always taught to look at the schema was that it is the blueprint for your whole database system. That even includes what defines a user and a group. I agree with pclement, it depends on what system you are using.javatier at 2007-11-11 23:48:12 >
# 3 Re: Schema?
The schema is the identification of the tuples of attributes which define each relation, and the listing of all of the relations, within your database.It can be represented as easily as:
employee( employee_id, name, address, phone)
employer( employer_id, name, address, phone)
works_at( employer_id, employee_id)
etc.
nspils at 2007-11-11 23:49:11 >
