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. 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 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. 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
Archived
This topic is now archived and is closed to further replies.