How about what should go into a data model instead.  These are qualities that a good logical data model should possess.
1.  The model should be in third normal form or higher.
2.  All entities and attributes should have descriptions written in business terminology.
3.  All relationship should have a description describing its purpose.  Bad relationship names are "is a" or "relates to.
4.  Entity names should be singular.  Use Customer not Customers.
5.  Entity definitions should include valid values, aliases, and examples.
6.  Attribute names should have a class word appended to the end of the name.
7.  An attribute should only have one meaning.
8.  Attribute names should be completely spelled out.
9.  Attributes properties should include its length, optionality, and domain.
10.  Relationship properties should include its cardinality, referential integrity rules, type, and definition.
 
Regards,
Walter
WallStreet Consulting Services, Inc.
"Managing Your Data Investment"


>>> "John Miller" <[EMAIL PROTECTED]> 04/07/01 04:58AM >>>

Hello All:

I am looking for some good examples of data schemas.  Does anyone happen to
have some good examples (other than the standard examples).


Thanks in advance.

John Miller

************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages: http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
*************************************************************************

Reply via email to