Abstract
We are doing pretty well at designing a database. So far, you have learned how use cases and a data model can help you understand many of the complexities of the actual problem you are trying to represent. In the previous chapter, you saw how to represent the main parts of the data model in a relational database. To recap:
-
Each class is represented by a table
-
Each object becomes a row in a table
-
For each table, we determine a primary key, which is a field(s) that uniquely identifies each row
-
We use the primary key field(s) to represent relationships between tables by way of foreign keys
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Edgar F. Codd, (June 1970). “A Relational Model of Data for Large Shared Data Banks.” Communications of the ACM: 13(6): pp. 377–387.
Rights and permissions
Copyright information
© 2007 Clare Churcher
About this chapter
Cite this chapter
(2007). Normalization. In: Beginning Database Design. Apress. https://doi.org/10.1007/978-1-4302-0366-7_8
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0366-7_8
Publisher Name: Apress
Print ISBN: 978-1-59059-769-9
Online ISBN: 978-1-4302-0366-7
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books