Unit 4 Students Nam Institutional Affiliation 1. Explain how databases help ensure that organizations can maintain data integrity. Data integrity is the consistency and accuracy of information stored in a data warehouse or a database. Integrity is also used in place of data quality because for data to be termed as one with integrity the information is inexperience. Data mining dramatically assists in the analysis of data in such situations. Data mining also helps in the processing of data quickly thus reduce time wastage. References Micheline J. ( 2013). Data Mining: Concepts and Techniques (3rd ed.). Morgan Kaufmann Ullman J. (2017). A First Course in Database Systems. PrenticeHall.
Each needs to be minimum 75 words.
1. Explain how databases help ensure that organizations can maintain data integrity.
Data integrity is enforced in both hierarchical and relational database models. The following three integrity constraints are used in a relational database structure to achieve data integrity:
The concept of data integrity ensures that all data in a database can be traced and connected to other data. This ensures that everything is recoverable and searchable. Having a single, well-defined and well-controlled data integrity system increases stability, performance, reusability and maintainability. If one of these features cannot be implemented in the database, it must be implemented through the software.
2. Explain the importance of internal tools that are available within a DBMS. Please provide an example of one of these tools.
A data dictionary was defined as a DBMS component that stores the definition of data characteristics and relationships. You may recall that such data about data are called metadata. The DBMS data dictionary provides the DBMS with its self-describing characteristic.
CASE is the acronym for computer-aided systems engineering. A CASE tool provides an automated framework for the Systems Development Life Cycle (SDLC). CASE uses structured methodologies and powerful graphical interfaces. CASE tools are usually classified according to the extent of support they provide for the SDLC. For example, front-end CASE tools provide support for the planning, analysis, and design phases; back-end CASE tools provide support for the coding and implementation phases. The benefits associated with CASE tools include:
A reduction in development time and costs.
Automation of the SDLC.
Standardization of systems development methodologies.
Easier maintenance of application systems developed with CASE tools
3. What is the relevance of data mining in organizations?
Data Mining is largely used in several applications such as understanding consumer research marketing, product analysis, demand and supply analysis, e-commerce, investment trend in stocks & real estates, telecommunications and so on. Data Mining is based on mathematical algorithm and analytical skills to drive the desired results from the huge database collection.