Results 1 to 5 of 5
  1. #1
    Western_Neil is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2016
    Location
    Calgary, AB
    Posts
    147

    ER diagram check


    Hi

    I back again with what I think is workable ER diagram. It feels very repetitive, tangled, and unstable. This may be me, but I sure think I am missing something.
    Any and all comments welcome


    [ATTACH]25324
    Attached Files Attached Files

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Not really possible to say without a clear explanation of your business, what the db is required to do and how your processes work.

    in general, you seem to have a number of ID fields which aren't referenced and a number of tables which are similar - tblunit_xxx and tblxxx. Not saying this is wrong, just trying to understand.

    For example, It looks like the tblUnit_xxx's are many to many join tables so the narrative would 'Units can have many branches and branches can have many units' - is this correct?

  3. #3
    Western_Neil is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2016
    Location
    Calgary, AB
    Posts
    147
    Two major things that I want are 1) Track a unit over time (many years), in its' many characters (Name, Place, etc.) and 2) create a listing of the reporting organization at any point in time (Command, Branch).

    Yes Ajax that is correct, there are a lot of similar tables. This is one of my concerns too, but each does represent a different concept. There is probably a slick way of doing this, but I can always beat it into submission with code (I hope).

    "Units can have many branches and branches can have many units" is corrected over time, and the statement "Units can have only one branch and branches can have many units" is also correct for a point in time. This is another area that I am unsure of (time). If we change Units into people, and branches into trades does that still make sense?
    The repetitive parts I wonder at, how to involve time properly, and having three stars (Unit, Change, & Title) all make me wonder if I got this right yet.
    The old statement comes to mind “If I knew the correct question to ask, I wouldn’t be beating around the bush”

    Thank you

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    as I said before

    Not really possible to say without a clear explanation of your business, what the db is required to do and how your processes work.

  5. #5
    Western_Neil is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2016
    Location
    Calgary, AB
    Posts
    147
    i am willing to work this out, but a lot of this is my head. If you can give a me an idea of what you want I can make something like it. This not a business but a hobby, There are no processes as I understand the term now, but there linkages in the data. As with all historical data, things change over time, what works for 1880 data may not work 1980 data, tweaks and bends to fit are not unusual.

    I DO want help, and will work to give you want as best as I can.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Entity Relationship diagram
    By hickie182 in forum Database Design
    Replies: 3
    Last Post: 12-15-2013, 02:19 PM
  2. Relationship diagram
    By tsvetkovdimitar in forum Sample Databases
    Replies: 1
    Last Post: 11-16-2013, 06:24 PM
  3. ERD Diagram help!
    By Richie27 in forum Database Design
    Replies: 3
    Last Post: 05-31-2012, 09:25 AM
  4. Need Help on er diagram
    By tonracu in forum Database Design
    Replies: 2
    Last Post: 08-25-2011, 11:02 PM
  5. ER diagram problem
    By silvercats in forum Database Design
    Replies: 0
    Last Post: 04-24-2011, 10:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums