Hi,

I have an assignment where I need to look at an E-R diagram of an organization for one of their primary databases. I have questions I need to answer, such as if super-/sub- types are modeled, what notation and if CASE tools are used to help model the relationships, what type of business rules are there and how are they modeled, etc. If someone has a sample EER diagram that I could take a look at, I would greatly appreciate it.

Otherwise, I guess I'll have to make up some answers!

Thanks!

[QUOTE][SIZE=1]Originally posted by elyag
Hi,

I have an assignment where I need to look at an E-R diagram of an organization for one of their primary databases.

Hi,
I have a page listing over 200 Data Models on my Database Answers web site :-
http://www.databaseanswers.com/data_models/index.htm

They frequently show both Conceptual and Physical Data Models, so you can discuss them both, with examples.

There are just a few showing inheritance, and here is one of them :-
http://www.databaseanswers.com/data_...onal/index.htm

There are also three showing 3 UML Class Diagrams which will help you discuss another Data Modelling technique :-
http://www.databaseanswers.com/data_...s_diagrams.htm

Good luck.

Barry Williams
Principal Consultant
Database Answers

Hi,

Thanks for this info. By the way, did you use any CASE tools to draw the diagrams?

Thanks

[QUOTE][SIZE=1]Originally posted by barryw

[QUOTE][SIZE=1]Originally posted by elyag
>Thanks for this info. By the way, did you use any CASE tools to draw >the diagrams?

Mostly they are done using an inexpensive Data Modelling Tool called Dezign from Datanamic. I find the ability to generate SQL to create Tables in Access databases particularly useful.

In the first year or two I was using DataArchitect from PowerDesigner, and I liked the graphical appearance of the Data Models.

I have also created a few UML Class Diagrams which I don't like, although I used a Tool called Sparx which was great.

HTH.

Barry

One last question, are business rules normally model in the diagrams? If not, how do businesses usually store or document business rules?

Thanks!


[QUOTE][SIZE=1]Originally posted by barryw