Relational Database for Global Computer - MyAssignmenthelp.com

Question: Discuss about theRelational Databasefor Global Computer Solutions. Answer: The essay deals with solving the problems that have arisen on course of constructing the database for the Global Computer Solutions. The three type of difficulties that came up during the construction of the database were: Data redundancy, Data constrains and the updating of the data. The first problem was the data redundancy or the duplication of the data in the database. This type of problems can be solved by normalizing the tables of the database and distributing the database into 3NF form. For the normalization procedures the database have to be normalized into 1NF form at first and data redundancy is to be removed. After the procedure the tables are to further broken into 2NF form and the duplication of the data is to be removed and also the table is to broken into 3 NF form finally and the transitivity of the data is to be implemented. In addition to this the tables can be fragmented into different forms and according to the functionalities and the functional dependencies of the attributes of the different entities. In addition to this the data constrains also came up during the construction of the databases. These were solved by the properly defining the data into separate data types and also the range of the data are to defined properly in order to solve this kind of issues. In addition to this, the data dictionary is to be defined efficiently and hence this type of difficulties can be solved easily. The definition of the foreign keys and the candidate keys properly also can resolve the issues efficiently. In addition to this the super keys and the keys that do not have much effect to the database are also to be identified. In addition to all this updating the data also causes a huge amount of difficulties in the databases. Updating or deleting the data in a single data can creating problems for the other tables. The other tables having the same attributes would be facing data anomalies in the table. Hence this issue is to solved by defining the data dictionary and the relationship models of the database efficiently. The EER Diagrams are no efficiently drawn and are also to be understood properly before the implementation of the database. This would be helping resolving the issues that are related with the database and also increasing the database efficiency of the database. In addition to this it would help the users to store the data properly. For conclusion it can be said that, there were several type of problems that had arisen during the construction of the database but they were solved efficiently. The major problems that were identified were Data redundancy, data updating techniques and also data constrains. The solutions of the problems were provided in the essay efficiently and the solutions would be increasing the efficiency and the performance of database to a certain level. Bibliography Mitrovic, A. and Suraweera, P., 2016. Teaching Database Design with Constraint-Based Tutors.International Journal of Artificial Intelligence in Education,26(1), pp.448-456. Alabbasi, S., Ahmed, A., Kaneko, K., Rebeiro-Hagrave, A. and Fukuda, A., 2014, October. Data types managed database design for dynamic content: A database design for Personal Health Book system. InTENCON 2014-2014 IEEE Region 10 Conference(pp. 1-5). IEEE. Bugiotti, F., Cabibbo, L., Atzeni, P. and Torlone, R., 2014, October. Database design for NoSQL systems. InInternational Conference on Conceptual Modeling(pp. 223-231). Springer International Publishing. Shin, K., Hwang, C. and Jung, H., 2017. NoSQL Database Design Using UML Conceptual Data Model Based on Peter Chens Framework.International Journal of Applied Engineering Research,12(5), pp.632-636.