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

    Split Entity Table

    Hi;


    I am still working on my military database and would like some idea if this the correct (best) way of doing this. (don't have a clue what to call this)

    For every chunk of data, I want to record where I found it. This can help find more pieces or figure out who is hedging. I’m not sure that I have all the fields or to many, but this is my position now. So the table are:

    Remember that tblChanges got deleted last thread, so now need some method of linking lots of tables to this one. (haven’t really though it out yet).

    tblRefSources
    RefSourceID ChangeFK SourceFK
    tblSources
    SourceID SiteFK BookFK Page/Locator
    123 3 49
    124 2 3rd Section OOB
    tblSites
    SiteID URL
    tblBooks
    BookID Title Author1 1stprinted Printed Version
    Printer Located Volume ISBN Language
    CallNumber PDF URL


    The questions are

    1. Is tblSources correctly setup?
    2. Should the Table include a rule that one (Site or Book) MUST be NULL?
    3. In tblSites and tblBooks any extra fields or missings?
    4. Is the normalization done reasonable?


    Thanks for read and thinking about this:

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 10 Access 2016
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    is tblRefSources used for both SiteFK and BookFK? i like to name my Tables that are Foriegn keys to have an fk prefix or similar.
    Looks like some good normalization imo, however tblSites seems like its a bit generic with only 2 fields.

    We wont know what fields you are missing I dont think, unless there is another thread you are referring to.

  3. #3
    Western_Neil is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2016
    Location
    Calgary, AB
    Posts
    147
    Quote Originally Posted by Perceptus View Post
    is tblRefSources used for both SiteFK and BookFK?
    Yes, but that is part of the question. How to get a table to point either table
    i like to name my Tables that are Foriegn keys to have an fk prefix or similar.
    I use FK to show my foreign keys and plural my tables. Each to his own unless you have great reason.Always willing to learn
    Looks like some good normalization imo, however tblSites seems like its a bit generic with only 2 fields.
    Second part of the question, what would be "normal" to include a HMTL reference record?

    So a chuck of data would point to tblChanges, giving a link to tblRefSources. One Change could have many sources, and One source could refer to many changes (many to many). Since each source has a page/locator field it, that gives a SiteID two fields, URL and Locator. I do not know how to drive the address to a specfic spot within the web page. Hints would be loved.

    Thanks for responding
    Western Neil

  4. #4
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 10 Access 2016
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    The pointing of tables can help to ensure data integrity is enforced. but not necessarily important(could be wrong). In Access you establish relationships in the relationshipview window.

    Wise nomenclature used in the name of variables is a good way to save on documentation requirements. This can extend to any object that you have control over naming .

    Storing websites as a link field or text field is pretty much the same, with the change being you can get some automation in a form with a link field.

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

Similar Threads

  1. Entity Relationship
    By dfean in forum Access
    Replies: 2
    Last Post: 09-04-2016, 08:54 AM
  2. Replies: 1
    Last Post: 05-18-2014, 10:44 AM
  3. Employees in same entity
    By cathal1292 in forum Access
    Replies: 3
    Last Post: 05-05-2014, 02:26 PM
  4. Entity Relationship diagram
    By hickie182 in forum Database Design
    Replies: 3
    Last Post: 12-15-2013, 02:19 PM
  5. Generalization-Specialization Entity Relationships
    By nj_sunflower in forum Database Design
    Replies: 1
    Last Post: 03-20-2011, 09:34 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