Q. when do you use upper case letter and lower case?

It would depend on the context -- what you are doing at the time.  With regard to the Library's catalog and databases, it really makes no difference.  Using all lower case usually saves time because you do not have to bring into play the shift key.