Given the Customer Table, which of the following Relational Algebra gives the results in the Answer Table

1?

A. Select Customer Where SP# = E-10

B. Project Customer Over (Customer#, Name)

C. Select Customer Where Name = Bill

D. None of the Above

Tables for Part 1-03 A/R Amt Customer Customer Name C-1 Bill C-2 Mick C-3 Keith C-4 Charlie C-5 Ron SP# E-12 E-10 E-10 E-99 E-10 Answer Table 1 Customer Name Bill A/R Amt SPH E-12 Answer Table 2 Customer Name C-2 Mick C-3 Keith C-5 Ron A/R Amt SP E-10 E-10 E-10 C-1 Answer Table 3 Customer Name Bill C-2 Mick C-3 Keith Charlie C-5 Ron A/R Amt Answer Table 4 Customer Name C-1 Bill C-2 Mick C-3 Keith Charlie C-5 Ron