Use of CASE Tools - Database Design and Development: An Essential Guide for IT Professionals - page 689

Function modeling
GUI development
Impact analysis
Information engineering
Java development
Metamodeling
Object modeling
Object-oriented analysis and design
Object-oriented modeling
Performance monitoring
Performance simulation
Problem tracing
Process management
Process modeling

Program profiling
Project management
Prototyping
Rapid application development
Report generation
Requirements engineering
Reverse engineering
Runtime error checking
Simulation
SQL code generation
Structured analysis and design
Test case generator
Test management
Version management

In the study of database design and development, however, we are more interested
in the tools that aid in the design, development, and implementation of database
systems. This appendix highlights the major features of CASE tools applicable to
the database development life cycle (DDLC).

LOGICAL DATA MODELING

• Defining and naming entities and attributes
• Selecting primary keys
• Designating alternate key attributes
• Defining one-to-one and one-to-many relationships
• Resolving many-to-many relationships
• Specifying special relationship types ( n -ary, recursive, subtype)
• Defining foreign keys and specifying identifying and nonidentifying
relationships
• Establishing referential integrity constraints
• Completing the entity-relationship diagram (ERD)

PHYSICAL DATA MODELING (for the relational model)

• Transforming entities into tables
• Converting attributes into columns
• Assigning primary and foreign keys
• Defining data validation constraints
• Defining triggers and stored procedures for business rules
• Including triggers for INSERT, UPDATE, and DELETE to preserve referen-
tial integrity
• Set data types based on target DBMS