runeveryday Posted September 8, 2009 Share Posted September 8, 2009 Title | ISBN |Price |Cust. name | Cust. address |Purch. date PHP Cookbook |0596101015 |44.99 | Emma Brown 1565 Rainbow Road |Mar 03 2009 Dynamic HTML |0596527403 |59.99| Darren Ryder 4758 Emily Drive |Dec 19 2008 PHP and MySQL| 0596005436| 44.95| Earl B. Thurston 862 Gregory Lane |Jun 22 2009 PHP Cookbook| 0596101015 |44.99 | Darren Ryder 4758 Emily Drive| Dec 19 2008 Link to comment https://forums.phpfreaks.com/topic/173505-is-this-table-fit-for-1nf/ Share on other sites More sharing options...
runeveryday Posted September 8, 2009 Author Share Posted September 8, 2009 i see there remain duplications Darren Ryder and 4758 Emily Drive, so i think its fail 1NF is it right? Link to comment https://forums.phpfreaks.com/topic/173505-is-this-table-fit-for-1nf/#findComment-914581 Share on other sites More sharing options...
kickstart Posted September 8, 2009 Share Posted September 8, 2009 Hi Logically the books are purchased by people. Have a table of people and a table of books, and a table list when people buy particular books. This way there should be no duplicated data, hence effectively first normal form. All the best Keith Link to comment https://forums.phpfreaks.com/topic/173505-is-this-table-fit-for-1nf/#findComment-914688 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.