[NFBCS] Many-to-Many Relations

[Chris Nestrud]

I'll either write something similar to SQL to work out the
relationships, or I'll use Excel, with one sheet per entity and one row
per column. Excel works well because it's faster for me to move a single
row between sheets than to work with many lines of text.

It may also help to look at the database schemas of some open-source
projects as examples.

Chris

On Wed, Jul 28, 2021 at 12:19:21PM +1000, Nathaniel Schmidt via NFBCS wrote:
> HI all,
> 
>  
> 
> Not sure if this is more of a conceptual of a visual issue for me.  But I
> was wondering if anyone has developed a way for a blind person to be able to
> conceptualise, if not visualise, a many-to-many, or M:N, or *..*
> relationship within the logical design of a relational database model?
> 
>  
> 
> I'm struggling with this idea in developing a design for a series of entity
> relationships, which I know must somehow involve a collation of several
> one-to-many (1:M or 1..*) relationships, which can be a little difficult to
> develop in of themselves.
> 
>  
> 
> I'm thinking of something in the context of a relational database structure
> built with SQL (Oracle DBMS).  I need to figure out how and which primary
> vs. foreign keys need to be included so that I can develop the associative
> entity, or composite / bridge table structure.
> 
>  
> 
> Any suggestions would be appreciated.
> 
>  
> 
> Regards,
> 
>  
> 
> Nathaniel
> 
>  
> 
> ========================================
> 
> Nathaniel Schmidt
> 
> Undergraduate student
> 
> Bachelor of Computer Science (S306)
> 
> School of Information Technology
> 
> Faculty of Science, Engineering and Built Environment
> 
> Deakin University, Melbourne (Burwood) campus
> 
> https://www.deakin.edu.au/
> 
> E: njschmidt at deakin.edu.au <mailto:njschmidt at deakin.edu.au> 
> 
> LinkedIn: https://www.linkedin.com/in/njsch/
> 
> GitHub: https://github.com/njsch/
> 
> Skype: nathaniel_schmidt1994
> 
> about.me/njschmidt/ <https://about.me/njschmidt/> 
> 
>  
> 
> _______________________________________________
> NFBCS mailing list
> NFBCS at nfbnet.org
> http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
> To unsubscribe, change your list options or get your account info for NFBCS:
> http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/ccn%40chrisnestrud.com