bickyz Posted January 30, 2014 Share Posted January 30, 2014 hi all, I am trying to create a database tables for my software inventory. I have following information: The three table with green title are what I have finalised my design to; I need your expertise whether I am doing it correctly or if there is better way of doing it. Any help would be much appreciated, thank you. Quote Link to comment https://forums.phpfreaks.com/topic/285802-is-this-a-correct-way-of-creating-a-database-tables-for-my/ Share on other sites More sharing options...
Barand Posted January 30, 2014 Share Posted January 30, 2014 I think you have a table missing Room -> PC = 1 to many PC ----> Software = many to many So you need another table to link the pc with the software Quote Link to comment https://forums.phpfreaks.com/topic/285802-is-this-a-correct-way-of-creating-a-database-tables-for-my/#findComment-1467094 Share on other sites More sharing options...
bickyz Posted January 30, 2014 Author Share Posted January 30, 2014 thank you barand. Quote Link to comment https://forums.phpfreaks.com/topic/285802-is-this-a-correct-way-of-creating-a-database-tables-for-my/#findComment-1467114 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.