CIS164AG - Project Three - ERWin

 
Name: _____________________________________ 
(Please Print)
Due at start of last class Points: 
50 max.

Part One - DeZign  [44 points]

_______  Correct reports: ER diagram, Entity details and Relationship details.
_______  Entities
     Named correctly
     Appropriate positioning
_______  Attributes
     Correctly added to each entity
     PKs specified correctly
     Not Null specified correctly
     Attributes have correct data types
_______  Correct Relationships added
     One / Many correctly selected
     Verb phrases added
_______  Correctly handled PET : PEN
     Position correct
     Appropriate attributes
     Relationship complete
_______  Correctly handled CLASS : PET
     Position correct
     Appropriate attributes
     Relationship complete
_______  Correct display options
     Relational notation
     Display level attributes
     Primary and Foreign Key Designator
     Show Not Null indicator for attributes
     Display parent child Verb Phrases

Part Two - Define Domain Constraints  [6 points]

_______  Domain Key Constraints for the CLASS entity key of clid
_______  Domain Key Constraints for the PEN entity its key of pennbr

Please specify your domain constraints below.