Blog

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?

Which command will allow user Thompson to remove rows from the CUSTOMER table?

When adding rows to character columns, make sure you enclose the values in single quotation marks.

You are working with a QUOTATIONS table that contains no repeating groups and has a primary key consisting of the SERVICE_CODE and SPECS columns. You realize that some other columns in the table functionally depend on either SERVICE_CODE or SPECS, but not both, whereas the rest depend on both. How should you improve this table?

A program’s or an individual user’s picture of the database is called a(n) _____.