Suppose you are working with a pet supply store’s database t…

Suppose you are working with a pet supply store’s database that contains an Items table with the following columns: Item#, ItemName, PetCategory, Price, and Vendor. Which SQL query would you write to retrieve a list of items in the cat pet category that cost $20 or less?

While using a DBMS, Ginny attempts to access a record that s…

While using a DBMS, Ginny attempts to access a record that she needs to alter, but finds that she can view but not change the record. She turns to another task for a few minutes, then tries again and successfully modifies the record. It is most likely that Ginny’s access to the record was initially limited by her DBMS’s _____ feature.