Solved

Relational Database Schemas (RDS)

Posted on 2011-09-02
10
776 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:Mike Eghtebas
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
10 Comments
 
LVL 6

Expert Comment

by:markterry
ID: 36475111
Q1: MS Visio rocks for this, but you can do it in SQL
Q2: Sure, some might just call it a database diagram.
0
 
LVL 34

Author Comment

by:Mike Eghtebas
ID: 36475189
re:> Q1: MS Visio rocks for this, but you can do it in SQL

Could you show me how is it done in 2008R?

0
 
LVL 6

Expert Comment

by:markterry
ID: 36475271
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.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 34

Author Comment

by:Mike Eghtebas
ID: 36475336
> 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.
0
 
LVL 6

Expert Comment

by:markterry
ID: 36475408
Database Diagrams is a node under the database. If you do not have it, it may not be available in your version of SQL.
0
 
LVL 42

Accepted Solution

by:
dqmq earned 500 total points
ID: 36475436
>Expand database diagrams

Not quite that simple.  In object explorer, click on the plus sign next to the database of interest to expand the list sub-objects.  One of them will be database diagrams.  Right click and choose "New Diagram".   Then customize to for the tables and relationships that you want to see in the diagram.  You can have multiple diagrams using subsets of the tables to present different perspectives or to keep a single diagram from getting too busy.

As an aside, you do realize that your design only permits one inventory item on an invoice?
0
 
LVL 34

Author Comment

by:Mike Eghtebas
ID: 36479269
I am not able to test the posted solutions because:

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_27289906.html

I am not able to log-in. I wonder if you have the time to post a comment in this link.

Thanks,

Mike
0
 
LVL 34

Author Comment

by:Mike Eghtebas
ID: 36479503
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
0
 
LVL 34

Author Comment

by:Mike Eghtebas
ID: 36479575
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.
0
 
LVL 34

Author Closing Comment

by:Mike Eghtebas
ID: 36479670
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question