marrowyung
asked on
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 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.
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.
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.
ASKER
the color field is the one we use to join ,and the first 2 x column of each table is the primary key field.
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?
Do you have a data model that you can share with us?
ASKER
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?
all color field is the column we used to join.
any suggestion like:
1) a table has too much column, normalize it?
ASKER
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 ?
any tools I can use to see the existing ER modeling or data modeling ? preferably with lines between them to show relationship ?
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 can't figure it out . any step by step guide on it ?
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.
ASKER
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.
but the link you show me is about creating a new database diagram.
tks anyway.
ASKER
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 ?
so we need to create a new one and it will check all table structure and generate a diagram for us ?
ASKER
"Any existing relationship will be show. "
for me I don't see relationship shown.
for me I don't see relationship shown.
ASKER
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.
I am talking about data modeling design.