Most exam material will primarily come from: 

KimTay’s management would like to set up a structure that contains different categories of information and the relationships between these categories. In other words, they want a _____.

You can determine functional dependence by viewing sample data.

When you specify a foreign key, the table referenced by the foreign key is the _____.

All packaged foods are required to display a standardized nutrition label. This nutrition label contains information about the calorie content, amount of fat, protein, carbohydrates and other required nutrients. The food label below will be used to answer the following 5 questions.  

You can create and maintain an index on any row in any table.

The acidity of the stomach allows for all of the following EXCEPT

I have watched the lab walk-through video provided in the course materials.

Which of the following is NOT a limitation of nutritional assessments?

Nina is writing a MySQL query to list the descriptions of items in the CUPCAKES table, which are identified by PROD_ID values. The ORDER_LINE table includes product and quantity information from bakery orders, which are identified by ORDER_NUM values. What can she add to the following query to limit the list to descriptions of cupcakes purchased through order 342?SELECT DESCRIPTION FROM CUPCAKES WHERE