| 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.