Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Chapter 10 present functional dependencies and normalization for relational databases. This chapter includes contents: Informal design guidelines for relational databases, functional dependencies (FDs), normal forms based on primary keys, general normal form definitions (For Multiple Keys), BCNF (Boyce-Codd Normal Form). | DATA B A sE SYSTEMS FOURTH EDITION ELMASRI NAVATHE Chapter 10 Functional Dependencies and Normalization for Relational Databases PEARSON Addison Wesley Copyright 2004 Pearson Education Inc. Chapter Outline 1 Informal Design Guidelines for Relational Databases 1.1Semantics of the Relation Attributes 1.2 Redundant Information in Tuples and Update Anomalies 1.3 Null Values in Tuples 1.4 Spurious Tuples 2 Functional Dependencies FDs 2.1 Definition of FD 2.2 Inference Rules for FDs 2.3 Equivalence of Sets of FDs 2.4 Minimal Sets of FDs Elmasri Navathe Fundamentals of Database Systems Fourth Edition Chapter 10-3 Copyright 2004 Ramez Elmasri and Shamkant .
