"

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

Icon for the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

Relational Databases and Microsoft Access 365 Copyright © by Ron McFadyn is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.

Share This Book