Hello to everyone,
I have to design a database with the following data (You can see attached also the data):
DevID DevModel SoftwareInstalled SoftTobeInstalled SoftRemoved
1 Lenovo x62 Microsoft Office Antivirus Skype
2 HP D46 Winamp Skype Win Media
3 Toshiba BT45 Win Media Outlook Antivirus
I am so confused...:banghead:
I will have a table Device( int DeviceID, char DeviceModel, etc.) but what I can do with the Software table?
I have Softwares that can be in many devices but also softwares can be in different categories (Installed, To be installed, Removed).
Could anyone propose me how to design this database?
Shall I create one more table for Software Categories?
Thank you very much for your help in advance.
Vangelis
I have to design a database with the following data (You can see attached also the data):
DevID DevModel SoftwareInstalled SoftTobeInstalled SoftRemoved
1 Lenovo x62 Microsoft Office Antivirus Skype
2 HP D46 Winamp Skype Win Media
3 Toshiba BT45 Win Media Outlook Antivirus
I am so confused...:banghead:
I will have a table Device( int DeviceID, char DeviceModel, etc.) but what I can do with the Software table?
I have Softwares that can be in many devices but also softwares can be in different categories (Installed, To be installed, Removed).
Could anyone propose me how to design this database?
Shall I create one more table for Software Categories?
Thank you very much for your help in advance.
Vangelis
Attachments
Last edited: