[RESOLVED] table structure

[scuzzo84]

I have a web app where you add software to a classroom. I have done that but, now I need to add a feature where we can keep track of number of licenses used. For example, admin enter a new piece of software, Macromedia Flash, and the number of copies he got, 50. Then he adds the software to the classroom, so that it will be listed as one of the softwares installed in that classroom lab.

Now how should I implement this feature? Currently, for the add page, you pick the classroom, and then a list of software comes and you check off what you want added. Should I have an input box after the checkbox selection to ask how many licenses are going to be used on this classroom? And then I can have a statistics page that basically takes how many copies they bought, and then subtract how many copies are used, and see how many are left.

Should I have a seperate table for how many licenses get used?

My database structure is:

building[id, name]
room [id, bid, numcomps, mtype, ctype, ptype]
software [id, title, version]
softroom [rid, sid]

[Roger_Ramjet]

Is this a project for a course then? Cos this question has been posted here before.

The basic flaw in your analysis is that software is installed on computers not on rooms.

If you want a proper asset inventory and management system then you need to have a record for each computer. You then link that computer to the software installed on it and hence to the licenses used.

The computer is also linked to the room it is located in, when the computer moves the software and licenses move with it unless you uninstall it and update the computers table.

When you add a computer to a room it does not consume a licence untill your install the software on it and update the computers table with that information.

You also calculate the used licenses by counting them in the computers table at run time and deducting that figure from the total bought.