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.
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. In TENCON 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. In International 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 Chen’s Framework. International Journal of Applied Engineering Research, 12(5), pp.632-636.
To export a reference to this article please select a referencing stye below:
My Assignment Help. (2018). Relational Database: Global Computer Solutions. Retrieved from https://myassignmenthelp.com/free-samples/relational-database-global-computer-solutions.
"Relational Database: Global Computer Solutions." My Assignment Help, 2018, https://myassignmenthelp.com/free-samples/relational-database-global-computer-solutions.
My Assignment Help (2018) Relational Database: Global Computer Solutions [Online]. Available from: https://myassignmenthelp.com/free-samples/relational-database-global-computer-solutions
[Accessed 02 April 2020].
My Assignment Help. 'Relational Database: Global Computer Solutions' (My Assignment Help, 2018) <https://myassignmenthelp.com/free-samples/relational-database-global-computer-solutions> accessed 02 April 2020.
My Assignment Help. Relational Database: Global Computer Solutions [Internet]. My Assignment Help. 2018 [cited 02 April 2020]. Available from: https://myassignmenthelp.com/free-samples/relational-database-global-computer-solutions.
MyAssignmenthelp.com has appointed best assignment experts who are wizards of words. Our writers know every trick of crafting high quality write-ups within a short period. With years of experiences, we have become one of the most prolific assignment help services in the USA. We deliver custom-made help to students with writing different types of assignments. We guarantee total need-based and timely service, and this is why increasing numbers of students prefer to buy assignment online.
Answer: Introduction The paper is a combination of two tasks. First part includes a strategic report on Houzit and the second part includes a marketing plan of Houzit. Systematic structuring is followed in both tasks. Organizational Overview Strategic Directions And Organizational Objectives Vision Statement The vision statement of Houzit is- To be one of the national retail homeware brands, emphasizing on the various home makers&rsqu...Read More
Answer: To Claire Smithfield Subject: Lunch and Learn Session Dear Ma’am, It is in regard to the very recent decision of yours to have informal “Lunch and Learn” sessions. This idea is undoubtedly interesting and I would not decline it in any way. It would be very helpful in creating a critical awareness for the issues right at hand and would also reinforce the overall culture of our company. I believe that these sessions...Read More
Answer: Address Planning Workout of IPv6 subnet for company HQ and each branch from the address block AB12:1640::/51 AB12:1640:0:2000::/51 AB12:1640:0:4000::/51 AB12:1640:0:6000::/51 AB12:1640:0:8000::/51 AB12:1640:0:A000::/51 AB12:1640:0:C000::/51 Address assignment table for the company network HQ Router Subnet ::/51 Network AB12:1640::/51 Default- Gateway AB12:1640::1 ...Read More
Answer: Section 1 Question 1 The project classification and consideration for classification are shown in the following table. Project Classification Consideration Project A Strategic The new service will significantly enhance the strategic direction of the polyclinic Project B Operational This project will enhance the operations of the polyclinic Project C Compliance ...Read More
Answer: System requirements for Smith Antiques System requirement level includes functional and non-functional requirement type. It is important for every system to ensure proper working. The Smith antique needs to have proper management information system that will ensure managing the details. Details regarding every customer needs to be managed properly. The newly developed management information system will also help in understanding the c...Read More
Just share your requirements and get customized solutions on time.
Our writers make sure that all orders are submitted, prior to the deadline.
Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.
Feel free to contact our assignment writing services any time via phone, email or live chat.
Our writers can provide you professional writing assistance on any subject at any level.
Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.
Get all your documents checked for plagiarism or duplicacy with us.
Get different kinds of essays typed in minutes with clicks.
Calculate your semester grades and cumulative GPa with our GPA Calculator.
Balance any chemical equation in minutes just by entering the formula.
Calculate the number of words and number of pages of all your academic documents.
Our Mission Client Satisfaction
expert working good with ratio analysis i got full marks for ratio but overall good presentation.
excellent work by tutor and quality of good work excellent work by tutor and quality of good work excellent work by tutor and quality of good work excellent work by tutor and quality of good work excellent work by tutor and quality of good work
Brilliant work, paid attention to every details, And submitted on time for review.
The report was exceptional. Thank you for helping me with this assignment, and I am very satisfied with the result. The content was exceptional and my grade was exactly what I needed, the writer was very on point and finished my report in a timely ma...