By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,373 Members | 2,961 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,373 IT Pros & Developers. It's quick & easy.

Please Suggest for this non relational design

P: n/a
HI all,

I have to desing a database in access for HRD Department of a
company.. and here the problem is that they want a facility so that
they can increase the columns of the Employee table with it's data
type... same as one can do in MS Excel ..Because somtimes there
central body ask them different thing of which they have no idea.

I know this will make data base no more relational..

what i have thought of structure like this

Employee(
ID, <-- uniq id
Name
:
:
:
)

Then there will be one More table which will have one to many
relationship with Employee table and
Columnname(
id
Colname
)

Others(
EmpID, <-- fkey to Employee.ID
Data
Columnid <-- fkey to Column.id.ID

)

but in this type the datatype can only be text and has to be fixed ..

there is one more option is to increase the columns dynamically and
will not help in serching and reporting ...

reply please if someone have any suggestion ..

Thanks in advance..

viks
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Let them create a separate table where they can add all the fields
they want. Then create a PK of the same type as the original table.
Create a outer joined query between this and the main table and they
can get all the information they want.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.