Database Management
Register
Advertisement

Feedback[]

What value would one hope to add by using this notation as opposed to listing the fields in a table?

You say that this model is more friendly and usable but on what basis? Clearly you still need to have an understanding of special rules such as underlining, dashed underlining and use of underscores. The fact that you need this understanding makes this a formal model which is not easily understood by non-technical people. I will say however that it is useful as an abbreviated notation in so far as that it takes less space on paper. 

No references to support this notation

It is not clear if this is a well known notation or something that you made up yourself. The only reference you have is in fact a dead link. This makes the information you provide entirely unverifiable and therefore no different from any kind of adhoc notation that anyone might come up with on a whim. Having worked as a developer for over a decade I have never seen or heard of this type of notation, nor are there any other references to it on google. If this is something that you have come up with yourself, that is fine but this should be stated so that people don't mistake this for being standard industry notation.

Database tables only have one primary key

You mention "You always start with the primary key(s)". There is only ever one primary key in a database table, this is the whole idea of a primary key. You can have a primary key that consists of more than one field but this does not mean that you have more than one primary key.

Vague and ambiguous refeferences to dashed underline

When you state "underscored with a dotted line", what does that mean? An underscore is a type of character '_'. You then later refer to this as a 'dashed underline' in diagram 2 but do not give any example of this. 

Use of subjective comments

You state "By translating E/R diagrams into relational notation it also makes it easy for an individual to normalize and denormalize any given table in the schema" however I don't think it necessarily makes it easier to normalize at all. Why do you think this?

Advertisement