Project outline

• Description of the database design life cycle

• The entity relationship diagram

• The logical model and normalization

• The Microsoft Access database

• The Microsoft Access database application

As a preview, each section will contain the following:

• Description of the database design life cycle

• A description of the selected database project

• A description of the DBDSL – 7 steps

• A discussion about the three steps in database design

• The entity relationship diagram
  
  • An entity relationship diagram
• The logical model and normalization

• Logical data model

• Normalized to 3NF

• The Microsoft Access database

• Your database created in Microsoft Access

• SQL SELECT statements

• The Microsoft Access database application

• Complete your Microsoft Access application

• Menu, forms, and reports