Databases Reference
In-Depth Information
IMPLEMENTING
A DATABASE
Starting Point
Go to
www.wiley.com/college/gillenson
to assess your knowledge of database
implementation.
Determine where you need to concentrate your effort.
What You'll Learn in This Chapter
▲
Physical data design requirements
▲
Tools for creating database objects
▲
Data integrity and database performance design requirements
▲
Database object implementation
After Studying This Chapter, You'll Be Able To
▲
Recognize data integrity issues
▲
Recognize potential performance issues
▲
Modify a database design to address business requirements
▲
Use SQL language commands to create objects
▲
Use graphical utilities to create objects
▲
Enforce domain integrity
▲
Enforce entity integrity
▲
Enforce relational integrity
▲
Create tables, indexes, and views based on physical design requirements