Test 1 Review

Bring a GradeMaster form and a pencil to the test. The test will take 50 minutes.

Overall Scope

• Know key terms and definitions from the lecture notes

SQL

• Be able to write SELECT statements to solve queries similar to the ones in the homework
• Given a SELECT statement and sample data, be able to determine what results the statement would produce
• Be able to identify malformed SELECT statements
• Know the conceptual evaluation sequence for SELECT statements
• Know the types of joins and what they do
• Know the three ways to solve difference problems
• Know the 3-valued logic rules we discussed and be able to apply them when executing a query
• Know the syntax and behavior of SQL DML statements INSERT, UPDATE, and DELETE

Entity-Relationship Modeling

• Given an E-R diagram, be able to interpret relationships using sentences such as “a pipe organ consists of zero to many pipes.”
• Given an E-R diagram and a narrative, be able to identify diagram and design errors
• Given an E-R diagram, be able to design a corresponding database schema, specifying foreign keys