Week 2 Day 1: UML

Class Agenda

Assignment Discussion: Team relationship model

Conceptual Framework

UML to Relations (10 min)

Relational Design Overview (6 min)

Practical Applications

Physical Design Part 2: Relationships (5 min) 

Physical Design Part 3 :Primary Key, Unary One-to-Many Relationship, Binary One-to-One Relationship (5 min)

Physical Design Part 4 :Many-to-Many Relationship (5 min)

Physical Design Part 5 :Multivalued Attribute (5 min)

Microsoft Access 2013 Tutorial on relationship - Part 2 (8 min)

Instructions for assignment due before next class are available in Moodle