Purchase Solution

Discussing Logical Design: Normalization of Databases

Not what you're looking for?

Ask Custom Question

The figure in the attached document illustrates the relationship between Data Modeling and the systems development life cycle. In Logical Design, there is a process called normalization. Please describe what this is in your own words.

Attachments
Purchase this Solution
Solution Summary

The solution shows a brief discussion on normalization process in databases.

Solution Preview

For databases, normalization is vital and necessary. It means getting rid of unnecessary data. More often than not, there are database designers ...

Purchase this Solution
Free BrainMass Quizzes
Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Operations Management

This quiz tests a student's knowledge about Operations Management

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

View More Free Quizzes
Related BrainMass Solutions

  • Database Concept

    Data normalization also may improve data consistency and simplify future extension of the logical data model.

  • Bottom-up vs Top-down Database Design

    The acceptable process in Database Design, 1. Do a clean logical design first. Then, as a separate and subsequent step 2. Map that logical design into whatever physical structures the target DBMS happens to support. References: 1. Date, C. J.

  • Database design process

    Next the the logical design of the database in the form of relational scheme is developed. This produces the logical design. Next, redundancies are eliminated and anomalies are updated. This process is called normalization.

  • Discussing the Concept of Normalization

    44291 Discussing the Concept of Normalization Question: In your own words, explain the concept of normalization. What does normalization accomplish? What are the advantages of normalization?

  • Normalization Techniques a Database

    Logical database design, also referred to as the logical model, is the process of arranging data into logical, organized groups of objects that can easily be maintained.

  • Normalization within Database

    To accomplish normalization, formal rules are applied either by synthesis or decomposition. "Synthesis creates a normalized database design based on a known set of dependencies".

  • Database Re-Engineering and Redesign

    Explain what should be done when adding tables and relationships for normalization. 1. Explain why database re-engineer and redesign is necessary. Most database design work involves redesigning existing databases.

  • Database System Design and Implementation

    Normalizing allows information to be automatically updated across normalized databases. The design helps make it easier for the sales person or others using the database.

  • Normalization and Denormalization

    As databases have evolved and more and more critical data is being stored normalization is extremely important, not only for accurate reporting, but for size of the database.

View More Related Solutions