Section 4 – Select True or False  

Retrieve all the borrower names and phones who has book loans from the branches located in Miami.

Conceptual Schema.

What is the difference between a primary key and a foreign key?

Section 3 – Multiple selection: For the following binary relationships, suggest cardinality ratios based on the common-sense meaning of the entity types.

Your cat needs 0.5 lb of protein per day. You go to the pet store and have two cat food options: Cat food A has 55% protein and Cat food B has 15% protein. How much Cat food A and Cat Food B would you have to feed your cat, per day, to meet its protein requirements?

List and explain three characteristics of the database approach.

Database Schema.

A feed sample weighted 20g before going into a 100C drying oven for 16h. After leaving the oven, the sample weighted 5g. Assuming that there were no volatile compounds, what is the DM% of this sample?

In class we discussed 7 important nutritional management goals. Please list and briefly explain 3 of these nutritional management goals.