Books for you

Finally, the process of normalization includes the creation of foreign key relationships
and other data constraints. These relationships build a level of data integrity
directly into your database design.
Figure 4-3 shows a simple list of attributes grouped into entities and linked by a foreign
key relationship.
Figure 4-3. The normalization process
Job name
Title
Employee number
Employee name
Hire date
Salary
Commission
Department number
Department name
Location
104 | Chapter 4: Oracle Data Structures
However, there is an even more important reason to go through the process of
designing a normalized database. Youcan benefit from normalization because of the
planning process that normalizing a data design entails. By really thinking about the
way the intended applications use data, you get a much clearer picture of the needs
the system is designed to serve. This understanding leads to a much more focused
database and application.
Gaining a deep understanding of the way your data will be used also helps with your
other design tasks.


Pages:
220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244