Midterm 1

File Based Systems

Database System

DataBase Management System (DBMS)

Client Server Database System Architecture Includes what two things?

Database System Arch. Server Process

Database System Arch. Client

Personal Database Management Systems (include example)

Client/Server Database Management System Advantages

Relational Database Model includes what two things?

Set Theory

Predicate Logic

Name the aspects of a Relational Database Model

Structural Aspect of Relational Model

Integrity Aspect of Relational Model

Manipulative Aspect of Relational Model

Table (relation)

Integrity Aspect Key Fields and Types

Primary Keys

Candidate Keys

Surrogate Keys

Foreign Keys

Composite Key

Properties of Relations Structural Aspect

E.F.Codd's Twelve Rules for Fully Relational Database

Codd's Summary:

Entity-Relationship Model Goal

Normalization

User Views

Information Level Design Steps

Relationship Types

One to One (1:1)
Rarely implemented as such

Many-to-Many(N:M)

One-to-Many(1:M)

General Design Principles

Functional Dependence

First Normal Form

Second Normal Form

Third Normal Form

4NF

Design Methodology

IDEF1X Shapes (Rectangle / Line Type)

Refinement: Existence Dependence

Weak Entity

Cardinality

Structured Query Language

Basic Categories for SQL Commands

User Accounts and Schema

SELECT Statement

Basic Queries

Entity Subtypes