Final Exam Review

Notes:

week01notes01 – week06notes01 and

week08notes01 – week09notes01

Labs:

1 – 8

Concepts:

Functional Dependencies

Finding them in a set of data.

Normalization

NF1, 2, 3, BCNF

Database design

Relationships

Cardinality

1:1

1:many

many:many

Attributes

Name, type, constraints

Convert relationships + attributes to tables

Given relationships, how do you define tables to represent these relationships? 

Where are foreign keys located for each releationship cardinality shown above?

For which relationships do you create a new table?

Functionality

DBMS

SQL

Insert, Update, Delete

Select

Basic conditional row retrieval

Aggregate functions

Subqueries

Joins

Inner

Outer (left and right)

Stored Procedures

How do you declare a stored procedure?

How do you call it?

How can you use an error handler to handle a foreign key violation?