Home » SQL & PL/SQL » SQL & PL/SQL » Table design (Oracle 10g and Windows 2003)
Table design [message #442302] Sat, 06 February 2010 12:44 Go to next message
aijaz786
Messages: 91
Registered: February 2010
Member
Hi every body,

I am new to this forum and I am really impressed by the forum and above all doubt, it is very very beneficial to Database professional.

I have an issue and need advice to resolve the same.

I need to design a database. The scenario is:

I have technical drowings from various projects and we store all these in document management systems with all its attributes. Each drawing has number of tags for equipments installed on a project. Each drowing may have 0,1 or many tags and each tag may be associated with 0, 1, or many projects.

It looks like many to many relationship between drawing and tags numbers.

I need help to desgin this database.

Thanks.


Re: Table design [message #442305 is a reply to message #442302] Sat, 06 February 2010 13:23 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>I need help to desgin this database.
design to Third Normal Form
GOOGLE is your friend, but only when you actually use it.
Re: Table design [message #442307 is a reply to message #442302] Sat, 06 February 2010 13:38 Go to previous message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can read the following Wiki page: Normlization.

Regards
Michel
Previous Topic: how to remove special character and albhabet in the given string
Next Topic: Add patition to existing table
Goto Forum:
  


Current Time: Thu Dec 08 03:49:54 CST 2016

Total time taken to generate the page: 0.13170 seconds