Feedback Needed

[prabha_friend]

 

[MajP]

I would never name all my PKs "ID". This is super confusing in queries, code, and requires full "TableName.FieldName" declaration in queries. In fact I never name two fields the same in different tables. I would have Submission_ID as a PK and Submission_ID_FK for all foreign keys.

 

[The_Doc_Man]

@prabha_friend - you do this frequently. When you show us something and ask for comments, it would be REALLY helpful to know what it is for. This looks like it MIGHT be related to some sort of technical presentation tracking in some educational context. But I have no clue of the rules or goals so to me this is just a bunch of boxes with funny lines connecting some of them.

 

[AccessBlaster]

DATETIME appears to be a reserved word

 

[prabha_friend]

@prabha_friend - you do this frequently. When you show us something and ask for comments, it would be REALLY helpful to know what it is for. This looks like it MIGHT be related to some sort of technical presentation tracking in some educational context. But I have no clue of the rules or goals so to me this is just a bunch of boxes with funny lines connecting some of them.

Got hired in an National Institute for Food Technology, Research and Development.

 

[jdraw]

So, what is the business in overview?
What are the primary business rules?
What is your role?
What is the requirement specifically?

Read and review Doc's comment in #3.

"Got hired in an National Institute for Food Technology, Research and Development."
??As custodian
??As DBA
?? As Communications manager
??As Finance Officer
??As Process reviewer

With 630 posts, you can certainly do better to make a meaningful request.

 

[prabha_friend]

DATETIME appears to be a reserved word

Wondering why the application hasn't warned me...

 

[prabha_friend]

So, what is the business in overview?
What are the primary business rules?
What is your role?
What is the requirement specifically?

what is the business in overview?
Research to Develop new product or service to assist in Food Technology.
What are the primary business rules?
Providing Education and Helping researchers in publish papers on the same.
What is your role?
RAD (Rapid Application Developer)
What is the requirement specifically?
To Automate whatever is possible to do...

 

[The_Doc_Man]

Confirming: DATETIME is indeed a reserved word.

List of reserved words in Access - Microsoft 365 Apps

Lists the reserved words that you should not use in field, object, and variable names. It is not practical to provide a list of all reserved words, such as built-in function names or Access user-defined names.

learn.microsoft.com

DATETIME function - Microsoft Support

support.microsoft.com

Apps don't warn about reserved words. They just break when you use them ambiguously. I can't tell you how often we have seen users who have DATE or SUM or other reserved words in a query as field names rather than function names.

 

[prabha_friend]

Confirming: DATETIME is indeed a reserved word.

List of reserved words in Access - Microsoft 365 Apps

Lists the reserved words that you should not use in field, object, and variable names. It is not practical to provide a list of all reserved words, such as built-in function names or Access user-defined names.

learn.microsoft.com

DATETIME function - Microsoft Support

support.microsoft.com

Apps don't warn about reserved words. They just break when you use them ambiguously. I can't tell you how often we have seen users who have DATE or SUM or other reserved words in a query as field names rather than function names.

Usually it does for "Name" and "Date". I change it to "NameVal" and "DateVal" respectively.

 

[MajP]

This is my personal opinion and I have read others with the oppositte opinion.
I just find it easier for me to be more explicit in my naming especially since I write a lot of code. And post of lot of code. I like to be able to see a field name and know exactly what it is. I have read others say this this redundant. I just find it makes it a lot easier for me and less confusing.
I am always specific with my field names. I would always have
Author_Email and Approver_Email
I know immediately what email I am talking about, and do not want to be forced to write queries or codes that have to be
[Authors]. , [Approvers].[Email]
I would NEVER have DateTime, because it is not descriptive of anything.
With your naming, I may switch around
NameVal_NatureType
NameVal_CommType
NameVal_Author

 

[jdraw]

You appear to be the master of minimalisation.

"To Automate whatever is possible to do..."

I asked Chatgpt on your behalf:
What types of things would be involved in doing Research to Develop new product or service to assist in Food Technology?

And he/she responded with the following which should help put some focus on most probable activities.

ChatGPT response:

When conducting research to develop a new product or service to assist in food technology, several aspects need to be considered. Here are some key areas and activities involved in the research process:

1. Market Analysis: Conduct a thorough analysis of the food technology market, including trends, consumer preferences, and competitors. Identify gaps and opportunities where a new product or service could add value.
2. Consumer Insights: Gather insights into consumer needs, expectations, and pain points related to food technology. This can be done through surveys, focus groups, interviews, or observation studies.
3. Ideation and Concept Development: Brainstorm and generate ideas for new products or services that address the identified market gaps and consumer needs. Develop concepts and prototypes to validate and refine the ideas.
4. Scientific Research: Depending on the nature of the product or service, scientific research may be required. This could involve studying food chemistry, microbiology, nutritional analysis, or other relevant scientific disciplines to ensure safety, quality, and efficacy.
5. Product Development: Once the concept is validated, proceed with product development, which includes recipe formulation, ingredient sourcing, packaging design, and prototyping. Iteratively refine the product through testing and feedback.
6. Testing and Validation: Conduct thorough testing to ensure the product meets quality, safety, and regulatory standards. This may involve sensory evaluations, shelf-life testing, stability studies, and compliance with food regulations.
7. Technology Integration: Incorporate technological advancements into the product or service. This could involve leveraging automation, robotics, data analytics, or artificial intelligence to optimize processes, enhance food safety, or improve efficiency.
8. Production Scaling: Develop a plan for scaling up production, considering factors such as manufacturing capabilities, supply chain management, cost optimization, and ensuring consistent product quality.
9. Market Testing: Conduct small-scale trials or pilot programs to test the product or service in real-world settings. Collect feedback from users, assess market acceptance, and identify areas for improvement.
10. Marketing and Launch: Develop a comprehensive marketing strategy to introduce the product or service to the target audience. This includes branding, packaging, pricing, distribution channels, and promotional activities.
11. Post-launch Evaluation: Continuously monitor and evaluate the performance of the product or service in the market. Gather customer feedback, analyze sales data, and make necessary adjustments to improve the offering.

Throughout the entire research process, collaboration with cross-functional teams comprising food scientists, engineers, designers, marketers, and business experts is crucial to ensure a holistic approach and successful development of a new product or service in food technology.

 

[prabha_friend]

You appear to be the master of minimalisation.

"To Automate whatever is possible to do..."

I asked Chatgpt on your behalf:
What types of things would be involved in doing Research to Develop new product or service to assist in Food Technology?

And he/she responded with the following which should help put some focus on most probable activities.

ChatGPT response:

When conducting research to develop a new product or service to assist in food technology, several aspects need to be considered. Here are some key areas and activities involved in the research process:

1. Market Analysis: Conduct a thorough analysis of the food technology market, including trends, consumer preferences, and competitors. Identify gaps and opportunities where a new product or service could add value.
2. Consumer Insights: Gather insights into consumer needs, expectations, and pain points related to food technology. This can be done through surveys, focus groups, interviews, or observation studies.
3. Ideation and Concept Development: Brainstorm and generate ideas for new products or services that address the identified market gaps and consumer needs. Develop concepts and prototypes to validate and refine the ideas.
4. Scientific Research: Depending on the nature of the product or service, scientific research may be required. This could involve studying food chemistry, microbiology, nutritional analysis, or other relevant scientific disciplines to ensure safety, quality, and efficacy.
5. Product Development: Once the concept is validated, proceed with product development, which includes recipe formulation, ingredient sourcing, packaging design, and prototyping. Iteratively refine the product through testing and feedback.
6. Testing and Validation: Conduct thorough testing to ensure the product meets quality, safety, and regulatory standards. This may involve sensory evaluations, shelf-life testing, stability studies, and compliance with food regulations.
7. Technology Integration: Incorporate technological advancements into the product or service. This could involve leveraging automation, robotics, data analytics, or artificial intelligence to optimize processes, enhance food safety, or improve efficiency.
8. Production Scaling: Develop a plan for scaling up production, considering factors such as manufacturing capabilities, supply chain management, cost optimization, and ensuring consistent product quality.
9. Market Testing: Conduct small-scale trials or pilot programs to test the product or service in real-world settings. Collect feedback from users, assess market acceptance, and identify areas for improvement.
10. Marketing and Launch: Develop a comprehensive marketing strategy to introduce the product or service to the target audience. This includes branding, packaging, pricing, distribution channels, and promotional activities.
11. Post-launch Evaluation: Continuously monitor and evaluate the performance of the product or service in the market. Gather customer feedback, analyze sales data, and make necessary adjustments to improve the offering.

Throughout the entire research process, collaboration with cross-functional teams comprising food scientists, engineers, designers, marketers, and business experts is crucial to ensure a holistic approach and successful development of a new product or service in food technology.

Looks like I got lot work to do in future

 

[jdraw]

Given the list of possible activities, I then asked:
"Could you suggest a very overview data model?"

To which, I received the following response:

Certainly! Here's an example of a high-level overview data model that can be used as a starting point for developing a new product or service in food technology:

1. Product/Service: The main entity representing the product or service being developed. It would include attributes such as name, description, category, and unique identifier.
2. Ingredients: A list of ingredients used in the product, including their names, quantities, and any additional information such as nutritional values or allergen information.
3. Recipe: If applicable, the recipe entity would contain information about the specific steps and instructions for preparing the product. This could include the order of ingredient mixing, cooking temperatures, and cooking times.
4. Nutritional Information: This entity would store data related to the nutritional composition of the product, including macronutrients (such as carbohydrates, proteins, and fats) and micronutrients (such as vitamins and minerals). It may also include allergen information and dietary restrictions.
5. Packaging: Information about the packaging materials, dimensions, and any relevant labeling requirements would be stored in this entity.
6. Production: This entity would capture details about the production process, such as manufacturing facilities, equipment used, production steps, and quality control measures.
7. Market Analysis: Data related to market analysis, including consumer insights, market trends, competitor analysis, and target demographics.
8. Sales and Distribution: Information about sales channels, distribution networks, pricing, promotions, and customer feedback.
9. Regulatory Compliance: If applicable, this entity would include information on relevant food regulations, certifications, and compliance requirements.
10. Research and Development: Data related to scientific research, testing protocols, product development iterations, and any intellectual property associated with the product or service.

It's important to note that the specific entities and attributes within the data model would vary depending on the nature of the product or service being developed in food technology. This high-level overview provides a starting point, and further refinement and customization can be done based on the specific requirements of the project.

 

[prabha_friend]

I am building on Descending Order (Point No:10)

 

[jdraw]

Great! I hope the chatgpt info is helpful. Easy to ask and receive and free.