question : Please speak to the issues of data integrity, consistency, and redundancy that you are discovering and/or trying to keep in mind as you are working through your initial memo of tables and fields for review.
response these answers:1.While I am working through my initial memo of tables and fields, I understand the importance of data integrity, consistency, and redundancy which might affect the use of the data later in the project. It is important to keep in mind that in order to reduce data redundancy and maximize data consistency it is important to build the most effective and safe database the end user will use. Data integrity helps to keep your data searchable and recoverable in the database. Data consistency is required to keep the data consistent and correct while being used.
In fact, a data normalization method can help reduce data redundancy which we will use in the next challenge for our database development.
2.Data integrity, consistency, redundancy
Data integrity, consistency, and redundancy help to design a database that can scale without failure. For example, using the model of “data integrity”, you would be sure to avoid designing relationships between a hypothetical “customer id” and a “warehouse employee id”. The two datasets have nothing in common and would cause issues to the integrity of the database.
Data consistency/redundancy can be problematic, especially if duplicate data exists in a database. If the data is not consistent then how can it be reliable? In addition, a real problem with redundancy is determining which duplicate is most accurate.
Looking for solution of this Assignment?
WHY CHOOSE US?
We deliver quality original papers |
Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected |
Free revisions |
We offer our clients multiple free revisions just to ensure you get what you want. |
Discounted prices |
All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount |
100% originality |
We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI |
On-time delivery |
We will deliver your paper on time even on short notice or short deadline, overnight essay or even an urgent essay |