customer (cid, name, email, dob) ordr (oid, cid, tim) ordritem(oid, pid, qty) product (pid, name, price) It's a schema for a store: customer table has customer information, ordr has order information (links to customer via cad), and ordritem (inks to ordr via old) has order line-iters and quantity and link to products via pid. 1. Find customer id of John Doc. (a) select cid from customer where name=' John Doe' (b) select name from customer where fname=' John' and Iname='Doe' (c) select * from customer where name=' John Doe' (d) select cid from customer where fname= John' and Iname='Doe' (e) Other