Database Management Systems & Programming
Lecture Outline
Assignment #1
Content of LIS558
Seven Step Conceptual Design Methodology
E-R Modeling Concepts
Entity-Relationship Design
Steps to E-R Transformation
Database Design Problems
Rules for Normalization
Implementation Outline
Steps to Relational Implementation
Guidelines for Ideal Table Design
Database Definition Revisited
Relational Database Management Systems
Simple Circulation System
Access ‘97 Implementation of Model
Database Properties
Database Options
Database Startup Options
Database Startup Properties
Implementation of Circulation System Model
Database Object Prefixes
Call Number Field Properties
Title Field Properties
Author Field Properties
Year Field Properties
Table Properties
Selecting Data Type
Formats & Input Masks
Field Validation
Lookup Lists & Tables
Referential Integrity
Referential Integrity in Access ’97
Referential Integrity Options in Access ’97
Relationship Integrity is a way of minimizing data errors
Table Joins
Class Outline
Three Access Query Types
Microsoft Access Query Types
Example Query in Access
Access SQL
SQL Examples
Example Table Structure
SQL & Programming
Assignment #4 Form Construction
Components of Windows Interface
Anatomy of Event-Driven Applications
Show Events Form - Orders.mdb
Combo Box Design Properties
Combo Box Format Properties
Combo Box Data Properties
Combo Box Other Properties
Combo Box Event Properties
Code Associated With Event
Components in Detail
Practical User Interface Design
Building Applications
Next Week
Email: iwhyte@lib.uwo.ca
Other information: Week 7 Relational Database Implementation
Download presentation source