结构化查询语言Using Relational Databases and SQL.pptVIP

Two Important Goals Minimize data redundancy Minimize data anomalies update : redundant data is not consistently updated in all places insertion : inappropriate dependencies prevent insertion of necessary data. If we did not have a genres table and the titles table enforced a foreign key for titles.genre, we could not insert a blues title deletion : inappropriate dependencies prevent or force inappropriate deletions if xrefartistsmembers.artistID was a not null field, we would have to delete any members whose artists broke up How? Normalization; one of the key topics of CS 422 The Entity-Rela