table structure.

our company has some basic table column list, and I would like to share from you guys, by this, any suggestion/improvement can be seen from modelling and UML point of view.


table column
table name are :
1) tr_po_header
2)tr_po_misc
3)tr_po_detail
4) tr_po_detail_misc
5) tr_po_detail_ctc_archive

all the row below that table is the column name.
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Data DudeCommented:
You'll want to provide some details as to what these tables are, and the FK's involved, as experts here cannot connect to your data source, look at data, and run queries, so we are limited in answering 'Here's my design, please improve it' style questions.
marrowyungSenior Technical architecture (Data)Author Commented:
the color field is the one we use to join ,and the first 2 x column of each table is the primary key field.
Vitor MontalvãoMSSQL Senior EngineerCommented:
It will be very hard to give you any good advice base on the figure.
Do you have a data model that you can share with us?
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

marrowyungSenior Technical architecture (Data)Author Commented:
at this moment, this is the only piece of record I have and will have more in 2 weeks.

all color field is the column we used to join.

any suggestion like:
1) a table has too much column, normalize it?
marrowyungSenior Technical architecture (Data)Author Commented:
I am sorry, I don't have much in data modeling information as this is a development task and I am not the developer.

any tools I can use to see the existing ER modeling or data modeling ? preferably with lines between them to show relationship ?
Vitor MontalvãoMSSQL Senior EngineerCommented:
In SSMS under each database you'll find an option called Database Diagrams. You can create there a new diagram and add those tables. Any existing relationship will be show.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
marrowyungSenior Technical architecture (Data)Author Commented:
I can't figure it out . any step by step guide on it ?
Vitor MontalvãoMSSQL Senior EngineerCommented:
There's no much to learn about Database Diagrams. It's really very direct and easy to work with. Here's the MSDN article about it.
marrowyungSenior Technical architecture (Data)Author Commented:
I am sorry Vitor, so the data model you all are referring is about the database diagram, right?

but the link you show me is about creating a new database diagram.

tks anyway.
marrowyungSenior Technical architecture (Data)Author Commented:
I think at the beginning, no diagram is normal even table structure is here, right?

so we need to create a new one and it will check all table structure and generate a diagram for us ?
marrowyungSenior Technical architecture (Data)Author Commented:
"Any existing relationship will be show. "

for me I don't see relationship shown.
marrowyungSenior Technical architecture (Data)Author Commented:
I am sorry, if we change anything in the diagram which related to the table design, will it reflect on the table schema level too ?

I am talking about data modeling design.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.