2001Fall CS157A Midterm 3 Study Guide
Prof. Sin-Min Lee
Exam Date: Thuesday Nov,20,2001.
The exam will be comprehensive. Test material will be drawn from the text book, lecture, assignments and any supplementary material provided in class.
You should review the following:
all the lecture notes
all the assigned readings (if you don't have the text book, then the lecture notes will suffice)
Data definition: create table, drop table
Data manipulation: select command
Subqueries, aggregates, duplicates, null values, join operations
Data modification: insert, delete, update
Understand the syntax of entering SQL commands
What is a subquery? When is it evaluated?
What is the difference between ANY, ALL, LIKE and IN?
Unary operators versus binary operators.
Using wildcards in SQL. What are the symbols? What is the command structure?
Define the EXISTS clause and what it does.
How to define relational views? What can relational views be used for and what are the advantages of using views? How are relational views different from base-relations?
Know the difference between 1st, 2nd and 3rd normal forms, how each differ, and how to get one form into a higher form.
Understand determinants and functional dependency
Be able to determine candidate keys in a relation
What is Boyce Codd normal form?
For the exam you should be able to
describe what a weak entity set is and give an example of one