Structuring Database for Accounting

example, an attempt to add another record of an account with data values corresponding to Code, Name and its Type to Accounts relation shall be made by performing Insert operation. The insert operation is capable of violating any of the four constraints discussed above. (b) Delete : This operation is carried out to remove a tuple from a relation. A particular data record from a table can be removed by performing such a operation. The delete operation can violate only referential integrity, if tuple being removed is referenced by foreign key from other tuples in the database. (c) Modify : The operation aims at causing a change in the values of some attributes in existing tuples. This is useful in modifying existing values of an accounting record in a data table. Usually, this operation does not cause problems provided the modification is directed on neither primary key nor foreign key. Whenever applied, these operations must enforce integrity constraints specified on relational database schema. Retrieval operation on Relational Data Model does not cause violation any integrity constraints. . Designing Relational Database Schema The rules or guidelines required to design the relational database schema attempt