CHAPTER 5Build a Basic Relational Schema

Every database application is built upon a set of related database objects that store the application's data and allow the application to function. This chapter introduces Oracle database objects, such as tables, and discusses the logical concepts of database objects. Discussions of data storage (storage parameters, partitioning, and so on) will come in subsequent chapters of this book. This chapter's topics include the following:

ImageSchemas

ImageTables

Integrity constraints

Views

Sequences

Synonyms

Indexes

Get Hands-On Oracle Database 10g Express Edition for Windows 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.