Assignment (Please do in 2 days)
From Chapter 8, page 359, Real World Exercise 8.2 (Image attached – one question only about 500 to 700 words)
Link to Textbook:
https://books.google.com/books?id=8dmSSHBKn7wC&printsec=frontcover&source=gbs_ViewAPI#v=onepage&q&f=false
Different Subject – (same as Research paper) (can take up to 3 days to complete)
Discussion – about 350-450 words
Topic: We all had the unfortunate experience of seeing how computers can, at times, make life’s journey about more difficult. This is especially true in knowledge centric workplaces. Describe an example of a very poorly implemented database that you’ve encountered (or read about) that illustrates the potential for really messing things up. Include, in your description, an analysis of what might have caused the problems and potential solutions to them. Be sure to provide supporting evidence, with citations from the literature.
Reply Post 1 – 250 words or more
Designing and managing a database takes more than genuinely putting in it — there are many shifting parts and pieces, and if these aren’t managed properly, you ought to cease up with a system that’s a long way less nice than it was supposed to be. Here are a few common mistakes and recommendations on how to avoid them.
Lack of Naming Standards. A naming preferred is a way of naming files (including these each furnished to and generated through the database) in such a way as to avoid duplicates and be effortlessly understood by using everybody searching at them. Alas, many agencies enable databases to create gibberish — or worse, consequences with identical names and one-of-a-kind content.
Exactly what form your naming standards should take relies upon on the nature of the database and what you sketch to do with it, but common things to include in names are the type of content the file contains, the date and time it used to be created, and a counter that notes how many files of that kind have been made. Companies with a high number of files may additionally do first-rate if the counter is for a set length of time, such as a given day.
Poor Storage of Reference Data. Reference data should in no way be stored in more than one location or the code of an application — both of these are incredibly inefficient. Instead, the statistics all be contained in a single centralized area that can be effortlessly defined and accessed by way of software program that needs to use it.
Lack of Documentation. Every database ought to have clear documentation of all its more than a few components, consisting of changes that are made at a later date. Unfortunately, many databases are constructed beside this, so there’s no easy way to determine out the influence of adjustments or make sure a proposed change will characteristic except breaking the relaxation of the system.
On the vivid side, this is convenient trouble to fix — all you want to do is make sure the database is fully documented for the duration of and after its creation. When human beings want to do something with it, they can pull out the documentation and get right to work, regularly saving time and cash in the process.
References:
Coronel, C., & Morris, S. (2016). Database systems: design, implementation, & management. Cengage Learning.
Harrington, J. L. (2016). Relational database design and implementation. Morgan Kaufmann.
Elmasri, R., & Navathe, S. (2010). Fundamentals of database systems. Addison-Wesley Publishing Company – Yan Zhang
Reply Post 2 – 250 words or more
The database is considered as the organized collection of the underlying data that is generally stored as well as accessed by some electronically innovative technology from the given computer system. The more complex database can be developed by using the formal modeling and design of the underlying techniques. In this respect, the database management system is regarded to be significant software that aims at interacting with all the end users along with the applications and this helps in capturing and analyzing all the relevant data. Sum total of the database can also be referred to the particular database system in which application is associated with the database itself. Thus, in general, it allows data to access easily along with its proper operation and manipulation. According to Harrington, (2016), the database can be used by the organizations as the method related to retrieving, managing and storing the given information. The modern databases can be managed by using the underlying database management system in this regards.
Poorly Implemented Database
Sometimes the developers make mistakes in case of implementing the database. They do not get the idea of using a primary key that is regarded to be one of the most important aspects of database management. In this respect, the primary key value must have the data some rows and for the developers, it not good to use the application data with respect to primary keys. The developers used such values of primary keys that had been sequentially generated by the database upon the row insertion (Coronel & Morris, 2016). It was not changed under some unusual circumstances as well. In case of data arrangement regarding the industry in which the underlying information can be gathered physically, it is considered to be beyond the sphere of imagination for expecting to have some similar information display as the data is being gathered in continuous ways. At the point when this is not comprehended by the architect the issue emerges that time as the creator can’t keep up the best possible ease of use of the database when the volume of information is excessively enormous. This happens in light of the fact that there is an enormous distinction that deals with a number of information every month and a huge number of similar information in a similar timeframe. Such poor treatment of the database makes trouble principally for the learning based working environment in which it is constantly required to comprehend the genuine motivation behind the relevant information.
The solution for Database mistakes
Database mistakes explained above can be mitigated by following some steps. When the data has been shared among multiple rows, it should be moved into another table so that change in one table cannot affect the other significant rows (Shrivastava, Saxena & Patidar, 2017). Here the catalogue related to customers must be split off from the orders given by them only. In this regards, stored procedure overuse is also relevant and useful however for many modern applications, using those procedures is also not good always. The organizations need to use modern ORMs and its related innovative techniques so that stored value procedures can be developed in proper ways.
References
Coronel, C., & Morris, S. (2016). Database systems: design, implementation, & management. Cengage Learning.
Harrington, J. L. (2016). Relational database design and implementation. Morgan Kaufmann.
Shrivastava, R., Saxena, G. K., & Patidar, K. (2017). Implementation Of Unified Query For Big Database Using SQL On Oracle Platform. International Journal of Current Innovation Research, 3(03), 616-621 – Savankumar Patel
Looking for solution of this Assignment?
WHY CHOOSE US?
We deliver quality original papers |
Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected |
Free revisions |
We offer our clients multiple free revisions just to ensure you get what you want. |
Discounted prices |
All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount |
100% originality |
We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI |
On-time delivery |
We will deliver your paper on time even on short notice or short deadline, overnight essay or even an urgent essay |