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 Quote 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? Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.