More on Keys and Constraints

  • Clare Churcher


In previous chapters, you have seen how to take a class diagram and represent it as a set of relational database tables. We looked at how to represent relationships between classes with primary and foreign keys and then applied the ideas of normalization to ensure the attributes were in the right tables. In this chapter, we take another look at some of these ideas and think about some alternative possibilities. In particular, we take a closer look at primary keys and how to choose them. We also take a look at how we can maintain referential integrity when data is being constantly updated.


Expense Resi Creatin Smit Tonsillitis 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Clare Churcher 2012

Authors and Affiliations

  • Clare Churcher

There are no affiliations available

Personalised recommendations