Chapter 9. Using SQL to Implement a Relational Design
As a complete data manipulation language, SQL contains statements that allow you to insert, modify, delete, and retrieve data. However, to a database designer, the portions of SQL that support the creation of database structural elements are of utmost importance. In this chapter you will be introduced to the SQL commands that you will use to create and maintain the tables, views, indexes, and other structure that make up a relational database.
The actual file structure of a database is implementation dependent, as is the procedure needed to create a database file. Therefore, the discussion in this chapter assumes that the necessary database files are already in place.
Note: You will see extensive ...