Discuss about the normalization in the database

Assignment Help Management Information Sys
Reference no: EM132078224

The database is the core of any company. All the report that the company trades with is saved in form of database. A thoughtfully designed database makes it easier to retrieve relevant information quickly.

Additionally, a well-designed database makes it easier for future database administrators to manage it without having to spend hours figuring out what is what.

Although it seems like organizations should spend enough time in planning and get everything right, there are some very common database design mistakes that are made in a rush to get everything implemented quickly due to time constraints.

Insufficient planning and design: As mentioned above, since databases are the crux of any project, DBA's should spend enough time mapping the needs of the database not only for current requirements but anticipate future needs. Else the team will spend a lot of future time coming up with hot fixes for future needs.

• Normalization: Normalization refers to defining relationships of how the data interacts with each other. For e.g.: Shared data should be part of the same table. Improper normalization results in data not being stored properly which gets very confusing when retrieved.

• Poor naming standards: This is one of the most common mistakes that the developers make while designing a database. Naming standards are most often a personal choice that is made by the designers.

The names chosen should be standardized and normalized so that it makes the most sense for future administrators/ programmers to figure out without having to spend hours going through the documentation.

One of the articles that I read about on poor naming convention being used was in Boston public schools (Zwicker, A. (n.d.)). The school's database table had used "year" in the primary school table name.

The understanding at that time was that a new database would be created in the subsequent year which will not have an embedded year in it.

Reference no: EM132078224

Questions Cloud

How did their tat improve : If Starbucks had the exact same level of sales, debt, and profit in 2017 as they did in 2016, how did their TAT improve?
The responsibility of good foods during implementat : Detailed the responsibility of Good Foods during implementation, as it relates to each cloud delivery model, including system requirements.
Describe the organization you are evaluating : Identify and describe the organization you are evaluating. Provide an overview of the industry within which the organization operates.
Ways toyotaism demonstrates both scientific management : What are some of the ways Toyotaism demonstrates both Scientific Management and Human Resources Theory? Why is it so effective?
Discuss about the normalization in the database : Normalization refers to defining relationships of how the data interacts with each other. For e.g.: Shared data should be part of the same table.
Discuss specific current enterprise strategic requirements : Discuss the specific current or future enterprise strategic requirements that could benefit from the emerging technologies. Discuss the potential benefits.
Project management is the application of knowledge-skills : Project management is the application of knowledge, skills, tools, and techniques to project activities to meet the project requirements.
Advantages of project integration management : What are the advantages of project integration management?
An analysis of what might have caused the problems : In your description, an analysis of what might have caused the problems and potential solutions to them.

Reviews

Write a Review

Management Information Sys Questions & Answers

  Information technology and the changing fabric

Illustrations of concepts from organizational structure, organizational power and politics and organizational culture.

  Case study: software-as-a-service goes mainstream

Explain the questions based on case study. case study - salesforce.com: software-as-a-service goes mainstream

  Research proposal on cloud computing

The usage and influence of outsourcing and cloud computing on Management Information Systems is the proposed topic of the research project.

  Host an e-commerce site for a small start-up company

This paper will help develop internet skills in commercial services for hosting an e-commerce site for a small start-up company.

  How are internet technologies affecting the structure

How are Internet technologies affecting the structure and work roles of modern organizations?

  Segregation of duties in the personal computing environment

Why is inadequate segregation of duties a problem in the personal computing environment?

  Social media strategy implementation and evaluation

Social media strategy implementation and evaluation

  Problems in the personal computing environment

What is the basic purpose behind segregation of duties a problem in the personal computing environment?

  Role of it/is in an organisation

Prepare a presentation on Information Systems and Organizational changes

  Perky pies

Information systems to adequately manage supply both up and down stream.

  Mark the equilibrium price and quantity

The demand schedule for computer chips.

  Visit and analyze the company-specific web-site

Visit and analyze the Company-specific web-site with respect to E-Commerce issues

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd