Blog

StayWell provides maintenance services across the properties they manage. The SERVICE_CATEGORY table in their database contains a _____.

What SQL command do you use to query a database?

StayWell organizes a variety of maintenance services for a fee.

The StayWell database’s OWNER table _____.

Bradford would like to write a query that returns the average unit sales over the last 30 days for each of his bakery’s product types: cupcakes, muffins, and cookies. There are several flavors of each in the table, but the product types are identified in a CATEGORY column as “Cupcake,” “Muffin,” or “Cookie.” What should the last part of his query be, following the part shown below?​SELECT CATEGORY, AVG(UNIT_SALES) FROM PRODUCTS

One can successfully design a database system without fully understanding the concept of functional dependence.

KimTay sells _____.

StayWell has twelve offices, one to manage each of their twelve rental locations.

When users create, alter, or drop tables or create or drop indexes, the DBMS updates the system catalog automatically.

Jesse has written some commands in MySQL Workbench that he expects to run regularly, and he would like to save them for future use. What should he do next?