[nfbcs] Database diagrams

[Jude DaShiell]

On the destination worksheet hide or show columns to restrict or show 
the scope of the connected relationship.
Multiple classes of users (those with different privileges) would have 
to have their own copy of the original data base model made and adjusted 
accordingly.
None of this will work if a data base model is unacceptable though.

On Tue, 24 Jan 2017, Andy B. via nfbcs wrote:

> Date: Tue, 24 Jan 2017 16:43:45
> From: Andy B. via nfbcs <nfbcs at nfbnet.org>
> To: 'NFB in Computer Science Mailing List' <nfbcs at nfbnet.org>
> Cc: Andy B. <sonfire11 at gmail.com>
> Subject: Re: [nfbcs] Database diagrams
> 
> What about M-n, 1-1, or 1-m relationships?
>
>
> -----Original Message-----
> From: nfbcs [mailto:nfbcs-bounces at nfbnet.org] On Behalf Of Jude DaShiell via
> nfbcs
> Sent: Tuesday, January 24, 2017 4:36 PM
> To: Walker, Michael E via nfbcs <nfbcs at nfbnet.org>
> Cc: Jude DaShiell <jdashiel at panix.com>
> Subject: Re: [nfbcs] Database diagrams
>
> If sql was wanted sql would have been requested.
> Actually excel can be used.
> One table on a worksheet so you have six worksheets at the end.
> details for each table on each worksheet.
> Show relationships by inserting links which when activated take a tester to
> the related table.
>
> On Tue, 24 Jan 2017, Walker, Michael E via nfbcs wrote:
>
>> Date: Tue, 24 Jan 2017 16:28:41
>> From: "Walker, Michael E via nfbcs" <nfbcs at nfbnet.org>
>> To: NFB in Computer Science Mailing List <nfbcs at nfbnet.org>
>> Cc: "Walker, Michael E" <michael.e.walker3 at boeing.com>
>> Subject: Re: [nfbcs] Database diagrams
>>
>> "Text-based notation" - might as well write the SQL.
>>
>> -----Original Message-----
>> From: nfbcs [mailto:nfbcs-bounces at nfbnet.org] On Behalf Of Vincenzo
>> Rubano via nfbcs
>> Sent: Tuesday, January 24, 2017 3:26 PM
>> To: NFB in Computer Science Mailing List
>> Cc: Vincenzo Rubano
>> Subject: Re: [nfbcs] Database diagrams
>>
>> While PlantUML does not support ER diagrams specifically, class diagrams
> can get you very close to them. However, if you don?t absolutely require a
> graphical representation, I would suggest representing the database design
> with a text-based notation.
>>
>> There are some LaTeX packages that might be useful as well, but I guess
> you?ll need some sighted assistance in making the result acceptable for
> sighted users.
>>
>>
>> Vincenzo Rubano
>> Sito Web:
>> http://www.nvapple.it
>> Sito Web personale: http://www.titengodocchio.it
>>
>> Il giorno 24 gen 2017, alle ore 22:12, Andy B. via nfbcs
> <nfbcs at nfbnet.org<mailto:nfbcs at nfbnet.org>> ha scritto:
>>
>> I need to design a database. Are there any quick reliable methods of doing
> this? So far, I have used plant uml. However, it is slow and somewhat
> problematic because it renders itself useless for database design. If there
> is something different, I will consider using it since there is no longer
> time to experiment with preprocessing, and a simple 6 table database
> shouldn't have to take 1 week of design work to finish.
>>
>>
>>
>> _______________________________________________
>> nfbcs mailing list
>> nfbcs at nfbnet.org<mailto: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/vincenzo.rubano%40s
>> tudio.unibo.it
>>
>> _______________________________________________
>> 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/michael.e.walker3%4
>> 0boeing.com _______________________________________________
>> 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/jdashiel%40panix.co
>> m
>
>

--