资源描述:
《数据库系统概论ch2.ppt》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、Chapter2:RelationalModelChapter2:RelationalModelStructureofRelationalDatabasesFundamentalRelational-Algebra-OperationsAdditionalRelational-Algebra-OperationsExtendedRelational-Algebra-OperationsNullValuesModificationoftheDatabaseExampleofaRelationBasicStructureFormally,givensetsD1,D
2、2,….DnarelationrisasubsetofD1xD2x…xDnThus,arelationisasetofn-tuples(a1,a2,…,an)whereeachaiDiExample:Ifcustomer_name={Jones,Smith,Curry,Lindsay,…}/*Setofallcustomernames*/customer_street={Main,North,Park,…}/*setofallstreetnames*/customer_city={Harrison,Rye,Pittsfield,…}/*setofallcit
3、ynames*/Thenr={(Jones,Main,Harrison),(Smith,North,Rye),(Curry,North,Rye),(Lindsay,Park,Pittsfield)}isarelationovercustomer_namexcustomer_streetxcustomer_cityAttributeTypesEachattributeofarelationhasanameThesetofallowedvaluesforeachattributeiscalledthedomainoftheattributeAttribut
4、evaluesare(normally)requiredtobeatomic;thatis,indivisibleE.g.thevalueofanattributecanbeanaccountnumber,butcannotbeasetofaccountnumbersDomainissaidtobeatomicifallitsmembersareatomicThespecialvaluenullisamemberofeverydomainThenullvaluecausescomplicationsinthedefinitionofmanyoperation
5、sWeshallignoretheeffectofnullvaluesinourmainpresentationandconsidertheireffectlaterRelationSchemaA1,A2,…,AnareattributesR=(A1,A2,…,An)isarelationschemaExample:Customer_schema=(customer_name,customer_street,customer_city)r(R)denotesarelationrontherelationschemaRExample:customer(Custo
6、mer_schema)RelationInstanceThecurrentvalues(relationinstance)ofarelationarespecifiedbyatableAnelementtofrisatuple,representedbyarowinatableJonesSmithCurryLindsaycustomer_nameMainNorthNorthParkcustomer_streetHarrisonRyeRyePittsfieldcustomer_citycustomerattributes(orcolumns)tuples(orr
7、ows)RelationsareUnorderedOrderoftuplesisirrelevant(tuplesmaybestoredinanarbitraryorder)Example:accountrelationwithunorderedtuplesDatabaseAdatabaseconsistsofmultiplerelationsInformationaboutanenterpriseisbrokenupintoparts,witheachrelationstoringonepartoftheinformationaccount:storesin
8、formationaboutaccou