The Student Room Group

Quick Normalisation Question

Hey, I was revising some Normalisation today and I wasnt sure what to do in the following case.

[ID**, firstname, surname, email]
(1 table)
For the above to be in 3rd normal form, would it be acceptable as it is or would it need breaking down like as follows?

ID**, firstname
ID**, surname
ID**, email
(3 tables)

:smile:
Reply 1
1 table.

Quick Reply

Latest

Trending

Trending