| Lesson 8 || Database design tools |
| Objective || Explain the Use of CASE tools in Database Design |
Database Design Tools
A CASE tool can not design a database.
Only a database designer can examine a database environment and decide which business objects and business rules ought to be represented in a database.
A set of rules or conditions describing the business polices that apply to the data stored on a company databases.
The next lesson concludes this module.
CASE (Computer-Aided Software Engineering) packages are software packages that include many tools that can be helpful when it comes to database design.
The main goal of these packages is to give designers a way of representing systems that are too complex to understand in their source code or schema-based forms.
They help automate software development and maintenance tasks and usually contain tools for system analysis, project management, and design.
Uses of CASE Tools in Databases
CASE tools can serve many functions in database design, including:
- Collecting and analyzing data
- Designing a data model
- Feasibility analysis
- Requirements definition
- Implementing the database
- Data conversion
- Generating application code
- Generating reports
- Programming and testing
Advantages of Case Tools
CASE tools can provide many advantages when used in database design, including:
- Improved productivity in development
- Improved quality through automated checking
- Automatic preparation and update of documentation
- Encouragement of prototyping and incremental development
- Automatic preparation of program code from requirements definition
- Reduced maintenance systems
Disadvantages of Case Tools
However, there are also some disadvantages to using the tools in database design, including:
- Cost increase
- Need for specialized training
- Limitations in flexibility of documentation
- Inadequate standardization
- Slow implementation
- Unrealistic expectations
Items in a business environment that are related, and about which data need to be stored (e.g., customers, products, orders, etc.)