资源描述
Click to edit Master title style,Click to edit Master text styles,Second level,Third level,Fourth level,Fifth level,*,Advanced Entity Relationship Concepts,Advanced Concepts,UIDs,Intersection Entities,Recursive Relationships,Roles,Subtypes,Exclusivity,Historical,Fan Traps,Non transferability,Simple Unique Identifier,CUSTOMER,#,*customer num,Single attribute,Tag the UID with,#,Compound UID-Attributes,MEMBERSHIP,#*,num,#*,start date,Multiple attributes,Members get a new membership each year but keep their membership number.,Compound UID-Composite,ACCOUNT,*num,BANK,#*num,Use a UID bar to indicate,that a relationship is part of,the entitys UID,Use#to indicate that,the attribute is part of the,entitys UID,What would you need to know to identify,a specific instance of ACCOUNT?,#,What do you need to know to identify a specific instance of RENTAL ITEM?,Rental item requires the,rental transaction num,and the,inventory num,Compound UID-Relationships,RENTAL ITEM,*rental period,return date,o,RENTAL,#*transaction num,*transaction date,COPY,#*inventory num,*purchase cost,Multi-Level Relationship UIDs,What would you need to know to,identify a specific instance of TICKET?,VENUE,PLAY,#*title,PERFORMANCE,#*date,#*time,#*name,CUSTOMER,#*name,TICKET,*seat number,Multi-Level Relationship UIDs,Venue name +Play title+,Performance date +,Performance time+,Customer name,VENUE,PLAY,#*title,PERFORMANCE,#*date,#*time,#*name,CUSTOMER,#,*,name,TICKET,*seat number,Multiple UIDs,badge num,payroll num,first and last name,EMPLOYEE,badge num,payroll num,last name,first name,#,(1),*,#,(3),*,#,(2),*,#,(2),*,Composition of a UID,SUPPLIER,#CODE,PERSON,#NAME,#DATE OF BIRTH,Example A,SUPPLIER TITLE,SUPPLIER,TITLE,distributor of,distributed by,available as,for,Example B,RENTAL ITEM,RENTAL,part of,composedof,#LINE NO,Example C,Primary Unique Identifier,An entity can have several unique identifiers.,One may be appointed as the,primary,unique identifier.,Only the Primary UID is shown in the entity relationship diagram.,RENTAL ITEM,*rental period,return date,o,RENTAL,#*transaction num,*transaction date,COPY,#*inventory num,*purchase cost,RENTAL,#*transaction num,*transaction date,COPY,#*inventory num,*purchase cost,Intersection Entity,Note how Crows Feet Change!,Intersection Entities:Identifying the Problem,TITLE,SUPPLIER,supplied by,supplier of,In which entity would you store the attribute:,purchase price,?,#*prod code,*name,#*supplier no,*name,Intersection Entities,CATALOG ITEM,available as,SUPPLIER,supplier of,TITLE,TITLE,#*prod code,*name,#*supplier no,*name,*purchase price,for,for,Unique Identifiers,available as,CATALOG ITEM,SUPPLIER,supplier of,TITLE,TITLE,#*prod code,*name,#*supplier no,*name,*purchase price,for,for,CATALOG ITEM,available as,SUPPLIER,supplier of,TITLE,TITLE,#*prod code,*name,#*supplier no,*name,#,*item num,*purchase price,for,for,OR,Modeling Recursive Relationships,.and mine,.hes my,manager,.but Im HIS,manager!,EMPLOYEE,manager of,managed by,Modeling Hierarchical Data,Company,Division,Team,Department,TEAM,#name,DEPARTMENT,#*name,DIVISION,#*name,COMPANY,#*name,Hierarchies as Recursive Relationships,ORGANIZATIONELEMENT,made up of,within,#*name,*type,TEAM,#name,DEPARTMENT,#*name,DIVISION,#*name,COMPANY,#*name,Network Structures,COMPONENT,#*identifier,a part of,made up of,Network Structures,COMPONENT,#*identifier,a part of,made up of,COMPONENT,COMPONENT,made up of,a part of,#*identifier,#*identifier,Network Structures,COMPONENT,COMPONENT,made up of,a part of,#*identifier,#*identifier,ASSEMBLY RULE,COMPONENT,#*identifier,COMPONENT,#*identifier,made up of,a part of,for,for,o,quantity,Network Structures,COMPONENT,ASSEMBLYRULE,a part of,made up,of,for,for,o quantity,#*identifier,Identifying Roles,ENROLLMENT,STUDENT,COURSE SECTION,INSTRUCTOR,for,for,included in,taken by,taught by,the,teacher,of,*date enrolled,*fee,#*id,*name,*location,*start date,#*id,*name,*salary,COURSE,#*code,*name,for,the,subject,of,Modeling Roles,for,for,enrolled,on,ENROLLMENT,*date enrolled,COURSE,#*code,*name,PERSON,#*id,*name,o salary,*fee,taught,by,for,COURSE SECTION,*location,*start date,taken by,the,teacher,of,included in,Subtypes,*category,*duration,O,audio,TITLE,#,*,*,product code,title,description,*,GAME,MOVIE,*category,*medium,*minimum memory,All titles are either movies or games,Creating a Subtype,In ERD:,Drag and drop.,or,Draw new entity fully within or around the other.,In RON:,Set Property,Type of,.,or,Drag and drop.,and,Select association for dropped entity.,Select Associations,Type of,Sub Entities,Exclusive Entities,COMPANY,id,name,telephone num,supplier num,sales contact,#,*,o,*,*,o,COPY,acquired from,the source of,the holder,of,held by,MEMBERSHIP,*num,*start date,*expiry date,termination,#,*inventory num,o,condition,o,Company in two roles,Splitting Entities,COMPANY,#,*,*,acquired from,the source of,the holder,of,held by,id,name,telephone num,*,OTHER,supplier num,sales contact,*,SUPPLIER,MEMBERSHIP,*,num,*,start date,*,expiry date,termination,#,COPY
展开阅读全文