CS 112D Lecture Notes - Prerequisite Examples - Craig Persiko

Here's what the course prerequisites mean to me: you must understand basic VB and SQL code and concepts. Following are examples that you should be able to understand already. If not, you might not be prepared for this course.

Visual Basic (CS 112A)

Following are two VB.NET projects with examples of code I expect you to understand already. Make sure to unzip the following archives, extracting all files, with the box labeled, "Use folder names" checked (if applicable). Then double-click on the .sln file (the "Visual Studio Solution"). I don't expect you to be familiar with Visual Studio .NET, so some of the code you see here may be unfamiliar, but I expect you to understand the basics: variables, loops, if-statements, and functions.

Car Payment Calculator - Uses loop
Wage Calculator - Uses if-statement and functions

Database Basics (CS 150A or 151A)

Folowing are two tables from an Access database, and a query that uses them. We will not use Access in this class, but I expect that's the database program most of you have used.

Here is the design view for the Customers Table:
Here is the design view for the Orders Table:
Here is the Quarterly Orders query, shown graphically:
Here is the same query shown as SQL code, which you should definitely understand. We will generally write our queries in SQL like this (although there may be slight variations in syntax for SQL Server vs. Access):
SELECT DISTINCT Customers.CustomerID, Customers.CompanyName, Customers.City, Customers.Country
FROM Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID
WHERE (((Orders.OrderDate) Between #1/1/1997# And #12/31/1997#));
Here are the results of the above query: (Customer info for all orders in 1997, even if no matching record is found in the Customer table)

Return to the main CS 112D page