CODEWITHSUNDEEP
databaseschemaerd
zohaibkhan
zohaibkhan

Reputation: 71

Normalize address in database

I am working on normalizing a table which contains institute column that contains institute id, institute name, and institute city, all in one single column.
First normal form says that every column should be atmoic.
So to make it normal, I created a new table and assign insituteID to previous table (from which I am linking the new table), and this instituteID would be the primary key in new table.
So my question is, Is I am going the right way?
I searched it on the net but couldn't get satisfactory answer.

Upvotes: 0

Views: 51

Answers (1)

inampaki
inampaki

Reputation: 159

How could these values come in one single column. This is naturally a single relation (table). And all these attributes are atomic. So in my opinion this relation is already in 1st NF. - An institute can not have more than one id, id column is atomic. - An institute can not have more than one name so institute name is also atomic. - An institute can not be situated in more than one city so institute city is also atomic

Upvotes: 1

Related Questions