normalization

[vlad123]

Hi! I have a problem in finding the best way to store all information that I can find on Internet about every company into a database. I mean, I need to find an Entity Relationship Model. But,I am confused, because first I thought to have something like this:
Branch{id_b, branch}
Company {id_c, id_b, company}
Brands {id_brand, id_c, brand}
Products {id_p, id_brand, product, caracteristics}
but, I dont know how to store information about history, financials,board of management, or some articles about these companies, or other things.
as well I need a table like:
internet_sources {id, type, url, contence}
so, if you have any sugestions, please help me!
thanks!

 

[HarleyQuinn]

From the sound of this I would seriously reconsider your plan. If I have understood correctly your plan this is an IMMENSE task, and would require a database of epic proprotions.

What purpose does this serve???

HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.

 

[vlad123]

Its an application for banks, for example. For people that want to invest money in a company and need all information about this. Yes, its an immense task, and I need some opinion about this subject.

 

[HarleyQuinn]

Ah, I had slightly misunderstood. I thought you meant to retrieve and store information about every company on the internet.

Saying that I agree with you, it is still an immense task. You are however in the right place for the best advice

HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.

 

[vlad123]

The problem is that somehow you are right. because this application will be for different users with different requests.so, I need to have an imense database with almost all companies, from different branch and countries.
But, for now, I have to find this Entity Relationship Model, not the perfect one, but one that I can use properly.

 

[TheAceMan1]

How are ya vlad123 . . . . .

First you have to define all your fields (required info). After that, have a look below:

Fundamentals of Relational Database Design Normalizing Tables Table Relationships

See Ya! . . . . . .