UML系统分析与设计教程-冀振燕-第12章

作者：冀振燕《UML系统分析与设计教程》1第12章数据库设计作者：冀振燕《UML系统分析与设计教程》2数据库设计在UML中，类图定义了应用程序所需要的数据结构，用实体类以及实体类之间的关系来为数据库中持久存在的数据结构建模。因此，需要将实体类映射为可以被数据库识别的数据结构。如何将实体类、关联关系、聚合关系、类属关系转变为3种数据库（面向对象型、对象关系型、关系型数据库）模型中的数据结构？作者：冀振燕《UML系统分析与设计教程》3对象数据库模型映射实体类映射关联映射聚合映射类属作者：冀振燕《UML系统分析与设计教程》4映射到ODB：映射实体类ContactPersoncp_id:Integerlast_name:Stringfirst_name:Stringphone:String[]fax:String[]email:String[]Researcherresearcher_id:Stringlast_name:Stringfirst_name:Stringmid_name:String作者：冀振燕《UML系统分析与设计教程》5映射到ODB：映射实体类last_name:stringfirst_name:stringODBInterfaceShortNamemid_name:stringODBInterfaceLongNamekeycp_id:unsignedshortcp_name:ShortNamephone:setstringfax:setstringemail:setstringODBClassContactPersonkeyresearcher_id:stringresearcher_name:LongNameODBClassResearcherISA作者：冀振燕《UML系统分析与设计教程》6映射到ODB：映射关联MailAddressmailbox:Stringstreet:Stringcity:Stringprovince:Stringnation:Stringpostalcode:StringCourierAddressdoor_num:Integerstreet:Stringcity:Stringprovince:Stringnation:StringInstituteinstitute_id:Integerinstitute_name:Stringphone:String[]fax:String[]email:String[]ContactPersoncp_id:Integerlast_name:Stringfirst_name:Stringphone:String[]fax:String[]email:String[]1..n1Projectproject_name:Stringstart_date:Date0..n1..n0..n1Researcherresearcher_id:Stringlast_name:Stringfirst_name:Stringmid_name:String1..n0..nTasktask_name:Stringstart_date:Datefinish_date:Date1..n11..n0..nstart1..n0..nfinish作者：冀振燕《UML系统分析与设计教程》7door_num:unsignedshortODBInterfaceCourierAddressmailbox:stringpostalcode:stringODBInterfaceMailAddressmid_name:stringODBInterfaceLongNamelast_name:stringfirst_name:stringODBInterfaceShortNameISAstreet:stringcity:stringprovince:stringnation:stringODBInterfaceAddressISAISA接口作者：冀振燕《UML系统分析与设计教程》8keyinstitute_id:unsignedshortinstitute_name:stringphone:Setstringfax:Setstringemail:Setstringmail_adr:MailAddresscourier_adr:CourierAddresscp:SetContactPersonproject:SetProjectODBClassInstitutekeycp_id:unsignedshortcp_name:ShortNamephone:Setstringfax:Setstringemail:Setstringmail_adr:MailAddresscourier_adr:CourierAddressinstitute:Instituteproject:SetProjectODBClassContactPersonproject_name:stringstart_date:Dateresearcher:SetResearchertask:ListTaskinst:ListInstitutecp:ContactPersonODBClassProjectkeyresearcher_id:stringresearcher_name:LongNameproject:ListProjectstart_task:SetTaskfinish_task:ListTaskODBClassResearchertask_name:stringstart_date:Datefinish_date:Dateproject:Projectstart_researcher:SetResearcherfinish_researcher:SetResearcherODBClassTaskODB--关联的映射作者：冀振燕《UML系统分析与设计教程》9ODB--映射聚合聚合关系Coursecourse_code:Stringcourse_name:Stringcredit_points:IntegerCourseRecordcourse_code:Stringyear:Dateterm:Integerscore:IntegerCourseOfferingyear:Dateterm:Integerstu_quota:Integer0..nStudentstu_id:Stringstu_name:String0..n0..n0..n作者：冀振燕《UML系统分析与设计教程》10ODB--映射聚合course_code:stringyear:Dateterm:unsignedshortscore:unsignedshortODBInterfaceCourseRecordcourse_code:stringcourse_name:stringcredit_points:unsignedshortcrs_off:SetCourseOfferingODBClassCoursestu_id:stringstu_name:stringcrs_off:SetCourseOfferingcrs_rcd:ListCourseRecordODBClassStudentyear:Dateterm:unsignedshortstu_quota:unsignedshortcourse:Coursestudent:ListStudentODBClassCourseOffering作者：冀振燕《UML系统分析与设计教程》11ODB--映射类属类属关系speed:Stringnum_of_wheels:IntegerabstractVehiclevolume_of_tank:IntegerabstractAutomobileSaloonTruckJeepGarbageTruckGoodsTruck作者：冀振燕《UML系统分析与设计教程》12ODB--映射类属类属关系的映射speed:Stringnum_of_wheels:IntegerODBinterfaceVehiclevolume_of_tank:IntegerODBinterfaceAutomobileODBClassSaloonODBClassTruckODBClassJeepODBClassGarbageTruckODBClassGoodsTruckEXTENDSEXTENDSISAISAISAISA作者：冀振燕《UML系统分析与设计教程》13对象关系数据库模型映射实体类映射关联映射聚合映射类属作者：冀振燕《UML系统分析与设计教程》14ORDB--映射实体类staff_id:char(8)staff_name:Namedate_of_birth:dategender:charphone:set(varchar(15))fax:set(varchar(15))structuredtypeStaffTYmonth_wage:integerstructuredtypeFullTimeStaffTYteaching_hours:integerstructuredtypeLecturerTYobjecttableStaffobjecttableLecturerOFOF作者：冀振燕《UML系统分析与设计教程》15ORDB--映射实体类last_name:varchar(20)first_name:varchar(30)mid_name:varchar(20)structuredtypeLongNameTYcp_id:integerphone:set(varchar(15))fax:set(varchar(15))email:set(varchar(20))structuredtypeContactPersonTYlast_name:varchar(20)first_name:varchar(30)rowtypeshort_nameshort_name:rowtypeobjecttableContactPersonresearcher_id:char(8)researcher_name:LongNameTYstructuredtypeResearcherTYobjecttableResearcherOFOF作者：冀振燕《UML系统分析与设计教程》16ORDB--映射关联作者：冀振燕《UML系统分析与设计教程》17ORDB--映射聚合作者：冀振燕《UML系统分析与设计教程》18ORDB--映射类属类属关系CookingBookfood_style:StringDictionarylanguage:StringSoupBookDessertBookEnglishDictionaryPublishingHouseph_name:Stringaddress:StringBooknum_of_copy:Integer0..nTitlebook_name:Stringisbn:Stringauthors:String[]0..n作者：冀振燕《UML系统分析与设计教程》19ORDB--映射类属food_style:varchar(40)structuredtypeCookingBookTYlanguage:varchar(30)structuredtypeDictionaryTYtitle:ref(Title)objecttableD