Database Reference
In-Depth Information
Database
In Chapter 5, we discussed how to create a data model for a new da-
tabase, and in Chapter 6, we demonstrated how to transform that data
model into a database design that we can use to build an actual database
in a relational DBMS. We used the View Ridge Gallery (VRG) database as
our example in Chapter 6 and finished with a complete set of specifica-
tions for the VRG database. In Part 3, we will implement the VRG data-
base design in SQL Server 2012 (with versions for Oracle Database 11
g
Release 2 and MySQL 5.6 shown in Chapters 10B and 10C, respectively).
Part 3 consists of two chapters. Chapter 7 presents SQL data definition
language statements for constructing database components and describes
the SQL data manipulation statements for inserting, updating, and deleting
data. You will also learn how to construct and use SQL views.
The chapter concludes with an introduction to embed-
ding SQL statements in application programs and
SQL/Persistent Stored Modules (SQL/PSM),
which leads to a discussion of SQL triggers
and stored procedures.
Chapter 8 presents the use of
SQL statements to redesign data-
bases. It presents SQL correlated
subqueries and then introduces
SQL statements using the SQL
EXISTS and NOT EXISTS key-
words. Both of these advanced
SQL statements are needed for
database redesign. Chapter 8
also describes database re-
verse engineering, surveys
common database redesign
problems, and shows how to
use SQL to solve database
redesign problems.
3
Search WWH ::
Custom Search