Functional*Dependencies*&*
Normalization*for*Relational*DBs
Chapter 7
Contents
2
1
Introduction
2
Functional/dependencies
3
Normalization
Contents
3
1
Introduction
2
Functional/dependencies
3
Normalization
Miniworld
APPLICATION1PROGRAM1
DESIGN
TRANSACTION1
IMPLEMENTATION
Data$requirements
Conceptual$schema
Database$schema
Functional$requirements
Internal$schema
High-level$transaction$
specification
LOGICAL1DESIGN
(DATA1MODEL1MAPPING)
REQUIREMENTS1-COLLECTION1&1ANALYSIS
CONCEPTUAL1DESIGN
PHYSICAL1DESIGN
FUNCTIONAL1ANALYSIS
Application$program
DBMS–independent
DBMS–specific
Application Design Database Design
Overview/of/Database/
Design/Process
4
Introduction
5
}Each%relation%schema%consists%of%a%number%of%
attributes%and%the%relational%database%schema%consists%
of%a%number%of%relation%schemas
}Attributes%are%grouped%to%form%a%relation%schema
}Need%some%formal%measure%of%why%one%grouping%of%
attributes%into%a%relation%schema%may%be%better%than%
another