Results 1 to 2 of 2
  1. #1
    Grafixx01 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    13

    See issues?

    Ok, just wondering if anyone can help me out with this DB? I work in insurance and am tasked with tracking prescriptions that are paid for and who writes them, etc etc. Just wondering if I have the relationships and design right?

    Some of the fields (ie: DEA Number, DEA Schedule Number, Drug Category, NPI Number, State are fields that like do not change). These fields are constant and won't change.

    **I haven't messed with Access in a very long time (10+ years) so be gentle...

    Click image for larger version. 

Name:	Relationships.jpg 
Views:	23 
Size:	85.8 KB 
ID:	44860

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    It depends on the nature of a business, which is clear to you but not us (OK, at least not me). F'rinstance your design suggests that a prescriber id can relate to many patients. However, if a patient can have more than one prescriber it is not correct. You then have a many to many relationship, not one to many as you've designed for. To handle many to many relationships you need 2 primary tables and one linking table (aka junction table). You might have other similar situations (e.g. dea to pharmacy). So without knowing the details of what the db is supposed to support, no one can definitively say whether or not you have it right just yet. A review of db normalization might be in order:

    Normalization Parts I, II, III, IV, and V
    http://rogersaccessblog.blogspot.com...on-part-i.html
    and/or
    http://holowczak.com/database-normalization/

    Entity-Relationship Diagramming: Part I, II, III and IV
    http://rogersaccessblog.blogspot.com...ng-part-i.html
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Issues Using IE
    By June7 in forum Forum Suggestions
    Replies: 11
    Last Post: 06-08-2019, 11:29 AM
  2. Trying something new and having issues
    By Dave14867 in forum Access
    Replies: 2
    Last Post: 04-03-2019, 03:03 AM
  3. Many to Many Issues
    By chrisdogg in forum Forms
    Replies: 5
    Last Post: 01-11-2017, 05:26 PM
  4. Relationship issues
    By Androo in forum Access
    Replies: 4
    Last Post: 10-14-2015, 12:21 PM
  5. Help - Having Issues With Database
    By hurly1223 in forum Access
    Replies: 3
    Last Post: 06-05-2013, 03:18 PM

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