April 14, 2016
IS 315: Chapter 9 Homework
9-26) Examine the three tables with student data shown in Figure 9-1. Design a single-table
format that will hold all of the data (nonredundantly) that are contained in these three tables.
B) FUNCTIONAL DEPENDENCIES:
DESCRIPTION - VEHICLE ID
6-57 A) How many work centers does Pine Valley have? 3
SELECT COUNT (*)
B) Where are they located? Tampa
SELECT FROM WorkCenter_T
WHERE = Location
6-58 List the employees whose last names begin with an L.
Ch 7 Homework
where Customer_T.customerid not in
(select distinct Order_T.customerid