Results 1 to 5 of 5

Thread: EER diagram

  1. #1
    Join Date
    Jan 2004
    Posts
    7

    EER diagram

    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!

  2. #2
    Join Date
    Apr 2003
    Location
    London, England
    Posts
    42

    Re: EER diagram

    [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

  3. #3
    Join Date
    Jan 2004
    Posts
    7

    Re: EER diagram

    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
    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

  4. #4
    Join Date
    Apr 2003
    Location
    London, England
    Posts
    42

    Re: EER diagram

    [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

  5. #5
    Join Date
    Jan 2004
    Posts
    7

    Re: EER diagram

    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
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •