ECE356 Lecture Notes - Lecture 8: Mcgraw-Hill Education, Whiteboard, Enu

• School: University of Waterloo
• Department: Electrical and Computer Engineering
• Course: ECE356
• Professor: Zarnett

Document Summary

We have talked at some length about the tools for de ning the database, but we really should spend signi cant time on good design. Knowing how hammers work is not enough; we also need to understand what good architectural plans look like. The rst thing we would like to watch out for is redundancy in the database and eliminate it wherever possible. In short, if there is redundant data then there is the potential for data to get out of date or be in some other inconsistent state. When we have some data that we would like to represent we need to turn it into some database tables. Going directly from some ideas about what data we need to the tables is sometimes di cult and may produce undesirable results. Instead, we should devise a plan for how it should be implemented and for that we will create diagrams.