AStudentRelationRelationexapmle2值域(Domain)屬性(Attribute)虛值(NullValue)關聯表的種類KeysSuperkey(超級鍵)Primarykey(主鍵)資料庫表格正規化(NormalForm)1stNF第一正規化功能相依(FunctionalDependency)2ndNF第二正規化3rdNF第三正規化其它的正規化交易(Transactions)交易example交易四大特性(ACID)單元性(Atomicity)並行性(Concurrency)隔離性(Isolation)持續性(Durability)實體關係模式(E-RModel)WeakEntity符號一符號二符號三Example1Example2(Relation)Example3(Relation)一般Entity轉換弱Entity轉換1:1Relationship1:NRelationshipM:NRelationshipMultivalueattribute