ISOM 3260 - Database Design and Administration
Midterm Exam Review

To access the midterm practice questions, press here.

Section 1A - Basic Terminology in Databases
Lecture 1 - Database Fundamentals

Data vs Information

Range of Database Technologies

Traditional (Flat File) Approach vs Database Approach

Costs and Risks of the Database Approach

Range of Database Application

Type of Database / Application Typical Number of Users Typical Size of Database
Personal 1 1 Megabytes
Multitier Client/Server 100 1000 100-1000 Gigabytes
Enterprise Resource Planning (ERP) > 100 >100 Gigabytes - Terabytes
Data Warehousing > 100 >100 Terabytes - Petabytes

Multitier Client-Server Architecture

3-tier Architecture

Enterprise Database Application

Database Terminology

System Development Methodologies / System Development Life Cycle (SDLC)

In software engineering, a software development process is the process of dividing software development work into distinct phases to improve design, product management, and project management.

SDLC

Section 1B - Open Source Databases
Open Source Databases

Section 2 - Conceptual Database Design with Entity-Relationship Diagram
Lecture 2 - Entity-Relationship (ER) Diagram

Business Rules and Data Modeling

Basic Terminology of Entity-Relationship (ER) Diagram

Imgur

Entities

Entity Type vs Entity Instance

Entity Type vs System Input, Output, or User

Strong vs Weak Entity Types

Attribute

Types of Attribute

Relationship Type vs Relationship Instance

Associative Entity

Degree of a Relationship

Imgur

Cardinality Constraint

Section 3 - Conceptual Database Design with Enhanced Entity-Relationship Diagram

Notations in Enhanced ERD

Imgur

Supertypes and Subtypes

Generalization and Specialization

Completeness Constraints

Disjointness Constraints

Subtype Discriminator

Supertype/subtype Hierarchy