X hits on this document

Word document

For the exam you should be able to - page 1 / 11

39 views

0 shares

0 downloads

0 comments

1 / 11

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)

1.

SQL

o

Data definition: create table, drop table

o

Data manipulation: select command

o

Subqueries, aggregates, duplicates, null values, join operations

o

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?

2.

Chapter 7.

Define Unnoromalized

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

Document info
Document views39
Page views39
Page last viewedSat Dec 10 04:36:09 UTC 2016
Pages11
Paragraphs265
Words2948

Comments