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
Messages: 91
Registered: February 2010
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.


Re: Table design [message #442305 is a reply to message #442302] Sat, 06 February 2010 13:23 Go to previous messageGo to next message
Messages: 25524
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: 65082
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can read the following Wiki page: Normlization.

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

Current Time: Fri Jul 21 02:02:47 CDT 2017

Total time taken to generate the page: 0.12536 seconds