Go Back   Access World Forums > Microsoft Access Discussion > Theory and practice of database design

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-08-2019, 01:17 PM   #16
MrHans
Newly Registered User
 
Join Date: Jul 2015
Location: NL - Amsterdam
Posts: 108
Thanks: 39
Thanked 10 Times in 10 Posts
MrHans is on a distinguished road
Re: Advice on proper normalization

Clear, thank you very much June7.

I agree that it will be much easier to retrieve the data when I store it horizontally, like it shows on the source.

Back to the drawing board it is...

MrHans is offline   Reply With Quote
Old 01-09-2019, 06:58 AM   #17
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 13,082
Thanks: 69
Thanked 1,368 Times in 1,260 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Advice on proper normalization

With 70 separate attributes, the JOIN would almost certainly reach a limit if you had 70 different attribute tables. Using an object table as the parent and an enumeration table of each attribute's name (or code) and value, you can have 1000 distinct attributes. The mental image is harder but has fewer limits.

__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
The Following User Says Thank You to The_Doc_Man For This Useful Post:
MrHans (01-09-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Advice and integer and long advice required smiler44 Excel 4 10-30-2013 07:50 AM
Advice needed on DB set-up & Normalization for Novice AccessWomble Tables 3 12-04-2009 09:15 AM
Some Advice on Normalization davefwelch Tables 1 09-12-2009 02:01 PM
Proper relationships tas666 General 2 06-05-2005 05:52 PM
Proper captnk Tables 1 09-01-2003 12:03 AM




All times are GMT -8. The time now is 06:02 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World