Exam — Mid-term

 

· Definitions & Terminology

· Semantics

 

· Chapter 1 — ALL Sections

· Basic database concepts and functionality

· See Summary and Review

· Chapter 2 — ALL Sections

· Relational Model

· Relational Algebra

· See Summary and Review

· Chapters 3 & 4 — ALL Sections

· SQL

· Queries

· Anatomy of a SELECT statement

· Joins — all kinds

· Order of execution of each of the clauses

· Expressions

· Functions

· Inner SELECTs

· Views

· DML

· DDL

· See Summary and Review for both Chapters

· Chapter 5  - NOT ON THE EXAM

· Chapter 6  - NOT ON THE EXAM

· Chapter 7 — ALL Sections

· ER Diagrams

· Entity Sets

· Attributes — all kinds

· Primary Keys

· Relationships

· Roles, Participation, Cardinality

· Weak Entity Sets

· Discriminators, Identifying Entity Sets

· Generalization, Specialization

· ER Reduction to relational schemas

· Chapter 9 — Sections 1, 4

· Tier architectures

· Single, Two-Tier, Three-tier

· Application Layers

· Presentation Layer

· Model-View-Controller

· Business Logic Layer

· Data Access Layer

·