Ryerson University > School of Computer Science
 

Logical database design

The ER model from Conceptual design has been revised, remove the many-to-many relationship by Normalization.

Revised ER Model

Revised ER model

Relational Shemas

Validate Relations using Normalization

Validate Logical ER model using user transactions

Define Integrity constraints