ER-Diagram

SELECT person.pid,prename,fname,lname,visitdate

FROM person,visit

WHERE person.pid=visit.pid

             AND person.pcucodeperson=visit.pcucodeperson

             AND visitdate = ‘2010-02-01’