扩充实体关系.pptVIP

Database Systems, 8th Edition * Database Systems, 8th Edition * Design Case #2: Maintaining History of Time-Variant Data Normally, existing attribute values replaced with new value without regard to previous value Time-variant data: Values change over time Must keep a history of data changes Keeping history of time-variant data equivalent to having a multi-valued attribute in your entity Must create new entity in 1:M relationships with original entity New entity contains new value, date of change Database Systems, 8th Edition * Database Systems, 8th Edition * Database Systems, 8th Edition *