1. Discuss the problems associated with duplication of data. How can we eliminat

Question

1. Discuss the problems associated with duplication of data.  How can we eliminate or control them.

2. Database is a model of a user’s view of the word.  How well does should it fit the mental models of the people who are going to use the system?

3. What is the role of SQL in application processing?

4. What are the factors that drive businesses to redesign their existing database systems?

5. What are the consequences of failures and mistakes in maintaining databases? What are the best physical design practices (in terms of hardware and data storage) in your opinion for a given organization?

Explanation / Answer

Duplication of data:

The data duplication is the same piece of data is held in two separate places. This can mean two different fields within a single database. The data duplication occurs in when updating, leading to different copies having different information.

Problems of Data Duplication:

1.wastage of storage

2. more difficult to database operations like update, delete.

3. inconsistent data may occurs.

4.Same type of data will be saved many times when to want to see the data all duplicate results will come

------------------------------------------------------------------------------------------------------------------------------------------------------------

3.

SQL Processing:

SQL processing is the parsing the code and check the syntax of SQL statement, and optimization, row source generation, and execution of a SQL statement. Depending on the statement.

Process of SQL statement Execution:

SQL statement Syntax Check semantic Check Shared pool

optimization row source generation Execution.

------------------------------------------------------------------------------------------------------------------------------------------------------------

4.

Factors for redesign database

Usability:

The usability is the user interface for database, this is one factor to redesign the database management system.

Security:

Security of your data is an essential aspect of any database implementation. Business-sensitive data and any personal information you hold must be stored securely to adhere to regulations and to protect it from loss.

Functionality:

Confirm that the modules available in the data analysis software meet your business requirements. The functionality or modules you should be looking for include:

Automation

Forecasting strategy.

Extract the data

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.