Mike Eghtebas
asked on
Relational Database Schemas (RDS)
I want to produce an image like the one below:
One way to have the table’s relational schema is to select Query/Design Query in Editor… from the menu to bring up Query Designer and Add Table interfaces.
After doing this I can get screen-shot of this and I am done.
Q1: Is there a better way of doing this (I am using SQL-Server 2008R). Please list the steps for me to be able to duplicate it.
Q2: Is Relational Database Schemas (RDS) a proper title for this image?
Thank you.
RelationalSchema.png
One way to have the table’s relational schema is to select Query/Design Query in Editor… from the menu to bring up Query Designer and Add Table interfaces.
After doing this I can get screen-shot of this and I am done.
Q1: Is there a better way of doing this (I am using SQL-Server 2008R). Please list the steps for me to be able to duplicate it.
Q2: Is Relational Database Schemas (RDS) a proper title for this image?
Thank you.
RelationalSchema.png
ASKER
re:> Q1: MS Visio rocks for this, but you can do it in SQL
Could you show me how is it done in 2008R?
Could you show me how is it done in 2008R?
Create a database, Expand database diagrams, select yes to creating one... right click, new database diagram. add your tables. However, this relies on tables being created, with required columns. Visio is much easier, and you can create the tables on the fly, and even script it to create the tables in a database.I would just get a free trial of that if you are just starting out.
ASKER
> Create a database
I have this already.
> Expand database diagrams
How? give me the steps to do this as requested in the origninal question.
> Visio is much easier
I will not be working with visio.
I have tables ready and wand the proper way of viewing the relational diagram.
I have this already.
> Expand database diagrams
How? give me the steps to do this as requested in the origninal question.
> Visio is much easier
I will not be working with visio.
I have tables ready and wand the proper way of viewing the relational diagram.
Database Diagrams is a node under the database. If you do not have it, it may not be available in your version of SQL.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am not able to test the posted solutions because:
https://www.experts-exchange.com/questions/27289906/Log-in-to-SQL-Server.html
I am not able to log-in. I wonder if you have the time to post a comment in this link.
Thanks,
Mike
https://www.experts-exchange.com/questions/27289906/Log-in-to-SQL-Server.html
I am not able to log-in. I wonder if you have the time to post a comment in this link.
Thanks,
Mike
ASKER
dqmq,
This was interesting. As you can see below, I am getting a diagram a bit different than what I have submitted above. My diagram connects PKs to FKs but with your solution it shows the links between the tables without identifying what fields are involved in the relationship.
I guess my submission may be called Relationship Schema and what I got from your solution below could be called Entity Relationship Diagram (ERD).
Do you have any comment on this?
Thanks,
Mike
EntityRelationShipDiagram.png
This was interesting. As you can see below, I am getting a diagram a bit different than what I have submitted above. My diagram connects PKs to FKs but with your solution it shows the links between the tables without identifying what fields are involved in the relationship.
I guess my submission may be called Relationship Schema and what I got from your solution below could be called Entity Relationship Diagram (ERD).
Do you have any comment on this?
Thanks,
Mike
EntityRelationShipDiagram.png
ASKER
Also, please note the diamond shapes on the original diagram on the top. It seems they are used in entity relationship diagram. Meaning, that one may be an Entity Relationship Diagram and the one here is Relationship Schema Diagram.
ASKER
Q2: Sure, some might just call it a database diagram.