ITM 500 Lecture Notes - Lecture 8: Logical Data Model, Aggregate Function

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 500
• Professor: Raymond Moss

Document Summary

Note: while it is understood that groups may share their expertise and communicate with each other, each group"s work must reflect sufficient individual group effort to merit its grade. Sharing complete solutions with other groups is not acceptable. Such blatant collusion will result in a grade reduction for both groups and in extreme cases could result in a zero and a charge of academic misconduct. Part i and part ii below are completely separate requirements and should be addressed as such. They do not constitute a single integrated problem. Using the part 1 btm shipping narrative, design and document a logical data model using. You should also make and document any reasonable assumptions where you feel the case is vague or ambiguous or missing any data necessary to meet the requirements. However you cannot ignore or overrule the requirements that are explicitly stated. Show all cardinality, prime keys and foreign keys.