Most RDB designers will accept that in order to deal with the complexities of "real life" transactions, a design needs to reach
third normal form
the standard of a flat file
second normal form
first normal form