hai

this is how my project databse luks like

different types of industries,with each company having many phonenumbers and email ids..ll industry will have a separate serial numbers

but the point to be noticed is that for all industry the table fields are one and the same...nothing differs...

wht should i do?

is it better to have create a separate in table for all industry thought they have the same columns


pls help

Recommended Answers

All 4 Replies

I would recommend having one table to store all the industries and have a type field to record the different types of industry.

create two tables and link them by using primay key and foreign key.

can anyone enlighten me on functional dependancies and canonical cover.i need it for my exam

create a new thread rather than posting in this thread and we might be able to

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.