Midterm 2 Review

Midterm 2 includes the following topics:

There are 5 basic SQL commands:

You should know the basic structure of these commands and how to execute them in JDBC:

What kind of things appear in different parts of the statement
What kind of message do you send to a java.sql.Statement object to execute the statement

You should know the 5 basic principles:

Separation of Concerns has several subprinciples that you should know:

In addition, you should know two important concepts associated with separation of concerns:

You should know basic phases of software development:

You should know the ongoing activities of software development:

It is also important to understand some concepts introduced by some of the process models

Prototypes
- they are used in different ways in the Prototype model and Phased Release model
Architecture
- It is essential for large development projects.
- It decomposes the software into large-scale components with carefully designed interfaces to allow for relatively independent development of the components by subteams.
- It is only considered in the Concurrent Development process model.

You should know the following about concurrent version systems

You should understand the classification of design patterns according to

You also should know some principles behind design patterns

Favor association over class inheritance when you need dynamic behavior. Class inheritance is better when you want to fix some aspect of behavior as in the Template Method or Factory Method design patterns.
Good encapsulation sometimes requires "violating encapsulation" as in the Iterator design pattern. If you couldn't implement a java.util.Iterator as a nested class of an aggregate then the aggregate would need public methods that expose its implementation
Laziness is sometimes a good thing. For example, the Singleton design pattern uses lazy creation for the singleton object.