Database management serves an organization in numerous ways. In the course of managing an organization’s database, users can create, edit, or update data in database files. Also, in a database that is effectively managed, an organization’s information can be securely stored and retrieved. Lastly, organizational facts and figures can be added, deleted, changed, sorted, and searched in a properly managed database.
In nearly every modern organization, a database plays a key role in supporting the mission along with short and long-term objectives. Keeping an efficient and effective database ensures people will conduct operations well and have good information security. A place with a user-friendly database can make data available to everyone within the organization. With a good database an organization can minimize or even eliminate redundancy of work. Also, organizations with a good database can ensure accuracy in their record keeping.
Computer-aided software engineering (CASE) tools are a class of software that provides automation to the software life cycle. CASE tools are helpful when starting from scratch to construct a new database system. CASE tools are also able to represent the industry-specific database models. With CASE tools, it is also possible to conduct reverse engineering of databases and application systems. Top-down / hierarchical decomposition of a database design can be effectively done with CASE Tools. Using CASE tools Bottom-up / aggregation and assignment of elementary objects to larger units can be done as well. CASE tools can be used to deal effectively with the initial and ongoing documentation of the database design.
Certain CASE tools are used to manage changes in database design. When using these tools it is possible to add new data structures to the database schema and control the overall system functionality using the provided tools. The Upper CASE tool is used when conducting analysis and designing the database. (The Upper CASE tool has the ability to provide various diagrams such as the DFD (Data flow diagram) and ERD (Entity-relationship diagram). DFD is used to create the individual system components such as the input of system, the mechanism of systems, and the results of the system. The ERD is used for bring the data into the system of the report.) The Lower Case Tool supports the database schema generation, program generation, implementation, testing, and configuration management. The Integrated Case Tool tests and combines the Upper CASE tool and Lower CASE tool and implements one database.
Database Processing – Fundamentals, Design and Implementation, Kroenke, David M.
Computer Aided Software Engineering (CASE) tools www.selectbs.com/…/computer-aided-software-engineering-case-tool