Chapter 11
Using SQL to Implement a Relational Design
Abstract
This chapter covers the elements of the SQL database manipulation language that create, modify, and delete database structural elements: schemas, domains, and tables. There is emphasis on data integrity using column constraints (domain checking, NOT NULL, primary keys, and so on). The chapter also discusses data integrity constraints between tables (referential integrity for foreign keys).
Keywords
SQL
CREATE TABLE
creating relations
CREATE SCHEMA
database constraints
primary keys
foreign keys
referential integrity
entity integrity
modifying relations
database default values
As a complete data manipulation language, SQL contains statements that allow you to insert, modify, delete, and ...
Get Relational Database Design and Implementation, 4th 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.
