Introduction. CMPT 454. Course Website. http://www.cs.sfu.ca/CourseCentral/454/johnwill/. Assessment. Assignments – 30% Midterm exam in class – 25% Final exam on the 12 th of April– 45%. CMPT 454. In CMPT 354 we learned about database design, creation, and use
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
WHERE job = 'journalist'
FROM Customer C, Account A
WHERE C.name = 'Jones' AND
C.id = A.id
FOR each record c in Customer
FOR each record a in Account
IF c and a satisfy the WHERE condition THEN
print the balance field from Account