Database Reference
In-Depth Information
●
Data control language (DCL)
statements, which are used to grant
database permissions (or to revoke those permissions) to users and
groups, so the users or groups can perform various operations on
the data in the database
In Chapter 2, we discussed only DML query statements. This chapter de-
scribes and illustrates SQL DDL statements for constructing databases; SQL
DML statements for inserting, modifying, and deleting data; and SQL state-
ments to create and use SQL Views. We also discuss how to embed SQL
statements into application programs and SQL/PSM and how to use SQL/
PSM to create functions, triggers, and stored procedures. SQL TCL and SQL
DCL statements are discussed in Chapter 9.
In this chapter, we use a DBMS product to create the database that we
designed, by creating a
database design
based on a
data model
, in Chapter
6. We are now in the
implementation
step of the
systems development life
cycle (SDLC)
in the
systems analysis and design
process. This is the SDLC
step that we have been working toward all along—building and implement-
ing the database and management information system application that uses
that database. (For an introduction to systems analysis and design, and to
the SDLC, see Appendix B.)
The knowledge in this chapter is important whether you become a data-
base administrator or an application programmer. Even if you will not construct
SQL triggers or stored procedures yourself, it is important that you know what
they are, how they work, and how they influence database processing.
In order to fully understand the DBMS concepts and features we discuss and illustrate in the
chapter, you need to work with them in an installed DBMS product. This
hands on
experience
is necessary so that you move from an abstract understanding of these concepts and features
to a practical knowledge of them and how they are used and implemented.
The information you need to download, install and use the DBMS products discussed in
this topic is in Chapter 10 (introduction to the DBMS products), Chapter 10A (Microsoft SQL
Server 2012), Chapter 10B (Oracle Database 11
g
Release 2), and Chapter 10C (MySQL 5.6).
Portions of these chapters parallel the discussion in this chapter, and illustrate the actual use
of the concepts and features in each DBMS product.
To get the most out of this chapter, you should download and install the DBMS product(s)
of your choice, and then follow your work in each section of this chapter by working through
the corresponding sections of the chapter for your DBMS product.
In Chapter 6, we introduced the View Ridge Gallery, a small art gallery that sells contemporary
North American and European fine art and provides art framing services. We also developed a
data model and database design for a database for the View Ridge Gallery. Our final database
Search WWH ::
Custom Search