Database Coursework Example | Topics and Well Written Essays - 1250 words

Database - Coursework ExampleThis allows or revokes entree to the database for authorized users only. It also restricts on the actions that authorized users atomic number 18 allowed to perform on the database. This is the main method of securing data in a database. Access to the database mostly requires conform username and a password which is assigned by the database administrator. The database administrator identifies legitimate users of the database and assigns each a passwords that they use to outright or indirectly access the database for manipulation, retrieval or updating of the data. The second issue that is concerned with database trade protection is database vulnerabilities. Threats from a variety of sources such(prenominal) as internet and users should be identified and minimized to reduce the chances of the database certificate being breached. This could be done through use of firewalls to manage the network traffic in the brass and also, through controlled access to the database for the users. Updates and patches to the database management system should be routinely done to help enhance the certificate of the database. The database administrator should be updated on the current trends of security so that he/she can mend the database where such vulnerabilities occur. The third aspect on database security is auditing. ... For instance, in the case of Happy Homes Ltd, applications could be used to study the sales of houses. This and many another(prenominal)s are potential sources of database threats as they may leave vulnerabilities in the database. The database administrator should be in a position to determine the permissions of the applications so that he/she can regulate them (Alfred Basta, 2011). Distributed Database Management governance This database system connects a variety of databases in various parts over a network and operates in a way that the users are not aware of the distributed databases. In the case of Happy Homes Ltd, t he databases could be located in various regions and then have a central server that synchronizes the operations of the whole system. Each regions database handles information related to that region and when there is need, it shares its resources with other database system s in other regions. A sample diagram for the Happy Homes Ltd could be defined as In each region, a server helps in the management of the regional system. It also helps in communication among the various regional offices and to the main server. Data is stored in the database at a given region. A backup copy of these data is stored in the main database system at the organization headquarters. Storage of data in these areas helps in easier and quicker access to the data. Centralizing the data in one area reduces the system performance as compared to distributed system. Maintenance and disposal of the distributed system is also easy as it can be done as per region. This makes it easier for database administrators sin ce incase repairs are going on in one area other regions are not affected by the repairs. Troubleshooting and handling