Data Definition and Customization
Like the rest of The Practical SQL Handbook, this chapter uses the bookbiz database as its main example. Once you've worked your way through this chapter and have come to understand how bookbiz is designed, you'll need to know how to put it online with the SQL CREATE commands—a process called data definition. We discuss data definition in Chapter 3.
Other issues connected to database design and data definition include customization (setting up views tailored to each end user's needs—see Chapter 9), security (deciding whom to authorize for what options on what data—see Chapter 10), and integrity (guaranteeing the consistency of related data items—mentioned here and treated in more detail in Chapters 3 and 10
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.
