For all the accounts that have authority="admin", set permision to modify all of the files (attribute changes is datatype YES/NO),,, so basically a user can set yes or no depends on his will.
For each directory, print out his name, in which directory it is located, and how many subdirectories does it have. It is necessary to print out those directories which aren t found in a directory(don t have parentdirectories) and those whith no subdirectories
Find 10% of the largest directories wich do not have subdirectories. The size of the directory without the subdirectory is equal to the sum of size of all directories wich are inside the directory. Write out directoryID, name of the directory and size.
This is what i have tried so far but i m really confused with this ones.
1) SELECT * FROM accounts WHERE authorities="admin" ....
3) not sure about this one( i know that i should use count and group by,,, not sure about the location as well)
5) SELECT TOP 10 PERCENT direktoriID,name,size FROM direktori WHERE direktori.direktoriID= FILE.DIRECTORYid AND parentdirectoryID=NULL
So if you could please help out with that.
here is a picture of the ER model(using ms Access)