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

Database - Coursework Example This allows or revokes access to the database for authorized users only. It also restricts on the actions that authorized users are allowed to perform on the database. This is the main method of securing data in a database. Access to the database mostly requires correct 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 directly or indirectly access the database for manipulation, retrieval or updating of the data. The second issue that is concerned with database security is database vulnerabilities. Threats from a variety of sources such as internet and users should be identified and minimized to reduce the chances of the database security being breached. This could be done through use of firewalls to manage the network traffic in the organization and also, through controlled access to the database for the users. Updates and patches to the databas e management system should be routinely done to help enhance the security 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 record the sales of houses. This and many others 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 System This database system connects a variety of databases in various regions 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, the databases could be located in various regions and then have a central server that synchronizes the operations of the whole system. Each region’s 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 ser ver 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 administration of the distributed system is also easy as it can be done as per region. This makes it easier for database administrators since incase repairs are going on in one area other regions are not affected by the repairs. Troubleshooting and handling