IT163 BD Unit 2 Research Paper Example | Topics and Well Written Essays - 250 words

IT163 BD Unit 2 - Research Paper Example The objectives and needs of the enterprise must be considered when making decision on what to use in a distributed relational database. How the application program is going to be coded, where it resides in regard to the data and the network design that merges or connects the application program are all very important design considerations. Database design in a distributed relational database is more complex than when dealing with the I series relational database. It is important to understand the purpose of the business or the organization for which the database is to belong and the relational database technology. Operations that necessitate particular attentions when forming your strategy include general operations, networking protocols, system security, accounting, problem analysis and backup and recovery processes involved. Of great importance is to avoid replica of rows of the same data available in a database. This is referred to as data redundancy. Data redundancy gives problems to IT departments responsible for database management. Redundancy can be avoided by the use of keys in tables. For example, in the database of an organization for accessing and storing employees’ data, then for each employee we have a defined primary key condition for employee number. If an attempt is made to enter a second row of the same data for the employee the system should