Study Guide
You should read and know the following material. The emphasis on the test will be on material explicitly covered in class. You must practice queries in lecture notes, quizzes, and homework. I am enumerating here specific sections of Chapters from the book and what you need to know:\

Book: The Complete Book, Molina, Ullman,and Widom
\
Chapter 1 (1.1-1.2.1): You must know the why database management systems were developed, and an architectural overview of a DBMS. \
\
Chapter 2 (2.1 excluding 2.1.4,2.2,2.3,2.5) Chapter7 (7.1.1,7.1.2,7.2,7.3) You must know the basics of relation model. You should know, given a specification in English, how to create a database schema with SQL DDL statements,  alter it,  and express constraints

Chapter 5(5.1) Chapter 6(6.1-6.4) You must understand basic set operations, and how to think in terms of sets when writing SQL queries. You must know the SQL operators, and how to write queries using operators.  We have not covered Chapter 5 with mathematical notation, but set operations as described in class and the corresponding SQL syntax must be understood.  You must know Advanced SQL. Try various queries from SQLZoo.net. Practice Joins, Groupby, subqueries, nested correlation. \
\
\
All the best!\
}