9. DATA DEFINITION LANGUAGE (DDL)

9.2: Example

In this chapter we will create the tables for a Library database using DDL. Suppose we require the three tables: Book, Patron, Borrow:

image
                Figure 9.2: Sample database to create

The above diagram (produced from the Relationships Tool) represents the database we wish to create but where we will do so using DDL commands.

License

Share This Book