SWEN-220 Final: DataModelingExamStudyGuide
Document Summary
Following are the things you should know and be able to do during the exam. The fact that an item is on this list does not necessarily mean there will be a question on the it, but you would be well-advised not guess which topics will. Thing capable to independent existence compound attribute value for a primary key attribute attributes used to reference a row (tuple) in the same or different relation. Relationship: the way entities are associated with each other. Diagram foreign key must always reference an existing primary key in the referenced relation simple attribute: attributes without internal structure derived attribute: computable from other attributes multi-valued attribute: ex. may play multiple positions. Constraint: (integrity) is a boolean expression that must be true for a relation (or set of relations) to be in a valid state/ cardinality constraints. Transitive dependencies always relate to attributes outside of candidate keys. cardinality.