(Mt) – Lamar Community College Poorly Implemented Database Discussion

FIND A SOLUTION AT Academic Writers Bay

Answer all the questions. Use APA format with more than 300 words and at least 3 references Question 1: 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 exle 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 Answer: Your post should be 300 words long (40 points). Please use APA throughout. Question 2 : Response by: Samantha Gudala Poorly implemented database I worked in one of the corporate jobs, working for the Reuters Group. It was the world’s biggest newswire and furthermore the 2nd largest supplier of business/money related data and data after Bloomberg. We had an inheritance database that had been meticulously structured, constructed, and increased over the better piece of 10 years. In 2007 we went into a merger with the Thomson Corp which prompted us consolidating our 2 heritage databases to control more than 100 diverse money related items. The outcome was driven by long stretches of incapable administration, varying dreams for the new organization, and plain inability from the higher administration. A few significant database choices were taken basically on the perspective on whoever was the senior-most in the stay with no respect to showcase real factors. The association kept on utilizing similar databases to construct their up and coming age of items which were, at last, ineffective and prompted the loss of more pieces of the overall industry. As per Dittrich (2007), a database is incorporated so that it permits clients to get to the necessary data without superfluous migraines. This was a key perspective that was overlooked by the senior administration at Thomson Reuters. Choices were made based on what might be the least expensive to structure and actualize. This made a troublesome circumstance as the more established and increasingly obsolete databases were held in that had a bigger bank of data that would not require moving. An answer to the above circumstance would have been to make a one-time venture that would have been utilized to make another database that would consolidate the best of each inheritance database and item. Answer : Please add your comments whether you accepting the response or against the response depending upon the question in more than 200 words. Below are additional suggestions on how to respond to your classmates’ discussions: · Ask a probing question, substantiated with additional background information, evidence or research. · Share an insight from having read your colleagues’ postings, synthesizing the information to provide new perspectives. · Offer and support an alternative perspective using readings from the classroom or from your own research. · Validate an idea with your own experience and additional research. · Make a suggestion based on additional evidence drawn from readings or after synthesizing multiple postings. · Expand on your colleagues’ postings by providing additional insights or contrasting perspectives based on readings and evidence. Question 3: Response by: Chaitanya Parvath Before writing anything about a poorly implemented database, I am a developer and I have done mistakes in implementing database design. I am writing this from my experience and the advices that my colleagues gave me. Below are the few of the bad practices that I have done and/or came across in my career. • • • • • • Lack of planning Ignore/poor normalization No/Not sufficient documentation Using only primary key as identifier Poor testing Poor database naming conventions I have done most of the above and learned from my experience. The very bad practice that took so much time for me to correct myself was poor naming convention. Let us take an exle of a florist database. In the database they have called rose as “dung”, but the customer asks it as “rose”. This would cause so much confusion for the people when they are in meetings and talking about the rose. Names, of course, are personal choice, play a very important role in the database design and they should be documented. Naming convention should be user friendly and should explain the purpose of the data being represented by the name. If future or any new user working on a database that was already designed, they should not need to go through a 200-page document to understand a whacky name (Gehani, #038; Annamalai, 2011). For exle, what does the name 456_dscr mean in the world? Few companies set some key word standards such as dscr for description. In that cases, that name would be acceptable, otherwise I would suggest going with 456_description to make it readable and understandable. Along with that, spaces in the names are not recommended as they would create problems while scripting. For exle, to represent the data for model number, the best database names would be modelNumber, model_number, ModelNumber and not Model Number or model number. One more thing is consistency. To maintain consistency, companies should set standards on how the naming conventions should be for a database (Teorey, Lightstone #038; Nadeau, 2006). Otherwise each developer would name the database components in a different, which creates issues and not simply necessary. Answer : Please add your comments whether you accepting the response or against the response depending upon the question in more than 200 words. Below are additional suggestions on how to respond to your classmates’ discussions: · Ask a probing question, substantiated with additional background information, evidence or research. · Share an insight from having read your colleagues’ postings, synthesizing the information to provide new perspectives. · Offer and support an alternative perspective using readings from the classroom or from your own research. · Validate an idea with your own experience and additional research. · Make a suggestion based on additional evidence drawn from readings or after synthesizing multiple postings. · Expand on your colleagues’ postings by providing additional insights or contrasting perspectives based on readings and evidence. Question 4: Response by: Krishna Mudam A very poorly implemented database that encountered In an association, there are numerous people who are away at various modules, models, and tasks. At the point when an engineer is playing out an errand, he should initially have the option to comprehend the data model of an application to fathom the issues or face the difficulties. Especially when working with databases where tables, segments, values, capacities, methodology, triggers are included then every individual included discover approaches to improve the put-away data (Chaturvedi, 2019). The principal reason for the data stockpiling is to recover it later. To get the put-away data when required the database originator must know about data that is accessible, by what means would that be able to be obtained, worked, capacity sum, and how it will be utilized. Planning a database and applying all the standards and standardization procedures to an issue is a significant assignment. At the point when this errand is given to two database fashioners, they create two unique structures. These two database configuration structures follow the methods of programming designing and are imaginative in their own specific manner. Picking the correct database structure that performs at its best and works viably is the correct decision to make. Repetitive fields and tables follow the rationale to keep all the stockpiled exceptional. This repetition procedure in the database must be utilized uniquely in explicit cases for future turns of events. At the point when this procedure isn’t implemented appropriately, it brings about an expansion in database size which at last reductions the productivity of database prompting data debasement. So, database configuration accomplishes the best outcomes just when structured with information and experience. Following database plan rules to dodge all the dangers is the best practice to build up a composed database structure. Answer : Please add your comments whether you accepting the response or against the response depending upon the question in more than 200 words. Below are additional suggestions on how to respond to your classmates’ discussions: · Ask a probing question, substantiated with additional background information, evidence or research. · Share an insight from having read your colleagues’ postings, synthesizing the information to provide new perspectives. · Offer and support an alternative perspective using readings from the classroom or from your own research. · Validate an idea with your own experience and additional research. · Make a suggestion based on additional evidence drawn from readings or after synthesizing multiple postings. · Expand on your colleagues’ postings by providing additional insights or contrasting perspectives based on readings and evidence.

• WE OFFER THE BEST CUSTOM PAPER WRITING SERVICES. WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU.
• Assignment status: Already Solved By Our Experts
• (USA, AUS, UK ; CA PhD. Writers)
• CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS

QUALITY: ORIGINAL PAPER – NO PLAGIARISM - CUSTOM PAPER

Why Choose Us?

How It Works

• Click on the “Place Your Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
• Fill in your paper’s requirements in the "PAPER DETAILS" section.
• Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
• Click “CREATE ACCOUNT ; SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
• From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.

About AcademicWritersBay.com

AcademicWritersBay.comnbsp;is an easy-to-use and reliable service that is ready to assist you with your papers 24/7/ 365days a year. 99% of our customers are happy with their papers. Our team is efficient and will always tackle your essay needs comprehensively assuring you of excellent results. Feel free to ask them anything concerning your essay demands or Order.

AcademicWritersBay.com is a private company that offers academic support and assistance to students at all levels. Our mission is to provide proficient andnbsp;high quality academic servicesnbsp;to our highly esteemed clients. AcademicWritersBay.com is equipped with competent andnbsp;proficient writersnbsp;to tackle all types of your academic needs, and provide you with excellent results. Most of our writers are holders ofnbsp;master's degreesnbsp;ornbsp;PhDs, which is an surety of excellent results to our clients. We provide assistance to students all over the world.
We provide high quality term papers, research papers, essays, proposals, theses and many others. Atnbsp;AcademicWritersBay.com, you can be sure ofnbsp;excellent gradesnbsp;in your assignments and final exams.