help: mapping ER to database
Posted: Sun Nov 02, 2008 2:27 am
hi, i am a newbie to databases.
I have a table called ' records'.
with fields as
id bios computer ram CDROM
id is the primary key of the table 'records'.. Now each id is also related to other id(s) of the same table.. like
like id=3 can be related to id=4,5,6,7,8 ... How can i store this information records table.. Currently i am adding a new column in table 'records' names as related_entries and storing the related ids and comma seperated. is this a good approach..?? or there is some better ways.. i want this schema to be very good use of db concepts..
id bios computer ram CDROM related_entries
3 OK OK OK OK 4,5,6,7,8,9,0
4 OK OK OK OK 7,3,5,6,7
5 OK OK OK OK 55,22,33,2
thanking in anticipation.
regards.
I have a table called ' records'.
with fields as
id bios computer ram CDROM
id is the primary key of the table 'records'.. Now each id is also related to other id(s) of the same table.. like
like id=3 can be related to id=4,5,6,7,8 ... How can i store this information records table.. Currently i am adding a new column in table 'records' names as related_entries and storing the related ids and comma seperated. is this a good approach..?? or there is some better ways.. i want this schema to be very good use of db concepts..
id bios computer ram CDROM related_entries
3 OK OK OK OK 4,5,6,7,8,9,0
4 OK OK OK OK 7,3,5,6,7
5 OK OK OK OK 55,22,33,2
thanking in anticipation.
regards.