Other Database Definition Considerations
If you were about to put a real-world database online, you'd have several additional critical issues to consider before proceeding: indexing, security, and integrity.
Deciding which columns to index and what kind of index is best for each column is an important part of database implementation. It is covered in Chapter 3.
Security is discussed in Chapter 10.
Planning for data integrity is a major part of database design. It involves setting up a system to make sure changes to one piece of data apply to all copies of that data anywhere in the database, so that you won't end up with orphans or inaccuracies. An example using bookbiz might be discovering that an author's ID number was incorrect. If you changed ...
Get Practical SQL Handbook, The: Using SQL Variants, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
