Database Application Development Challenges

True

True

False

<p>False</p> Signup and view all the answers

<p>False</p> Signup and view all the answers

<p>True</p> Signup and view all the answers

<p>True</p> Signup and view all the answers

<p>False</p> Signup and view all the answers

<p>True</p> Signup and view all the answers

<p>False</p> Signup and view all the answers

<p>Data redundancy and inconsistency, difficulty in accessing data, need to write a new program for each new task, data isolation, integrity problems, atomicity of updates, concurrent access by multiple users, and security problems.</p> Signup and view all the answers

<p>Integrity constraints such as account balance &gt; 0 were embedded in the program code rather than being explicitly stated, making it hard to add new constraints or change existing ones.</p> Signup and view all the answers

<p>Deciding on the database schema, finding a 'good' collection of relation schemas, determining what attributes should be recorded in the database, and deciding on the distribution of attributes among the relation schemas.</p> Signup and view all the answers

<p>Uncontrolled concurrent accesses can lead to inconsistencies, such as two people reading a balance and updating it at the same time, as well as security problems and performance issues.</p> Signup and view all the answers

<p>Failures could leave the database in an inconsistent state with partial updates carried out, affecting the atomicity of updates for operations such as fund transfers.</p> Signup and view all the answers