Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    Edgar is online now Competent Performer
    Windows 8 Access 2016
    Join Date
    Dec 2022
    Posts
    271
    Thank you for your insights, orange.


    > 3 A Project is defined and initiated and sent to the Inspector. You need a definition of a Project (who,what,when,where,how much and how often..)
    Please keep in mind that the Inspections business is as pragmatic as something can be. Systems must be designed to achieve a result within the boundaries of law, they're not interested in recording anything else but the very essential. The project in this case is merely the boolean "projectExists". After that, during the visit, any observation in project or on site, is recorded in the visits table and as trivial as it can be, it can go either in one field or several records in an observations table with a VisitID FK, does not matter for the scope of the thread.

    > These points must be clearly identified. What exactly is it (in the it'll)
    "It" refers to the inspection.

    > 6 Somewhere, the client must arrange with a third party the actual physical work. This is not part of the Inspector's work.
    The physical work, if required, is not a concern for the Inspector. The inspector will compare the electrical project and the electrical installation to notify of the differences, errors and omissions found in both. This is recorded in the visits table.

    > But your potential data models in post #7 above has an abundance of people and roles. This cannot be unimportant if your model is anywhere reflective of the business.
    There are many people involved, but it is not important to record the interactions, only their names, data and the role. The role in the context of the inspection is enough to know what they did and at what point. Further details are not important, if added they would represent data that inspectors won't use, making them waste time.

  2. #17
    Edgar is online now Competent Performer
    Windows 8 Access 2016
    Join Date
    Dec 2022
    Posts
    271
    It's been a while. I guess people enter here and get confused thinking I'm using repeating tables, which I'm not, so if it won't help people, I better let it die and ask some other time.

    Please someone delete this thread.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 16
    Last Post: 07-20-2016, 08:13 AM
  2. Table Structure for Simple Database
    By lwflip in forum Database Design
    Replies: 1
    Last Post: 04-07-2016, 07:29 AM
  3. Adding people to case table from people table.
    By fuonge in forum Database Design
    Replies: 2
    Last Post: 09-22-2015, 11:53 AM
  4. Replies: 2
    Last Post: 05-24-2015, 01:28 PM
  5. Replies: 1
    Last Post: 08-06-2014, 02:22 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