Web Wiz Forums - Question about database

Print Page | Close Window

Question about database

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=922
Printed Date: 29 March 2026 at 8:07pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Question about database

Posted By: boyohboy
Subject: Question about database
Date Posted: 11 March 2003 at 12:22pm

If borg or anyone could answer, thanks.

What's the "Relationship" diagram for? Is it just for us humans to read and understand more easily? To the system, it doesn't affect one way or the other, correct?

-------------
Visit my community website @
http://www.everythingviet.com - EverythingVIET.com

Replies:

Posted By: robert2504
Date Posted: 11 March 2003 at 12:33pm

If you mean ERDs; those are entity relationship diagrams. Those are used to illustrate the logical structure of the database. It is kind of the like blue prints for a house. It does not physically affect the system but logically it can produce a poor structured database fill with redundancy and produce wrong data. I myself do not use erd for access databases. I only use ERD for my SQL Server Databases. My access databases are used only as the beginning of a SQL Server Database.

Sorry if I confused you a bit

-------------
Robert Hernandez

Web Applications Analyst

http://www.valley-programmers.com - Valley Programmers

Posted By: boyohboy
Date Posted: 11 March 2003 at 1:14pm

thanks robert
I got it.

-------------
Visit my community website @
http://www.everythingviet.com - EverythingVIET.com

Posted By: michael
Date Posted: 11 March 2003 at 3:00pm

Actually if you are talking about the Diagram in SQL Server it DOES change the database if you save changes. You can create relationships, att columns etc. If you just move the tables around to visualize the structure, Robert is right.