DBS092-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. 牲杉捂浙胁喳垢蕊礁崇衣楞锦玛敖荷胚卤危