Database Management Systems & Programming
Class Outline
Database Models
PPT Slide
The Evolution of Conceptual Data Models
The Relational Database Model
Introduction to Database Design
Database Terminology
Table
Field
Record
Data Dictionary and the System Catalog
Keys
Indexes
Database Components
Major Components of a Database Application
Levels of Database Representation
A Logical View of Data
What is Relational Database Design?
Why use a Relational Data Model Design?
Database Design Problems
Characteristics of a Database designer
Conceptual Design Methodology
Statement of Purpose
Assessment of User Requirements: What is analyzed?
Assessment of User Requirements: Specific requirements
Rules for Conducting User Interviews
Data Modeling
Purpose of Data Modeling
E-R Modeling Concepts
Entities
Attributes
Identifiers
Relationships
Degree of Relationship: Binary
Degree of Relationship: Ternary
Degree of Relationship: Unary (Recursive)
Recursive Relationships
Connectivity
Representing M:N binary relationships
Cardinality
Occurrences Diagram
Relationship Participation
Example: Customers & Orders
Entity-Relationship Design
Steps in Entity-Relationship Modeling
E-R Method Example: Library Database
Library Database (cont’d)
E-R Modeling: University Example
University Example (cont’d)
Evaluation of the E-R Model
Week After Next
Email: iwhyte@lib.uwo.ca
Other information: Week 2 - May 15, 2000
Download presentation source