tailieunhanh - Chapter 7: Functional Dependencies

Chapter 7: Functional Dependencies presents about Informal Design Guidelines for Relational Databases (Semantics of the Relation Attributes, Redundant Information in Tuples and Update Anomalies, Null Values in Tuples, Spurious Tuples), Functional Dependencies (FDs). | Chapter 7 Functional Dependencies Copyright 2004 Pearson Education Inc. Outline Informal Design Guidelines for Relational Databases - Semantics of the Relation Attributes - Redundant Information in Tuples and Update Anomalies - Null Values in Tuples - Spurious Tuples Functional Dependencies FDs - Definition of FD - Inference Rules for FDs - Equivalence of Sets of FDs - Minimal Sets of FDs Slide 7 -2 Elmasri Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Ramez Elmasri and Shamkant Navathe Informal Design Guidelines for Relational Databases 1 What is relational database design The grouping of attributes to form good relation schemas Two levels of relation schemas - The logical user view level - The storage base relation level Design is concerned mainly with base relations What are the criteria for good base relations Elmasri Navathe Fundamentals of Database Systems Fourth Edition Slide 7 -3 Copyright 2004 Ramez Elmasri and Shamkant .