DBS090-Database_Systems_Review.pptVIP

2009-4-28 * Weak Entity-Set Rules (2) The key for a weak entity set is its own underlined attributes and the keys for the supporting entity sets. E.g., (player) number and (team) name is a key for Players in the previous example. 庚彤此厢鹤爆敢少死罐渍耻数草瓦渺乱抢负邓琉性驼奈苏缔驰佰萤矛慨兆DBS0902-Database_Systems_ReviewDBS0902-Database_Systems_Review 2009-4-28 * From E/R Diagrams to Relations Entity set ? relation. Attributes ? attributes. Relationships ? relations whose attributes are only: The keys of the connected entity sets. Attributes of the relationship itself. 撤殊战咳烽府卧冤伦植硼田狞芦微布苑孟禹排朵戮荔依菲薯风卜念符鸦刹DBS0902-Database_Systems_ReviewDBS0902-Database_Systems_Review 2009-4-28 * Handling Weak Entity Sets Relation for a weak entity set must include attributes for its complete key (including those belonging to other entity sets), as well as its own, nonkey attributes. A supporting relationship is redundant and yields no relation (unless it has attributes). 眺挂睬忿敝表科儡船阅靖疮贩支茸膨埠认煽弘贰羡谭椰乐彦竟淹楔斤连彼DBS0902-Database_Systems_ReviewDBS0902-Database_Systems_Review 2009-4-28 * Anatomy(结构) of a Rule Happy(d) ? Frequents(d,bar) AND Likes(d,beer) AND Sells(bar,beer,p) Body = antecedent(前提) = AND of subgoals. Head = consequent, a single subgoal Read this symbol “if” 鞍瞳哮阻噎妨孪龙筐师晚捻镰苏浊晶拙钦面酵钎曳澄熬善磷曼檀束蔬谷猩DBS0902-Database_Systems_ReviewDBS0902-Database_Systems_Review 2009-4-28 * Subgoals Are Atoms An atom(原子) is a predicate(谓词), or relation name with variables or constants as arguments. The head is an atom; the body is the AND of one or more atoms. Convention: Predicates begin with a capital, variables begin with lower-case. 潍经域螺某冕蘸铁的宰祖娶扰灾尺汞故曼凋陵侦补盲号镐篷姆窿昧畔拄岂DBS0902-Database_Systems_ReviewDBS0902-Database_Systems_Review 2009-4-28 * Interpreting Rules A variable appearing in the head is distinguished ; otherwise it is nondistinguished. Rule meaning: The head is true for given values of the distinguished variables if there exist values of the nondistinguished variables that make all subgoals of the body true. 挚孪戌压汁刹塘胖笛久蹬升巴藐进笑钩及氰